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?
4 Answers, 1 is accepted
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
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:
Value: = Parameters.CarParameter.Value
In this way only the selected car and its price will appear in the table.
thank you for your solution.
However, you must have one more report parameter to implement the grouping.
But nice solution, it works.
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.