How pass parameters to reportviewer using c# code behind

http://stackoverflow.com/questions/2855472/ssrs-asp-net-passing-parameters-from-net-to-ssrs-in-report-viewer

Thanks for the link -- I get this error:

Error      32      The type 'System.Windows.Forms.UserControl' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.      C:\WIP\PartnerWeb\Partner\Partner\PrintPOG.aspx.cs      27      22      Partner

Line 27 is this:
private void SetReportParameters(ReportViewer viewer)

I am sure this is basic .NET stuff -- but I could use some help...

Sorry to jump in on my own posts -- but I added the references and added this:

using Microsoft.ReportingServices;
using Microsoft.Reporting.WinForms;

Now, on rebuild i get the following errors:

Error      32      Non-invocable member 'System.Web.HttpRequest.QueryString' cannot be used like a method.      C:\WIP\PartnerWeb\Partner\Partner\PrintPOG.aspx.cs      30      78      Partner
Error      33      Non-invocable member 'System.Web.HttpRequest.QueryString' cannot be used like a method.      C:\WIP\PartnerWeb\Partner\Partner\PrintPOG.aspx.cs      31      82      Partner


.NET is complaining about Request.QueryString where QueryString is underlined in BLUE.

Any thoughts?

Sorry again, looks like I needed Brackets...

            ReportParameter myCustID = new ReportParameter("CustID", Request.QueryString["001984"]);
            ReportParameter myShipDate = new ReportParameter("ShipDate", Request.QueryString["2010/10/09 00:00:00"]);

I will rebuild and post my results...
Jason

Well, the page loads, but the parameters are not passed on...

Could it have something to do with the fact that I am not referencing the ReportViewer ID in the code behind? The ID is

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ...

In the code behind, no reference to that ID is made, so how will the code behind link to the reportviewer in the aspx page?

Thank you!
Jason

milindsaraswala,

Thank you for the reply. When I use the code posted above I get the following error:

Error      10      'para' is a 'variable' but is used like a 'method'      C:\WIP\PartnerWeb\Partner\Partner\PrintPOG.aspx.cs      48      13      Partner

Error      11      'para' is a 'variable' but is used like a 'method'      C:\WIP\PartnerWeb\Partner\Partner\PrintPOG.aspx.cs      49      13      Partner

==================================================================
Also, I want to mention that I have a default value set for the parameter in the report on sql services. Not sure if this will cause a problem, but I think I should get the code working in C# first.  Let me know if you have any ideas what the errors above mean. I did some googling, but nothing stood out to me in the SERP.

Jason

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Drawing;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Web.Util;
using FSPI.Security;
using FSPI.Utility;
using Ajax;
using Microsoft.ReportingServices;
using Microsoft.Reporting.WinForms;

namespace extranet {

    public class PrintPOG : System.Web.UI.Page {

        protected C_Header Header1;
        ReportViewer ReportViewer1;

        protected void Page_Load(object sender, EventArgs e)
        {

            ReportParameter[] para = new ReportParameter[1];
            para(0) = new ReportParameter("CustID", "123456");
            para(1) = new ReportParameter("ShipDate", "2010/13/09 00:00:00");

            this.ReportViewer1.LocalReport.SetParameters(para);
        }

    }
}

Select allOpen in new window

oh, yeah. needed square brackets like this para[0] instead of para(0) --

But still I am not seeing the report update with the parameters. Any thoughts? I will design a new report without the default values populated in the parameters and see if that helps any.

I will report back with my results -- let me know if you think of anything until then -- and thank you!

Jason

No Joy. Is it even possible to pass variables to a server report? Or does the report have to be local to the web server using an .rdl?

I attempted to remove the default values of the parameters on the sql reporting server report, then reloaded the web page we are working on. The report still did not load.

My current code is listed below.
Any thoughts?

namespace extranet {

    public class PrintPOG : System.Web.UI.Page {

        protected C_Header Header1;
        ReportViewer ReportViewer1;

        public void Page_Load(object sender, EventArgs e)
        {

            ReportParameter[] para = new ReportParameter[1];
            para[0] = new ReportParameter("CustID", "126456");
            para[1] = new ReportParameter("ShipDate", "9/13/2010"); // 2010/09/13 00:00:00

            //this.ReportViewer1.LocalReport.SetParameters(para);
            this.ReportViewer1.ServerReport.SetParameters(para);
        }

    }
}

Select allOpen in new window

Actually when u run the report with reportviewer control it will run at local side. And as per the MSDN

When to Use Local Processing
Local processing mode is recommended for applications that include small to medium-sized reports and datasets. Because all data and report processing is performed on the client, you might encounter performance degradation or memory limitations if you attempt to process large or complex reports and queries.

Local processing mode is less scalable than remote processing and is intended for standalone applications that do not require a report server. Users who are familiar with server reports that run on a remote SQL Server Reporting Services report server should note the following differences:

In remote processing mode, the report server both retrieves the data and processes the report, whereas in local processing mode, the ReportViewer control processes the report only, and the the host application must retrieve the data and supply it to the ReportViewer control.

Client report definitions do not include query information.

Report parameters in client report definitions (.rdlc) do not map to data source query parameters.

There is no parameter input area for a client report definition that accepts values that are subsequently used in a query.

As per above you have to pass data source also.

OK, Cool -- thanks for the feedback. So, what could be the problem here? Here is a repeat of the background of the information posted above:

We have an SSRS Report Server on one server on our network. It has many reports. one of which I am attempting to display in a web application.

I am able to get the Report to render in the web app using ReportViewer, but am unable to pass in the Parameter Values as Variables from Code Behind.

It is like the code behind is not properly 'communicating' with the ReportViewer Control on the aspx page. I get the following message when attempting to load the page:

The 'CustID' parameter is missing a value

I have a feeling that their is a small piece missing from the either the code behind as has been kindly provided in this post or maybe in the ReportViewer Control on the aspx page. Both are posted below for review.

Thank you for engaging in this with me, when it is solved, it will be a major improvement for the web app and your efforts are truly appreciated.

Let me know if you can suggest anything to assist.

FYI -- I have attempted to add a local report without success -- and now that you have clarified it's limitations above, I will not continue to attempt it. The report being rendered in the aspx page calls a stored procedure and is also a pretty big report.

Thank you,
Jason

in PrintPOG aspx page:
==================================
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" PromptAreaCollapsed="true"   
            Font-Size="8pt" Height="1000px" ProcessingMode="Remote" Width="100%">
                <ServerReport ReportPath="/Sales/Online Ordering/Product Order Guide" 
                ReportServerUrl="http://sql01.fsproduce.com/ReportServer" />
        </rsweb:ReportViewer>

====================================
in PrintPOG.aspx.cs:
====================================

namespace extranet {

    public class PrintPOG : System.Web.UI.Page {

        protected C_Header Header1;
        ReportViewer ReportViewer1;

        public void Page_Load(object sender, EventArgs e)
        {

            ReportParameter[] para = new ReportParameter[1];
            para[0] = new ReportParameter("CustID", "126456");
            para[1] = new ReportParameter("ShipDate", "9/13/2010"); // 2010/09/13 00:00:00

            //this.ReportViewer1.LocalReport.SetParameters(para);
            this.ReportViewer1.ServerReport.SetParameters(para);
        }

    }
}

==============================================
When I disable the default value for the CustID Parameter on SQL Server Reporting Services and then render the page I get the following message:

The 'CustID' parameter is missing a value 

Select allOpen in new window

UPDATE:

I placed breakpoints at the page load event in code behind, ran the app in debug, and the code never entered the page load event?!!?

No clue what is happening. I thought every page had to enter the page load event in code behind when the page loads?

hmmm...

Jason

We need to find the name of the parameters expected by the your Report. To do this click on Report --> Report Parameters and we find that the Parameter names. We now have all the information we need to proceed. We now need to specify the ServerURL and the Report name to the Report Viewer component.

ReportViewer1.ServerUrl=@"http://localhost/ReportServer";
ReportViewer1.ReportPath=@"/Report URL";

To pass the parameters to the report, we need to use the SetQueryParameter method that we added to the ReportViewer component

ReportViewer1.SetQueryParameter("ParameterNme",Value);

Our next step is to hide the parameters part of the toolbar created in the Report. Since our web page now accepts user inputs, we don’t need Reporting Services to do this.

ReportViewer1.Parameters=Microsoft.Samples.ReportingServices.ReportViewer.multiState.False;

If you want to hide the rest of the toolbar as well (the area from where you can export to another format), set the Toolbar to false.

ReportViewer1.Toolbar=Microsoft.Samples.ReportingServices.ReportViewer.multiState.False;

Sorry I forget to mention  that use SetQueryParameter  you have to add code in

C# and VB versions of the source code are available, and if you used all the default installation options, they are installed under in C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer\vb and C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer \cs respectively.

Open up the solution file ReportViewer.sln then add this

public void SetQueryParameter(string ParamName, string ParamValue)
    {
  SetParameter(ParamName,ParamValue);
    }

well, thank you again for all of your help. The thing is, i got so frustrated that i moved the code into a whole new website to see if it would run on its own without all the other pre-existing classes and what not.

and guess what? it ran just fine. this means that the first few lines of code you posted were working correctly.

so i started to experiment -- didn't really get me anywhere, though. so i scrapped everything and started again. I believe I am close -- but could use some assistance.

Never mind the fact that I did get the code you originally posted to run in its own website. Here is where I am now:

The error I am getting is that the "Object reference not set to an instance of an object. "
The line that errors in debug is "this.ReportViewer1.ServerReport.SetParameters(para);"

My current code is posted below. Can you please take a look at the code behind and let me know if you see anything glaringly obvious that would cause this generic error message?

In addition, I have included a screen shot of the error message captured during debug as well as the stack trace of the error which is located at the bottom of the code snippet I posted below.

If possible, i would like to muscle through this error -- since I believe that once we get past this error, the original code you posted will likely work [as it did in the side project i created earlier today].

Thanks again,
Jason

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Microsoft.Reporting.WebForms;
using Microsoft.ReportingServices;
using System.Windows.Forms;
using Microsoft.ApplicationBlocks.Data;
using FSPI.Security;

namespace extranet
{
    public class printpog : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlForm frmLogin;
		protected System.Web.UI.WebControls.Label lblRoute;
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Web.UI.WebControls.Panel panGrid;
		protected System.Web.UI.WebControls.Label Message;
		protected System.Web.UI.WebControls.Label lblDateTime;
		protected System.Web.UI.WebControls.Label MyError;
        public C_Header Header1;
		public string selCustomer;
        ReportViewer ReportViewer1;
        
		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
            Header1.pageTitle = "Print POG";
            
            ReportParameter[] para = new ReportParameter[1];
            para[0] = new ReportParameter("CustID", "123456");

            this.ReportViewer1.ServerReport.SetParameters(para);
                            

 		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			//this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);
            
		}
		#endregion

	

	
	}
}

=====================================================
stack trace
=====================================================

System.NullReferenceException was unhandled by user code
  Message="Object reference not set to an instance of an object."
  Source="Partner"
  StackTrace:
       at extranet.printpog.Page_Load(Object sender, EventArgs e) in C:\WIP\PartnerWeb\Partner\Partner\PrintPOG.aspx.cs:line 41
       at System.Web.UI.Control.OnLoad(EventArgs e)
       at System.Web.UI.Control.LoadRecursive()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  InnerException: 

Select allOpen in new window

errorInDebug.jpg

You can do like this also

Generic.List<ReportParameter> paramList = new Generic.List<ReportParameter>();


paramList.Add(new ReportParameter("ParameterName1", Value1, false));
paramList.Add(new ReportParameter("ParameterName2", Value2, false));


ReportViewer1.ServerReport.SetParameters(paramList);

ok, cool. What is "Generic?" I am unable to add a reference to it using

Add Reference >

I am using .net version 2.0 in this app.

Needless to say, I am unable to build my project as it errors on the "Generic.".

Jason

ok, it's System.Collections.Generic -- but I am still getting the Object Reference Error when the page loads.

Still Googling...

Jason

Replace the following code

 ReportParameter[] para = new ReportParameter[0];            
para[0] = new ReportParameter("CustID", "123456");


If you give [1], the parameter will assume that you are passing two parameters as it takes from 0. So all you need to do is to change the [1] to [0].

yeah -- you might be right -- listen, this is embarrassing -- and let me preface what i am about to tell with you with the fact that i am NOT proficient in C#.

In fact, I inherited this project from people who worked here before I even started.

now that you know, here is what I did to get the thing to work properly.

I changed ReportViewer ReportViewer1;
to public ReportViewer ReportViewer1;

I guess if you do not specify "public" C# assumes private?

so, now things are working properly, the report renders, the variables are populating as values in the parameters and I have egg on my face.

Thank you for all of your help... I will award the points to you and close this thread.

Thank you,
Jason

Thank you very. I am happy that I could solve your problem.