I am struggling with a seemingly simple reporting issue in 2008, and was wondering if someone can help.
If I have a report with detail items which is either "apples" or "oranges", and a summary group which shows "Total Fruit", but I only want to show "Apples" in the detail section but hide "oranges", how do I go about doing this? I Still want to show the total in the summary group of all fruit..
I have change the visibility options to show or hide based on an expression, but that only apply to when it is Initially run.. I dont want the visibility of oranges to be toggled, I dont want it to be visible at all.
Am I missing something?