Search This Blog

Thursday, December 16, 2010

How to pass a data to a report parameter

How pass data to a report parameter using report viewer for 2008.

Note: Report viewer for 2008 express edition is just an add on component is it not part of the visual web studio.

Assuming that we have a report named rpt_report1.rdlc and the parameter named wkcldr

In our .aspx page we have a ReportViewer named rptVDiversions as shown below

<rsweb:ReportViewer ID="rptVDiversions" runat="server" Font-  
            Names="Verdana"
            Font-Size="8pt" Height="400px" Width="909px">
            <LocalReport ReportPath="rpt_report1.rdlc">
                <DataSources>
                    <rsweb:ReportDataSource
DataSourceId="someDataSource"
                        Name="someName" />
                </DataSources>
            </LocalReport>
</rsweb:ReportViewer>

In code behind


using Microsoft.Reporting.WebForms; //

protected void ShowReport()
{
ReportParameter _rptParamWkcldr = new ReportParameter("wkcldr","data to pass");

//create instance
List<ReportParameter> wkcldr = new List<ReportParameter>();

wkcldr.Add(_rptParamWkcldr);

this.rptVDiversions.LocalReport.ReportPath = "rpt_report1.rdlc";

this.rptVDiversions.LocalReport.SetParameters(wkcldr);

}