I have a report. There is one group for laction and there are columns in Detail section. I want to hide detail section based on formula and and display message. One of the column is qty and another is transaction count. I want to hide details when
SUM(Qty) = 0 AND SUM(TranscationCount) = 0
Then Display "No records"
else display the detail records for that group.
For Example:-
Qty TransactionCount
1 5
3 10
Loc2
0 0
0 0
I want to hide details for Loc2 group and display message.