Add a .NET Button in a Report
Hello Reporting Services community :)
i have a simple question and i don't find an answer.
1 ) I want to do a report, this report will be seen using Sharepoint Report Viewer.
2) i want my customers to validate data shown in the report by clicking on a validate button (or hyperlink)
3) I want this button to execute an SSIS package or a.NET code that will copy the displayed data to another DB.
Part one and three, i know how to do this, but for part 2 i don't find any clue ( or maybe executing Jscript code with an hyperlink but i don't know how to manage this.
Some Ideas ?Ludovic Bouaziz - MCSD .net
November 5th, 2010 6:06am
Hi,
If I am correct, you are asking about how to validate data shown in a report by clicking on a validata button or hyperlink.
By design, the SQL Server Reporting Services reports are used to show data for users only. We can drill through a report to another report or page using the feature "Drill-Through", it will be shown as hyper link in the report. However we are not able to
add a .NET button to the report body by default.
In this case, in order to validate the data, we can use the "Drill-Through" to open a new web page, in the page, validate the data.
The web page shoule be in a customized web application.
For more information, please see:
Developing Report Navigation and Drilldown:
http://msdn.microsoft.com/en-us/library/aa964132(SQL.90).aspx
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2010 4:40am
thanks Jin Chen, i did it and it worked fine !
Ludovic Bouaziz - MCSD .net
December 23rd, 2010 11:31am