This is a migrated thread and some comments may be shown as answers.

Filtering Crosstab via Report Parameter

1 Answer 172 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Dan
Top achievements
Rank 1
Dan asked on 19 Jun 2012, 04:47 PM
I have a Crosstab that is displaying data from a SQL data source. The data is grouped by the field FacilityID. I have a report parameter Facility that is a multiselect dropdown populated from another SQL datasource. How can I filter the Crosstab based on the selections in the Facility dropdown? When editing the filter property of the Crosstab it does not show the fields associated with that DataSource.

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 21 Jun 2012, 03:41 PM
Hi Dan,

In order to filter the crosstab based on multivalue report parameters selection our suggestion is to set up the crosstab filter as shown in the following example:

 Expression Operator  Value 
 =Fields.CrosstabDataSourceField1 In  =Parameters.Parameter1.Value

Greetings,
Peter
the Telerik team

FREE WEBINAR ON THE NEW REPORT DESIGNER! Join us on Friday, June 29 at 10:00 AM for a comprehensive demo of the official version of the standalone Report Designer and find out how easy it is to empower your users with creating, editing and sharing ad-hoc reports. The webinar will go through a real-world scenario of creating reports, embedding them in your application(s), and distributing them within your organization. We will also cover the newly added support for sub-reports, navigation actions (such as drill-down and drill-through), and report sources. Register here and bring your questions with you. We’ll try to address them during the webinar! You may even win a Telerik Ultimate Collection license! Register today >>

Tags
General Discussions
Asked by
Dan
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or