Skip to Content
0
Apr 28, 2014 at 07:11 AM

how to do formatting in report layouts

26 Views

Hi All,

I have a query

i have report output for March 2014 like this EXCEL ROW Number than code and then amount

excel ROW no code amount 1 1002 38 2 1003 26 3 1004 3 4 1005 2 5 1006 2 6 1007 2 7 1008 2 8 1009 1 9 1010 1 10 1011 1 11 12 Code amount 13 5001 1 14 5002 2 15 5003 34 16 5004 32 17 5005 25

i have report output for April 2014 like this EXCEL ROW Number than code and then amount

excel sl no code amount 1 1002 38 2 1003 26 3 1004 3 4 1005 2 5 1006 2 6 1007 2 7 8 Code amount 9 5001 1 10 5002 2 11 5003 34 12 5005 25 13 14 15 16 17

I want report like same a March month where first table rows start from 1 and end at 10 and second table start at row 12 but in April month we have less codes due to second table starting at row 8. But my requirement is like below where if codes are less then also it will start from Row 12 like below

excel sl no code amount 1 1002 38 2 1003 26 3 1004 3 4 1005 2 5 1006 2 6 1007 2 7 8 9 10 11 12 Code amount 13 5001 1 14 5002 2 15 5003 34 16 5005 25 17

I am using sap Bo 3.1 infoview.

Please suggest..

Thanks in advance.

Ranjeet