Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Matrix with Group Above report Formatting issue

Status
Not open for further replies.
Feb 17, 2005
23
US
Hi
I have a designed matrix with a group above report so i could export to excel. But it displays in this format.


Comp Code 1201
Period Name APR-09 APR-10 AUG-08 AUG-09 DEC-08
Acct Category

791012 LEASEHOLDS 3798.76 3796.07 3798.76 3798.76 3798.76
792200 EQUIPMENT 24995.19 24231.41 25635.23 24685.35 25297.81
792400 COMPUTERS 8371.28 8298.84 8391.44 8319.1 8391.5
792600 FURN&FIXT 0 0 0 0 0

37165.23 36326.32 37825.43 36803.21 37488.07



Comp Code 1201
Period Name DEC-09 FEB-09 FEB-10 JAN-09 JAN-10
Acct Category Depr1 Depr1 Depr1 Depr1 Depr1
791012 LEASEHOLDS 3796.07 3798.76 3796.07 3798.76 3796.07
792200 EQUIPMENT 24453.41 25008.89 24453.41 25009.06 24453.41
792400 COMPUTERS 8298.84 8371.28 8298.84 8371.28 8298.84
792600 FURN&FIXT 0 0 0 0 0

36548.32 37178.93 36548.32 37179.1 36548.32


But I want the second part to be continued on the same first part I mean the period names column should end with JAN-10 instead of putting it on next page.

How can I do it?

Please help
Thanks



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top