We have few reports where there is a crosstab which shows product details with segments and values for the segment. There is a column grouping on segmentname column. Data shown by the report will be as follows
ID Code Description Barcode Active? Sellable? Redeemable? Size Color Class Department
1 ABC123 Pink Teddy ABC123 'Y' 'N' 'Y' 'S' 'Pink' B1 N1
2 XYZ456 Blue Teddy XYZ456 'Y' 'N' 'Y' 'S' 'Blue' B1 N1
3 CBV256 Chota Bheem CBV256 'Y' 'N' 'Y' 'S' 'Brown' B2 N1
3 NIV256 Ninja Sword NIV256 'Y' 'N' 'Y' 'M' 'Brown' B2 N2
4 BBN267 Big Basket Ball BBN267 'Y' 'Y' 'Y' 'B' 'Orange' B3 N3
Columns up to 'Reemable?' are static columns. All columns after 'Reedeemable?' are segments. Segments are defined in a different table and are dynamic. Column grouping on segmentname is used to get all segment details for a product in a single row. There are filters on crosstable to see if only active products should be shown or only redeemable or sellable products should be shown.
We have clients who have a big list of products. They would want to look for details with different combinations of segmentname and segment values. For example the filter could be as follows
((segmentname = 'Color' and value = 'Brown') or (segmentname = 'Class' and value = 'B3'))
Since the segments are dynamic and there could be different combinations, adding segments as a parameter to the report will not help. We did not find anyway to add the filters to a string variable and append the string variable to the crosstab's datasource commandtext. Is there anyway in telerik reports for the user to open a window from the report where he could create such combinations and the filter string thus formed in addition to filters in the report could be passed to the crosstab? Please suggest what could be done.
We are using Report designer and creating reports for windows forms applications. The same reports are being used by Asp.net webforms.