Focal Point
[CLOSED] SUBHEAD SUBTOTAL or SUBFOOT SUBTOTAL

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/210103254

May 27, 2010, 05:53 PM
Arif
[CLOSED] SUBHEAD SUBTOTAL or SUBFOOT SUBTOTAL
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,


WebFOCUS 7.6.10
Windows
HTML
June 03, 2010, 04:59 PM
Kerry
Hi Arif,

The following online document may be of interest:

How to produce a Summary level Accordian Report

Cheers,

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.


WebFOCUS 7.6.10
Windows
HTML