IS it possible to take total of 4 columns in one row in accordian report in subheading or subfooting.
I have accordian report: BY DIVISION BY DISTRICT BY STORE
I want DIVISION to show DIVISION LEVEL SALES TOTALS WHEN USER EXPANDS DIVISION IT SHOULD SHOW DISTICTCT and STORE LEVEL DETAILS FOR EXAMPLE /* +DIVISION1 P1 p2 P3 1000 2000 1500 +DISTRICT1 500 1200 800 +STORE1 500 900 700 +STORE2 0 300 100 +DISTRICT2 500 800 700 +Store x x x /*
Is it possible?This message has been edited. Last edited by: Kerry,
Kerry Zhan Focal Point Moderator Information Builders, Inc.
June 03, 2010, 05:11 PM
wf1998
COl1 ONE TWO THREE FOUR subt1 subt2 ---- ---- --- ----- ------ A 10 10 10 10 N N B 5 5 5 5 Y N C 3 3 3 3 Y N
E 10 9 8 6 N Y F 8 8 8 8 N N SUB_CALC 10 9 8 6
Create Another two Colomns like subt1, subt2 and Assign value 'Y' or 'N' depends on the colomn. in Print Statement for subt1, subt2 Columns use NOPRINT
Ex: subt1/A1 = IF COL1 EQ 'B' THEN 'Y' ELSE IF COL1 EQ 'C' THEN 'Y' ELSE 'N'; Ex: subt2/A1 = IF COL1 EQ 'E' THEN 'Y' ELSE IF COL1 EQ 'F' THEN 'Y' ELSE 'N';
ON RECAP SUB_CALC= subt2 subt2
ON SUBFOOT SUB_CALC
Env Prod:WebFOCUS 7702 ,Windows xp on 64, SQL Server 2008, IRF Tool Env 1 Local: DevStudio 7702 - MS Windows XP SP2 - Apache Tomcat 5.0.28 Output: HTML, Excel and PDF
June 03, 2010, 09:20 PM
Arif
quote:
How to produce a Summary level Accordian Report
Link provided above is good but its expanding too much for every level.