invoke sql server report from classic asp page

[BruceG]

Hey there,
I've got a website (classic ASP) using SQL Server 2005 on the backend. Assuming I get thru hurdle one in creating a report with Reporting Services, how would I invoke that report from, let's say a "Run" button, on an ASP page?

[alex_read]

I think you'll be pleasantly suprised how easy the report designer is once you've played with it for a little while.

Reporting Services is installed as a website, and allows you to create both directories and individual reports beneath it, from using it's administration page (I think from memory this might be something like Http://ServerName/ReportServer or Http://ServerName/Reports perhaps - there's 2 sites installed and 1 is the administration one. You can look these up within IIS or the Reporting Services configuration manager if using SQL Server 2005 or 2008 versions). Once you have used this administration site to create your project folder and uploaded your report to it, you can select to view the report on screen.

Providing all goes well with it's render and data display, you can copy this URL, and simply call this - i.e. have a popup window appear or provide the user with a hyperlink which will navigate them to this report URL.

A final note would be to check your permissions against the report to make sure everyone (that you wish to,) can see it. This can be done by navigating to the folder containing the report, within/using the report administration website, selecting the checkbox beside the report uploaded and shown, and clicking a form of properties button (I haven't got this installed so can't unfortunately tell you all the correct names at the moment).