Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Reports in ASP.net website

Author  Topic 

fbaker
Starting Member

9 Posts

Posted - 2008-02-12 : 16:12:08
Hi,

I have a web page where my users are selecting a bunch of filters to generate a report. The page then pulls the initial data from the database, applies some adjustments to the records, and then puts the data in a temporary table for that user. I want to create a report template (or a report saved on the report server) for this report. I want to use the same report for each user but be able to change the datasource for the report on the fly for the current user's temp table in my webpage before displaying the report. Is this possible?

~ Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-13 : 02:59:04
I think this is possible. In webpage you need to implement the webservice of SQL reporting services and change the datasource property by calling webservice exposed functions.I think you need to use the SetDataSourceContents() function.
Go to Top of Page
   

- Advertisement -