Forum Discussion
Hide the Parent Group total
Hi,
I am working SSRS table report. I have added a parent group at Row level and subgroup has categories and I have added parent group as Total. So for each subgroup it will display the total.
Below is my SQL Query Result:
I have added parent group at row level by group on the below expression:
=LEFT(Fields!SubCategory.Value, INSTR(Fields!SubCategory.Value, ".")-1)
It was giving expected result. However, if we have more than one value in subcategory then it should add the total else it should display the only category.
After applying the above expression at group level, the result would be as below.
For Women and Infant it is fine as we have subcategories and we need total women and total infants. But in Children category we won't've any sub rows. So, I need to ignore total Children row and result should like below.
I tried to hide the total row by applying different conditions at group level but no luck.
Thanks,
MG
Got the solution.
Thanks
1 Reply
- MGTech86Copper Contributor
Got the solution.
Thanks