I am trying to create a report which has no detail lines, just a crosstab in each break footer. What seem to be happening is that I get a crosstab at each footer - for the entire dataset being included in the entire report.

I'm trying to get a crosstab of service provision for each day in a range. I need a separate crosstab for each day, with a header for each day. The header looks just fine, but the crosstab at each footer is identical - and when you look closely, it's obvious that it's tabulating the data for the whole date range, rather than for that date.

Is there some limitation to the cross tab that only allows it to be done for the entire dataset? Or am I looking at a glitch? Or am I over looking something else?

Reply via email to