September 26, 2008 at 2:55 pm
Today I saw reports created by someone where they listed data and also had links in each row that allowed for deletion of records. When clicked, it appeared that the report reloaded in the same window and that record was indeed deleted. Anyone have any clue on how to achieve this functionality?
September 27, 2008 at 6:58 am
One method we used in the past when doing Lotus Domino development was to format the report rows as html and the link called an agent similar to a web service call which would parse the query string and perform actions at the database level such as a delete. Now I have not done anything like this in reporting services and don't know if the functionality exists, but maybe it's possible. I would be very curious if anyone knows if this is possible.
September 29, 2008 at 4:10 am
Hi,
As far as i know, there is no functionality like deleting or updating database records from reporting services.
Thanks
September 29, 2008 at 3:03 pm
I figured out how they did it. The sp that is called for the main dataset has several parameters that by default are null, but if something is passed into them (i.e. @delete_record_id parameter), it will perform the data modification, then return the results. This is called by creating navigation links to the report itself, but by specifying parameters, you can perform updates, deletes, or other simple changes.
September 30, 2008 at 9:45 am
Yes, this is something often overlooked by many when working with SSRS. I've done similar things in the past where we had a report of 'errors' in some data that had been imported. There was a team that would look at the report daily and correct any errors then click a link that would jump to another report which called a SP that did the delete.
When you break it down, SSRS is a web app that can run parameterized queries across many platforms. Just because it's a reporting tool, doesn't necessarily mean that it must be a select statement...
😉
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply