manutd1313
Technical User
Hi,
Forgive me, I'm new to Crystal and in a bit of time crunch. I have a main report that is grouped by Financial Hierarchy (group header 1), then funding account (group header 2). I have one subreport that gives me totals by funding account. I'm using shared variables to pass those totals to the main report. Now I need to sum those totals by financial hierarchy group.
subreport formula:
whileprintingrecords;
shared currencyvar shared_forecast :=Sum ({REPORT_BASE_MKTG_ACTS.AFA_FY_FORECAST}, {REPORT_BASE_MKTG_ACTS.FA_FUNDING_ACCOUNT_ID})
main report formula:
whileprintingrecords;
shared currencyvar shared_forecast;
shared_forecast;
The subreport resides in group header 2 and main report formula resides in group footer 2.
I'd like to have the total appear in group footer 1. Any thoughts would be extremely helpful
Forgive me, I'm new to Crystal and in a bit of time crunch. I have a main report that is grouped by Financial Hierarchy (group header 1), then funding account (group header 2). I have one subreport that gives me totals by funding account. I'm using shared variables to pass those totals to the main report. Now I need to sum those totals by financial hierarchy group.
subreport formula:
whileprintingrecords;
shared currencyvar shared_forecast :=Sum ({REPORT_BASE_MKTG_ACTS.AFA_FY_FORECAST}, {REPORT_BASE_MKTG_ACTS.FA_FUNDING_ACCOUNT_ID})
main report formula:
whileprintingrecords;
shared currencyvar shared_forecast;
shared_forecast;
The subreport resides in group header 2 and main report formula resides in group footer 2.
I'd like to have the total appear in group footer 1. Any thoughts would be extremely helpful