Displaying Group Total after a specified no. groups ..

[melbenmartin]

HELLO ALL , GREETINGS ..

I HAVE A REPORT "PROFIT AND LOSS" WHERE IN I HAVE TO CREATE A TOTAL AFTER FIRST FOUR GROUPS then i have to create a total for remaining groups(Credit column and Debit column).

Plz help me on this how to create a total on the First set of groups and how can i insert a section on that area and second part of the group too i have to insert a section to display the total ...

thanks in advance...

Regards,
martin.

 

[lbass]

Create a formula like this:

if {table.groupfield} in ["Groupinstance1","groupinstance2", etc.] then
"Credit" else
"Debit"

Make this your group #1. Then you can just insert summaries at the group #1 level.

-LB

 

[melbenmartin]

HI LB,

Thanks for your reply .. Still I would like to have a detailed information on this....

OpeningStock (GP no 1) Debit Credit
------------
vat@4% 0.00 1000.00

Purchase (GP No.2)
---------
Purchase Ledger 200.00 0.00
Purchase Ledger 300.00 0.00

Sales (GP no.3)
-------
Sales value ledger 0.00 200.00
Sales value ledger 0.00 300.00

Closing Stock(GP no.4)
-------------
Purchase Ledger 200.00 0.00
Purchase Ledger 200.00 0.00

Cross Profit(Not Group) TOT=Sum(Credit) - Sum(debit)
---------------------------------------------------------
Cross Proft CrossProfitvalue
Expenses(Groupno.5)
--------------------
expense no 1 300.00 0.00
Income(Groupno.6 )
-------------------
Income Value 2000 0.00
--------------------------------------------------
how can i calculate the above two group total of Credit+ CrosProfitvalue- debit total of the above two group ..

this is the format i want o have the report ...

 

[lbass]

Then the formula for your outer group should be:

if {table.groupfield} in ["Opening Stock","Purchase", "Sales", "Closing Stock"] then 1 else 2

Are debit and credit separate fields in your database? If not, how do you disinguish them?

-LB

 

[melbenmartin]

Yes, credit and debit are separate fields in database....

ok fine i can use the formula .. then how can i sum the total of the respective fields for 1 and 2 .can you plz explain with code ..

plz .. sorry to bother you much .. really great ....


thanks..
martin

 

[lbass]

You should be able to simply place the two fields in the detail section and right click on each and insert sums on them at the new group level.

-LB