Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     drilldown not working

Read-Only Read-Only Topic
Go
Search
Notify
Tools
drilldown not working
 Login/Join
 
Gold member
posted
Hi,
The fex below has a drilldown on the second column. The first column being printed is a defined column. If that column is not chosen or gets 'FOC_NONE', the drill down shifts to the next column. So instead of the second column being the drilld own, the next columns becomes the drilldown. How do I fix this?

-SET &col1 = IF (&box2 EQ 'N') THEN 'FOC_NONE' ELSE 'COUNTRY' ;
-SET &col2 = IF (&box3 EQ 'N') THEN 'FOC_NONE' ELSE 'CAR' ;
-SET &col3 = IF (&box4 EQ 'N') THEN 'FOC_NONE' ELSE 'MODEL' ;
-SET &col4 = IF (&box5 EQ 'N') THEN 'FOC_NONE' ELSE 'SALES' ;
-SET &abc = IF (&box25 EQ 'N') THEN 'FOC_NONE' ELSE 'ABC' ;


DEFINE FILE CAR
ABC/A3 = IF ('&abc' EQ 'ABC') THEN 'ABC' ELSE '&abc' ;
END

TABLE FILE CAR
PRINT
&abc AS FIRST
&col1 AS 'COUNTRY'
&col2 AS 'CAR'
&col3 AS 'MODEL'
&col4 AS 'SALES'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N2,
FOCEXEC=test7(start=N3 stop=N4),
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END


WF 7.1.1, WF Developer studio 7.1.1, Windows & Mainframe, HTML
 
Posts: 84 | Registered: July 28, 2009Report This Post
Expert
posted Hide Post
Try changing COLUMN=N2 to COLUMN=P2

You may have to determine the actual column and use COLUMN=&boxn.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Your &col1, &col2, ... are to display columns and not in a where clause so you cannot use FOC_NONE as a column name. When I set them to the column names the report appeared to work


WebFOCUS 8103, Windows, App Studio
 
Posts: 80 | Location: NYC | Registered: November 13, 2008Report This Post
Virtuoso
posted Hide Post
The only way around this is to dynamically determine the column associated with the drill-down. Because you are using FOC_NONE (which I agree with Waz that it shouldn't be used sparingly in a column display context - but to each his/her own) to dynamically change the columns for display, the column references (N1,N2, ...) are also dynamically changing.

So you would need to create some Dialogue Manager to calculate needed column references based on selected column. Those variable would then replace the N2, N3, and N4 references in your drilldown code in the stylesheet.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Guru
posted Hide Post
Remember that just because Developer Studio refers to the columns by Nx doesn't mean that you have to too.

Replace your COLUMN=N2, with COLUMN=&DRILL_COL, and calculate the value &DRILL_COL should have.

I also don't like the idea of FOC_NONE as a column name, and would change you code to something like this:

-SET &abc = IF (&box25 EQ 'N') THEN 'FOC_NONE' ELSE 'ABC' ;
-SET &MYCOLS = IF (&box25 EQ 'N') THEN '' ELSE 'ABC AS ''FIRST''';
-SET &MYCOLS = IF (&box2 EQ 'N') THEN &MYCOLS ELSE (&MYCOLS | ' COUNTRY AS ''COUNTRY''') ;
-SET &MYCOLS = IF (&box3 EQ 'N') THEN &MYCOLS ELSE (&MYCOLS | ' CAR AS ''CAR''') ;
-SET &MYCOLS = IF (&box4 EQ 'N') THEN &MYCOLS ELSE (&MYCOLS | ' MODEL AS ''MODEL''') ;
-SET &MYCOLS = IF (&box5 EQ 'N') THEN &MYCOLS ELSE (&MYCOLS | ' SALES AS ''SALES''') ;

-SET &DRILL_COL = IF (&box2 EQ 'Y') THEN 'COUNTRY' ELSE 
- IF (&box3 EQ 'Y') THEN 'CAR' ELSE
- IF (&box4 EQ 'Y') THEN 'MODEL' ELSE
- IF (&box5 EQ 'Y') THEN 'SALES' ELSE 'OOPS';

DEFINE FILE CAR
ABC/A3 = IF ('&abc' EQ 'ABC') THEN 'ABC' ELSE '&abc' ;
END

TABLE FILE CAR
PRINT
&MYCOLS
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=&DRILL_COL,
FOCEXEC=test7(start=N3 stop=N4),
$
ENDSTYLE
END  


NOTE: If you want the default titles for the columns then you can change the line
-SET &MYCOLS = IF (&box2 EQ 'N') THEN &MYCOLS ELSE (&MYCOLS | ' COUNTRY AS ''COUNTRY''') ;

to simply be
-SET &MYCOLS = IF (&box2 EQ 'N') THEN &MYCOLS ELSE (&MYCOLS | ' COUNTRY') ;


You will probably want to change your drill down parameters to variables to.

Cheers

Stu

p.s. I stripped out some of the report formating to save space


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007Report This Post
Expert
posted Hide Post
quote:
NOTE: If you want the default titles for the columns then you can
.. also add the column titles via your .mas.

If your data is a temporary or transient file, any pre-existing columns (i.e not defined or computed) will retain the title attribute from the original .mas (if you have the correct environment settings).

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     drilldown not working

Copyright © 1996-2020 Information Builders