use of TOTALSCAUSEDBY

Mrinmay

Hi Exparts,
Actually i want to generate a report with three grouptotal field. The relations of the three fields is
First is field "Type"(Option:Resource,Item,GL Entry). Second field is "Resource Type"(Option: Person,Machine).
Third field is "Person Type"(Option: Permanent,Contract ).
These three fields are there as a secondary key in table.
In data item also i am sorting the table with these key.
Now in section i have put three group header. in first section i am putting "type",second one i am putting "resource type" & third one i am putting "person Type".
now i am putting below code accordingly:

In which groupHeader i am printing Type, on presection of that i am writing:
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY=DataItem."Type");

In which groupHeader i am printing Resource Type, on presection of that i am writing:
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY=DataItem."Resource Type");

In which groupHeader i am printing Type, on presection of that i am writing:
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY=DataItem."Person Type");

Actually the report sholud show like below

Permanent/Cotact(Header)
Body
group Total(Permanent/Cotact)

Mechine(Header)
Body
group Total(Mechine)

Item(Header)
Body
group Total(Item)

GL Account(Header)
Body
group Total(GL Account)

TOATL
Can any one help me how to get in proper headings.

thanks in advance...

Regards,
Mrinmay

Slawek_Guzek

Hi,

Have you tried to analyse what Report Wizard does ? If you select grouping in Wizard it puts automatically some grouping code in group headers / footers.

Just have a look there - it should give you some ideas.

Regards,
Slawek