Help for Crosstabs

[Developer_jasper]

Hi,

I need some help for crosstabs. I am creating a report and want to fetch some data and summarize it which crosstabs will do.

I have got following field:

  site.sitename,
  srv.srvname,
  detail.ethn,
  substring(individual.postcode from 1 for 4),
  individual.indid
 

I want crosstab to look like that:

srv.srvname field as 1st column, detail.ethn as 2nd column and substring(individual.postcode) as row. i want to count individual.indid (so that will be detail section of crosstabs).

i have created report group for sitename so new sitename will start on a new page. and data i want to fetch for the group should be in detail band of sitename group.

the problem is crosstab should be in summary band, i have tried using crosstab in summary band but it does breakpage for next site.(obviously it should be in detail band of sitename group).

So i want the page break for each site in crosstab. Any suggestion? Much appreciated.

 

thanks