Report Server via the reportviewer - a report that uses parameters

Discussion in 'Databases' started by jjoslin, Aug 27, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I've tested a report via the report manager that requires a parameter and it works great. However, when calling the report via the reportviewer, the report is not generated. The parameter prompt is present when the report is loaded by the code behind. After the parameter is entered and the "View Report" button is pushed, nothing is returned. Is there another event handler needed in the code behind? Right now there is one statement in the Load_Page event:




    ReportViewer1.ServerReport.ReportServerCredentials = new MyReportServerCredentials();


    Reports without parameter input run successfully. I assume that when parameters are required, the Report Server takes care of all of the housekeeping and should return the filtered report. Is this correct?


    Thanks,


    John
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    Hmmm.. that i am not sure. Have not tested with a report that takes in parameter?


    I have just curious, why are you even connecting to the reporting service? Why not just use report viewer control and render the report on your site?


    Rendering report on a web app from reporting service is really a pain in the butt.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. My test site is a prototype of a reporting site that will be used by a client. The idea is to keep implementation of a report a very simple process. The website will be simply a collection of menus that are categorized by report type. When a new report is created all I have to do is add the menu item for the report on the report site. All maintenance for the report will be in the report designer. The reason the Report Server Approach is so attractive is that it takes ONE LINE OF CODE to run the report in the code behind. The report viewer on the page, of course, has to point to the report and RS URL. The question now is do I have to progammatically set the report parameters or will the report server take care of this for me. As I mentioned, the parameter input is displayed for the report but nothing is returned. I ran one of the reports on my local report server with a parameter required and it ran just fine.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page