Is there a way to create a report that would allow end users to select what series display? As an example, we want to generate a report similar to the attached graph within a report and allow the end user to select via parameters what series show.
![]()
4 Answers, 1 is accepted
0
Mike
Top achievements
Rank 1
Rank 1
answered on 03 Dec 2014, 01:12 AM
Missed the attachment.
0
Mike
Top achievements
Rank 1
Rank 1
answered on 04 Dec 2014, 07:54 PM
Some additional details...
We want the user to be able to preview the report and then change series and then preview again. Setting up for the initial preview seemed easy enough but following previews after initial is where we are having difficulty.
We want the user to be able to preview the report and then change series and then preview again. Setting up for the initial preview seemed easy enough but following previews after initial is where we are having difficulty.
0
Accepted
Hinata
Top achievements
Rank 1
Rank 1
answered on 05 Dec 2014, 12:14 PM
Hi Mike,
Each series is based on a field value in the database. For example, let's say your series are based on the Fields.Gender field and you have one series for Male and one for Female. Now let's say you want to show only the Female series and hide the Male one.
What you need to do is Filter all the data rows which contain the Male string in the Fields.Gender field. This is done via filtering your data: http://www.telerik.com/help/reporting/data-items-filtering-data.html
The nice thing about the filtering is that it does not need to be static i.e., you can filter based on a report parameter value which can be set by your users: http://www.telerik.com/help/reporting/designing-reports-parameters.html
Each series is based on a field value in the database. For example, let's say your series are based on the Fields.Gender field and you have one series for Male and one for Female. Now let's say you want to show only the Female series and hide the Male one.
What you need to do is Filter all the data rows which contain the Male string in the Fields.Gender field. This is done via filtering your data: http://www.telerik.com/help/reporting/data-items-filtering-data.html
The nice thing about the filtering is that it does not need to be static i.e., you can filter based on a report parameter value which can be set by your users: http://www.telerik.com/help/reporting/designing-reports-parameters.html
0
Mike
Top achievements
Rank 1
Rank 1
answered on 05 Dec 2014, 04:15 PM
Hi Hardik,
Based on your suggestion we were able to resolve, we were not able to use the filter on the data rows as our series are in separate columns but we did apply the filter concept to the DataPointConditionalFormating of each item in the series and seems to work great.
Thank you for the concept and your help.
Based on your suggestion we were able to resolve, we were not able to use the filter on the data rows as our series are in separate columns but we did apply the filter concept to the DataPointConditionalFormating of each item in the series and seems to work great.
Thank you for the concept and your help.