Dev Studio 7.1.1 - Graph-to-Report Drilldown

Is there a way when using DevStudio 7.1.1. to readily enable a drilldown from a graph to a tabular report, whether in Excel, HTML or PDF. I believe that the graph-to-report drilldown option was available in DevStudio 5.3 but it appears that a drilldown is only available if going to the native text editor.

Questions:

1.) Are there some SET commands, like SET GRAPHENGINE = OLD, to enable drilldowns?

2.) Is the drilldown from graph to tabular data readily available in 7.1.4 or in 7.6?

3.) Any suggestions on drilldowns if coming from the native text editor.

Thanks in advance – Bless you, FOCUS nation!

Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL

Posts: 238 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003

Tony A

Expert

posted

Hide Post

Hi Sandy,

Doesn't look like there are any ways to add drilldowns using the GUI in 7.1.3, but using the text editor should be OK.

Setting GRAPHENGINE = OLD doesn't enable the drilldowns in the GUI either.
Can't comment on the drilldowns in 7.1.4 although I doubt it and I haven't seen 7.6 yet.

As for issuing drilldowns in the editor then there were two methods of achieving this.
1) Using the standard method of stylesheet inclusion (see this post)
2) By using the setURL property using perspective for Java, but I can't get an example to work for you so I would suggest sticking with 1).

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, 2004

Ignored post by Tony A posted

Show Post

S.J. Kadish

Guru

posted

Hide Post

Thanks, Tony. I sincerely appreciate the link. But the question remains for everybody:

Was the drilldown option removed from the GUI moving from the 5.3 versions to 7.1 versions? If so, why was it removed?

Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL

Posts: 238 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003

Ignored post by S.J. Kadish posted

Show Post

N.Selph

Guru

posted

Hide Post

You can add a drilldown using Graph Assistant in the GUI in 7.13. I didn't see it right away either. Go to the second tab "Field Selection". With your field chosen in the Y-axis section and highlighted, expand the arrow at the bottom of the form "Graph Field Options". The first sub-tab "Display" has a Drill Down button (as well as other neat options).

(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)

Posts: 391 | Location: California | Registered: April 14, 2003

Ignored post by N.Selph posted

Show Post

Tony A

Expert

posted

Hide Post

Well done for finding it!

It is interesting to note that the manual - Creating Reports With WebFOCUS Language - only has the hand coded method in chapter 20 (page 45 to 49 if you're interested). I've had a quick scan of the manuals and on-line docs but I still haven't been able to locate any reference to the GUI method.

Jennifer, any idea where this reference might be?

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, 2004

Ignored post by Tony A posted

Show Post

posted

Hi Sandy and Tony,

Yes, this is documented in Chapter 6, Creating a Graph With Graph Assistant in the Creating Reports With Graphical Tools manual. The topic is Field Options Tab in Windows Graph Assistant.

It is worth mentioning that there are two Creating Reports manuals: Creating Reports with WebFOCUS Language and Creating Reports with Graphical Tools. You should refer to the Graphical Tools manual for all GUI information.

Hope this helps.

Regards,
Jenn

Tony A

Expert

posted

Hide Post

Thanks Jennifer, that will explain why I didn't find it then