I have a report that has several parameters, each of which is either 'All' or a selection. There is a crosstab in the footer which summarises one of the fields, and the overall total in the crosstab should match with the numbers of records actually brought back depending on the parameter selections.
So far, so good. But one of the parameters only relates indirectly to the records, and I get the right details records showing by using a conditional formula to suppress the detail section when required. This does not show in the crosstab. All the other parameters are in the Report Selection in one way or another, the crosstab works with these.
How can I tell the crosstab that if {?Area} is not 'All' it should only count those records where {?Area} = 'S' (for example)
I have looked at Group formula in the crosstab but I don't see how or if that would work.
Thank you
IP Logged
I have spent the best part of a day on it, and finally got it to work! 