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  Development Tools  ASP.NET  How to do this...?

Author  Topic  pmak Starting Member 41 Posts Posted - 2006-09-02 : 11:12:05 I work with a Health Research compnay and I am using SQL 2005 Reporting Services. Recently I was told to create a reports listing page at the company PUBLIC static HTML Web site (web server is in the DMZ) and displaying reports using SQL Reporting Services. I can develop reports using SQL 2005 RS. The data showing in the reports is somewhat very sensitive and security is upmost important and we dont want public to have access the "report manager" at the Report Server. My technical skills in dotnet development is very little. To achieve this I believe that I need to set up a HTML listing page showing all the reports and it can be created as part of the existing Web site. Each of the report listing is a hyperlink to a single dotnet "report viewing" page with the "report viwer" control on it. The reports hyperlink will re-direct to that "report viewing" page and pass the report title to it and the corresponding report will be displayed on the "report viewer" control. I need a working sample that I can follow to create this. Thanks. Paul Mak