Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I need to produce a formatted report which displays like a classic report, with group headers, group footers going down the page, rather than across the page.
I will show you what I need to produce and then a couple of examples of what I have produced.
Below is what i need to produce:-
October | September | ||
Current Assets | |||
Cash | |||
Cash At Bank and on Hand | 9,561,008 | 7,738,286 | |
Deposits on Call | - | - | |
Receivables | |||
Trade Debtors | 5,725,400 | 6,209,081 | |
Other Debtors | 1,232,776 | 1,147,345 | |
Inventories | - | - | |
Other Current Assets | |||
Prepayments | 92,746 | 164,699 | |
Total Current Assets | 16,611,931 | 15,259,411 | |
Non-Current Assets | |||
Receivables | |||
Investments | |||
Shares in Listed Companies | 730,000 | 730,000 | |
Other Investments | 184,141,870 | 182,406,279 | |
Investments in JV | (28,259,420) | (28,259,420) | |
Property, Plant & Equipment | |||
Land, Buildings, Plant & Equipment | 1,111,539 | 1,099,679 | |
Mine Properties | 122,431 | 129,848 | |
Exploration and Evaluation Expenditure | |||
Additional Exploration and Evaluation | 353,201 | 353,201 | |
Intangibles | - | - | |
Other Non-Current Assets | |||
Taxation | 45,000 | 45,000 | |
Intercompany Loans | (352,327,861) | (346,755,885) | |
Total Non-Current Assets | (194,083,241) | (190,251,300) | |
TOTAL ASSETS | (177,471,310) | (174,991,889) |
Next, is what I have produced:
The problem with the pivot table is that the pivot (as per any 'pivot') works from left to right, across the page. You can't apply a unique identifer to the 'Total' row to identify which Total the Total refers to.
The problem with the straight table is that the group names are repeated and there is no facility to create sub-totals without scripting this in.
I've tried using 'Indent Mode' but the only way you can get it to look decent is using 'Totals on First Row' which is unacceptable.
Any suggestions are very welcome!
Thanks.
Hi Rakesh,
I came across your post, and experimented with your suggestion. It really works -thanks!!
One question: getting totals, subtotals, etc. is now easy for me. However, do you have any suggestions for putting in lines for various ratios e.g. Gross Profit% i.e (Turnover -Cost Of Sales)/ Turover. Your input will be really appreciated!
Cheers
Arie
has anyone got a example of this? as the link no longer works
Here is the zip, again.
hi rajesh,
i cant get the zip file thru that link b'coz the page is not found, so please attach the zip file once again