niceguy606
MIS
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
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