RDLC Report & Parameters

[graham ross]

I have a lightswitch application and I would like to display a report which renders after the user has selected a parameter from a drop-down list. I have a stored procedure in SQL which has defined the parameters required in order to return the data for the report as my first dataset. I also have a SQL query to provide the list of drop-down labels and values as my second dataset.

How do I build the RDLC report so that it displays the list of labels and uses the value associated to that label as the parameter of the report?

[Soundara Rajan S]

Hi Graham,

Thanks for contacting Syncfusion support.

I have a lightswitch application and I would like to display a report which renders after the user has selected a parameter from a drop-down list. I have a stored procedure in SQL which has defined the parameters required in order to return the data for the report as my first dataset. I also have a SQL query to provide the list of drop-down labels and values as my second dataset.

We have prepared a sample and it can be downloaded from the below location, http://www.syncfusion.com/downloads/support/forum/121289/ze/DependentParameterDemot1513542083.zip In the above sample, we have specified two parameters with dependent. The First parameters’ available values are retrieved from first query dataset and second parameters’ available values are retrieved from second dataset. The second parameter query dataset values are retrieved based on first parameter value.

How do I build the RDLC report so that it displays the list of labels and uses the value associated to that label as the parameter of the report?

We have prepared a sample and it can be downloaded from the below location, http://www.syncfusion.com/downloads/support/forum/121289/ze/FilterWithDataRegion734669800.zip   By default, RDL/RDLC report supports the DataRegion filters and by using this, you can achieve the parameter filter in RDLC reports. Please refer to the below MSDN articles for more details on this, https://msdn.microsoft.com/en-IN/library/dd239395.aspx https://www.mssqltips.com/sqlservertip/2597/dataset-and-tablix-filtering-in-sql-server-reporting-services/

Regards,
Soundara Rajan S.