We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
  1. Home
  2. Forum
  3. LightSwitch HTML
  4. RDLC Report & Parameters
Starting in 2019, the Reporting control is no longer included in Essential Studio. If you're experiencing issues with the Syncfusion Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion and appreciate your understanding.

RDLC Report & Parameters

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?


1 Reply
SR Soundara Rajan S Syncfusion Team December 1, 2015 08:51 AM UTC

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.

Loader.
Up arrow icon