Producing a formatted report - P&L / Balance Sheet

[#1]

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.

[#2]

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

[denwo2010]

has anyone got a example of this? as the link no longer works

[disqr_rm · Accepted solution]

Here is the zip, again.

[kalyandg]

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