Need help on formating a report

[toblerone65]

Friends I have 2 columns offiname and office location

I did group on two of them and moved the field to group footer two, and data comes up likes this
ABP 01
CNV 04
DKY 09

i would like repeat these data like two sets in thi way

ABP 01
CNV 04
DKY 09

ABP 01
CNV 04
DKY 09

Any ideas how to achive this?, thanks alot.
T

 

[toblerone65]

I know I can use subreport, but any other methods to achieve this?

 

[lbass]

Add a crosstab to the report footer. Add the fields as the rows, suppress the subtotals, add a summary that you also suppress, and remove the grid.

-LB

 

[toblerone65]

LB, i tried cross tab report,is there a way I can do drill down on Cross Tab without grouping?. Using subreport I am able to do drill down but not with cross tabs.

 

[lbass]

No, you'd have to use a subreport.

-LB