How to run On-Demand Report 1

[andreis]

Hi, how do I let a user run an on-demand report using SQL Server 2005 Reporting Service? I have a report, can't just figure out how a user can run it whenever she wants it. Thanks.

 

[mrdenny]

Have them go to the Reporting Services web page. When they view the report there it will run the report and get the data.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[andreis]

Denny, thanks, but the problem with this one is that any user role, even browse, gives a user possibility not only to view/change properties of the report, but also go to other reports...

 

[mrdenny]

They should have a properties tab, but they shouldn't be able to view anything other than the date created/modified and by who.

When I log into SSRS this is all I can see (this user has Browser only).

Modified Date: 5/5/2009 12:59 PM
Modified By: DOMAIN\UserName
Creation Date: 5/5/2009 12:59 PM
Created By: DOMAIN\UserName
Size: 12 KB

Setup a domain group with the users that need access to the report. Deny that group access to any of the other folders/reports. Create a new folder for that group, and put a linked report in it that points to the origional report.

That or build something into your current app (or a new app) that calls the webmethods on the report server and runs the report on demand.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog