[SOLVED] Report Caster not including Report GrandTotals
Greetings,
I'm experiencing an issue with Report Caster where it's excluding the report GrandTotals. If I run the report directly with out using RC it works perfectly. Any suggestions work be helpful.
Print Code:
TABLE FILE TMP_HYP_DEPT_SPEND PRINT -* SCNFORCST NOPRINT SHORTACCT AS ' ' ACTUALCM/D12 AS 'Acutal' FORECASTCM/D12 AS 'Forecast' ACFCM/D12 AS '$' COMPUTE AVFPCTCM/D12.1% = (ACFCM/FORECASTCM)*100; AS '%' ACTYTD/D12 AS 'Actual' BUDYTD/D12 AS 'Budget' AVBYTD/D12 AS '$' COMPUTE AVBPCTYTD/D12.1% = (AVBYTD/BUDYTD)*100; AS '%' PROFORMACM/D12 AS 'Proforma' AVPCM/D12 AS '$' COMPUTE AVPPCTCM/D12.1% = (AVPCM/PROFORMACM)*100; AS '%' PROFORMAYTD/D12 AS 'Proforma' AVPYTD/D12 AS '$' COMPUTE ACPPCTYTD/D12.1% = (AVPYTD/PROFORMAYTD)*100; AS '%' BY ENTITY_DEPT NOPRINT BY ACCTSORT NOPRINT BY PARENT AS '' RECOMPUTE AS 'Total'This message has been edited. Last edited by: Kerry,
December 14, 2009, 01:35 PM
Prarie
Are you bursting the report?
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 14, 2009, 01:42 PM
Anthony
Hello Prarie,
Sorry. I should have included that small fact. Yes I am bursting the report. Burst value is on the first By statement "Entity_Department".
-TonyThis message has been edited. Last edited by: Anthony,
December 14, 2009, 03:32 PM
Prarie
I knew I had read this before, so i had to go find it..here's the documentation.
When the SUBTOTAL, SUB-TOTAL, SUMMARIZE, or RECOMPUTE commands are used with burst reports, the WebFOCUS Reporting Server automatically suppresses the grand total.
December 14, 2009, 04:27 PM
Anthony
Hi Prarie,
Thanks for the information. It was very helpful. I added the following syntax to my burt value to fix the issue.
BY ENTITY_DEPT NOPRINT RECOMPUTE AS 'Grand Total for'