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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

RDLC Report & Parameters

Thread ID:

Created:

Updated:

Platform:

Replies:

121289 Nov 27,2015 09:21 AM UTC Dec 1,2015 08:51 AM UTC LightSwitch HTML 1
loading
Tags: ReportViewer
graham ross
Asked On November 27, 2015 09:21 AM UTC

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 [Syncfusion]
Replied On 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.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;