Allow End User of Report ability to select what Series Display

5 posts, 1 answers
  1. Mike
    Mike avatar
    4 posts
    Member since:
    Aug 2011

    Posted 02 Dec 2014 Link to this post

    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. 

  2. Mike
    Mike avatar
    4 posts
    Member since:
    Aug 2011

    Posted 02 Dec 2014 in reply to Mike Link to this post

    Missed the attachment.
  3. Mike
    Mike avatar
    4 posts
    Member since:
    Aug 2011

    Posted 04 Dec 2014 in reply to Mike Link to this post

    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. 
  4. Answer
    Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 05 Dec 2014 in reply to Mike Link to this post

    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
  5. Mike
    Mike avatar
    4 posts
    Member since:
    Aug 2011

    Posted 05 Dec 2014 in reply to Hinata Link to this post

    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.
Back to Top