How to pass a Query String parameter to a Reporting Services Report
Navigate to the ReportServer website. You will see a list of folders. Open the folder with your report in it. Find the report you want and open it. The screen will come up and prompt you for parameters. Let’s say that your report needs a CustomerID. Simply ad this as a querystring value to the URL “&CustomerID=1516″ and refresh the page. If you pass all of the required parameters to the report it will run automatically.
Alternatively if you are using the ReportViewer Control in VS2005 you:
1. Reference the Microsoft.Reporting.WebForms namespace
2. Create a collection of ReportParameters
3. Create the individual paramenters
4. Pass the parameters to the SetParameters() function of the ReportViewer.
using Microsoft.Reporting.WebForms;
List<ReportParameter> parms = new List<ReportParameter>();
parms.Add(new ReportParameter(“CustomerID”, 1516));
ReportViewer1.ServerReport.SetParameters(parms);
2 Responses to How to pass a Query String parameter to a Reporting Services Report
Leave a Reply
Posts
- Redirect user to another SharePoint page after adding List Items by Rick - 2 Comments
- How to hide a SharePoint list column from a list form (New, Edit, and Display) by Rick - No Comment
-
How to enumerate all ‘Inherited Security’ sites
by Rick - No Comment
- How to add a SharePoint List field programmatically by Rick - No Comment
- Delegating elevated priviledges to your SharePoint method by Rick - No Comment
- How to add a new list item to SharePoint using the List Item web service by Royaline - 18 Comments
- Recovering from a deleted site collection by Royaline - 4 Comments
- Opening Custom Webpart Links in a new window using Javascript by Royaline - 4 Comments
- Getting all items in all folders using the SharePoint Lists.asmx Web Service by Royaline - 3 Comments
- Parsing SharePoint List Items from Lists.asmx by Royaline - 3 Comments
- CMP: How to add a new list item to SharePoint using the List Item web service
- cmp: Redirect user to another SharePoint page after adding List Items
- Garrett Michael Hayes: Display an error if an unsupported browser views your SharePoint site
- Chris: How to add a new list item to SharePoint using the List Item web service
- Rick: How to add a new list item to SharePoint using the List Item web service
I added the following code
protected void ReportViewer1_Load(object sender, EventArgs e)
{
List parms = new List();
parms.Add(new ReportParameter(“NIM”,Request.QueryString["NIM"]));
ReportViewer1.LocalReport.SetParameters(parms);
}
but i get this error
An error has occurred during report processing.
ObjectDataSource ‘ObjectDataSource1′ could not find a non-generic method ‘GetMasterNilaiByNIM’ that has no parameters
can you help me?
It may not recognize your parameters because your list needs to be of type Microsoft.Reporting.WebForms.ReportParameter