Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Passing shared variables based on group totals in the sub report to Main report - CRW 2008

Hi,

 

I am passing global parameters from the main report (run as of date & item code range, category code range) and then need to pass back
shared variables based on group totals from the sub report to the main report.   I have setup formula in the main report calling
the shared variables from the sub-report, however the totals from the sub report are not calculating & passing through properly.  

The sub-report at item level total is working perfectly in the main report, however the shared variables from the sub report are not
summarising to the category level or grand total.   

On the main report, the shared variables for category group totals and report totals from the sub-report are just printing the values for the last
item on each section (viz not group totals).  On the sub-report, I have placed the formula for each of the shared variables on the canvas in either the same section as the footer to which  the category total or grand total reports but that hasn’t helped the totalling. 

Sub report  is linked on “AsOfDate & item code.   Have also tried linking on Cat code.  Item code link & cat code link are set to
select data based on sub report fields.

    

For testing, I’ve saved out the sub report as  new report (separate from the main report) and the category & grand totals and variable formula appear to be working perfectly when separated from the main report.

Based on the samples below, XY category totals are just printing 2, $40, and for Category Z, the cat totals are just printing $ 7, $90
for both category and the report grand totals are printing &, $90, all being the last record read in that group or for the report total

I know i need to initialise the group header of each section.

Sample Data:

Item Qty Amt

Cat XY

A   4, $ 30

B  2,  $40

  Cat XY total  is 6, $70

    

Cat Z

C 5, $10

D 7, $90

  Cat total is   12, $100

Grand total should be 18, $170

Report is like this

Main report

Group footer #3 Item code <Sub report group footer 2 of Item totals>   <other fields & sub totals from different tables >

Group footer #2  (other sort) 

Group footer #1 Category totals   <@vCatSalesQty>  <@vCatSalesAmt>   other totals from the main report

Report Footer  (Grand totals)        <@vGTSalesQty>  <@vGTSalesAmt>  

      

Sub report: Sales file – sorts category, then item code

Detail   (Suppressed):     <Item Code>  <Month>  <Qty> <Amount>

Group Footer 2 Item totals     <Qty, Item>  <Amount, Item>  

Group Footer 1 Category totals (hidden)  <Qty, Item>  <Amount, Item>  

Report Footer Grand total (hidden)   <Qty, Item>  <Amount, Item>  

For Category totals I created a formula in the sub-report to declare and set all the variables.  I created
similar one for qty.

WhilePrintingRecords;

shared CurrencyVar CatSalesAmtYTD := Sum ({@Sales Amount YTD}, {ICITEM.CATEGORY});

I created this formula @vCatSalesAmt  (for amount)  in the main report, calling the shared variable, and placed it in Group footer 1 Category totals.  I created similar one for qty.

WhilePrintingRecords;

  Shared CurrencyVar CatSalesAmtYTD;

For grand totals I created a formula in the sub-report to declare and set all the variables.  I created similar
one for qty.

WhilePrintingRecords;

  shared CurrencyVar GTSalesAmtYTD := Sum ({@Sales Amount YTD});

I created this formula @vGTSalesAmt  (for grant total amount)  in the main report, calling the shared
variable, and placed it in Report footer. I created similar one for qty.

  

WhilePrintingRecords;

Shared CurrencyVar GTSalesAmtYTD;

Can someone please let me know why the group totals & report total from my sub report are not calculating correctly?

Not what you were looking for? View more on this topic or Ask a question