How to group combobox parameters?

5 posts, 0 answers
  1. Simon
    Simon avatar
    52 posts
    Member since:
    Sep 2018

    Posted 17 May Link to this post

    Hi,

    I want to group some items in the combobox of my reports.

    Please see the example( groupedCombobox.jpg ) , which I have attached.

    I used horizontal lines to separate the groups.

    But how can I realize that in a report parameter which is a combobox?

    Have you an example project?

     

    Regards

  2. Neli
    Admin
    Neli avatar
    125 posts

    Posted 22 May Link to this post

    Hello Simon,

    I would suggest to use Cascading Parameter. In this way, you can select OriginCountry and based on that you can choose CarBrand.
    The attached report  contains a CSV DataSource with OriginCountry , CarBrand and Price columns and the following approach is applied:
    1)  Add a report parameter and set it as follows:
    AvailableValues: DataSource: csvDataSource
         DisplayMember: =Fields.OriginCountry
         ValueMember: =Fields.OriginCountry
    MultiValue: True
    Name: Country
    Type: String
    Value: =AllValues(Fields.OriginCountry)
    Visible: True

    2) Add second report parameter and set it as in the screenshot.

    3) In the table all columns are added and the following filter is applied:
    Expression: =Fields.CarBrand
    Operator: =
    Value: = Parameters.CarParameter.Value

    In this way only the selected car and its price will appear in the table.

    Regards,
    Neli
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Simon
    Simon avatar
    52 posts
    Member since:
    Sep 2018

    Posted 23 May Link to this post

     

    Hello Neli,

    thank you for your solution.

    However, you must have one more report parameter to implement the grouping.

    But nice solution, it works.

     

    Best Regards

    Simon

     

  4. Simon
    Simon avatar
    52 posts
    Member since:
    Sep 2018

    Posted 23 May Link to this post

    Update:
    the deeper I nest the more parameters I need.
    I tried it over 3 levels - see attachement.
    I thought it gives a more elegant way with one parameter.

    But for this case it's okay.

  5. Neli
    Admin
    Neli avatar
    125 posts

    Posted 27 May Link to this post

    Hello Simon,

    Indeed, you need a separate Report Parameter for each level of data hierarchy (e.g for Country, State, City, etc). This lets you filter the data on each level. If you need to achieve the functionality through one parameter it will be necessary to concatenate the values from the different fields, which may not be very convenient for the end user.

    Regards,
    Neli
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top