shamen


Hi All,

I'm going to use report viewer to view the SSRS reports that I create. I have created bunch of reports. But I can publish only one report on report viewer. How can I publish more than one reports there just like on report manager. Can I view those reports just clicking links of each reports How can I make links

When I use reportview in visual studio it allows me to create only one report and when I dploy it straightaway it brings up the report in web form, but not the link like we see on report manager.

Is there anyway I can create links for each reports

Or in other words, I want to integrate report server and report viewer. But I dont have a very good idea about report viewer.

So please can anyone explain the basic steps

Thanks





Re: Integrating SSRS with report viewer

Scott.x.lu


You can use reporting web service to get all reports link and pass the link to report viewer.





Re: Integrating SSRS with report viewer

shamen

Thanks Scott

Can you explain lil bit more in details

Thanks







Re: Integrating SSRS with report viewer

Scott.x.lu

In your web project

  1. Add reporting web service reference
  2. Use ListChildren mothed to get all reports
  3. Use GetReportLink mothed to get report link
  4. Pass link to reportviewer.

You can find the details about these two mothed from MSDN





Re: Integrating SSRS with report viewer

shamen

I'm Sorry Scott still I did not get it..I'm lil bit confused with words.

How do I add reporting web serivce reference can I use ASP.NET configuration

Where can I find ListChildren mothed & GetReportLink monthed

How do I pass link to reportviewer just clicking the smart tag and specifying the report path

Thanks






Re: Integrating SSRS with report viewer

Scott.x.lu

Your words made me confused.
Just ask you some questions about your issue
1. Are you using web page which include Report Viewer Component to show RS Report
2. If you use your own web page, you need do programe code to call web serrvice in youe asp.net.
3. The report viewer is a web component which is used for showing RS Report in web form. Suggest you do research on MSDN and you will find a lot of samples of RS Web Service.





Re: Integrating SSRS with report viewer

shamen

First I was going to create ASP.NET web pages which include Report Viewer for each report. Then another .NET guy was going to create his own web page and create links to all web pages I had created for each report. But the problem is altogether there are 300 reports. That guy told me its too much.

So Now what he suggests is create two web pages , one withhyperlinks and other one with a report container. For each report I'm supposed to specify the path.

I dont have a knowledge on ASP.NET stuff. So still I dont have a clear idea about how to do this integration part..

I read about report viewer on MSDN. But Its only about report viewer. It does not say how to integrate to reports etc.






Re: Integrating SSRS with report viewer

Scott.x.lu

Ok, I understand.

If you do not have knowledge about .net, it will be hard to do that.

I 'm assuming that you will use iframe to contain two frames: left side--Report Lists which will contain hyperlink; right side-Report view which will show report through left side-report click event.

To do that:

For Left Side:

1. Hard Code List:

Ask your .net staff to build asp.net page for you and you just need provide them you report list with name and report path, the report path can be found in ReportServer DB Catalog table

2. Dynamic List

Ask your .net staff to add reporting service web reference to your web project, call ListChildren mothed to receive all report item from web service or you can query catalog table to receive report name and path

I think you need you .net staff to help you build hyperlinks page.

Add event on hyperlink click, pass the report path to reportview.

Any way, you need your .net staff to do that.





Re: Integrating SSRS with report viewer

shamen

Ok Scott Thanks lot..

I will get their help ..I have one mroe question..Can I create a data base and store all data bout reports there, like report name, report path etc. Then .net person who create the web page can use this data base as web page's source. Am I correct






Re: Integrating SSRS with report viewer

Scott.x.lu

Actually, you could do that, but not necessarily.

All report items already stored in catalog tabel in ReportServer database.

you can simply query catalog table to get all your reports (name and path).

Good Luck!





Re: Integrating SSRS with report viewer

shamen

Thanks scott