Today i came with another issue related to the SSRS Tabix Grouping,
I am using custom grouping of tabix according to user selected column name
For ex: Parameter Group: A, B, C, None. these are option for user i.e if user select A the tabix will group by column A,
similarly for b and c, but i want that if user selects 'None' no groupin should apply.
my problem is that, i want No grouping should apply, if user selects None option from above mentioned drop down.
Please guide me how do i achieve this............
Thanks in advance.........
- Edited by ShashankJain Tuesday, June 18, 2013 6:19 AM
To achieve your goal, you can use the following steps:
1. Right click on the target group from the Grouping pane, and open the Group Properties dialog box.
2. Set the expression for the “Group on” option as follows:
=Switch(Parameters!Group.Value="A",Fields!FieldName1.Value,Parameters!Group.Value="B",Fields!FieldName2.Value,Parameters!Group.Value="C", Fields!FieldName3.Value, Parameters!Group.Value="None", Nothing)
Besides, if you also want the group textbox displays different fields values according to the parameter that user selects, you can also specify a similar expression to the textbox.
If I have anything misunderstood, please feel free to let me know.
TechNet Community Support
thanks for the reply...
i go through you technique...
i changed my group expression like....
here param is my parameter name.
now i need to hide the Group row also according to it i.e. if user select Group By: None then group header row should be hidden otherwise shown this is working fine on Report Builder/Designer,
but when i use this .rdl on report viewer then it fails and show me only one detailed row.
Please help me on this....
if you have any query related this, i love to answer that........
it is very urgent for me...
thanks in advance...