Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Generating dynamic Pie charts and Simple reports
Go
New
Search
Notify
Tools
Reply
  
Generating dynamic Pie charts and Simple reports
 Login/Join
 
<Sengott>
posted
I am new to the Web focus tool. I need to generate a report with the following format. A main pie chart drawn for all the severity found for all the platforms in my database. (I have used the severity name in the x and y axis to plot the graph). Then sub graphs showing the severities for each particular platform. The count of the sub graphs depends on the count of the platforms available. Similar to the main pie, I have plotted the sub graphs with severity in the x and y axis and plotting the platform name in the across axis. This part of the report is done. Now I want simple reports (tabular) below the pie charts to be generated with the few selected field corresponding to each platform. As of now I have created three separate procedures for each platform (say Oracle, SQL, UDB by filtering it through the where clause for each procedure) and have imported all the procedures in one html layout. All I want to know is is their any means by which I can pass the platform name dynamic to the procedure. That is like say, I have 'n' platforms I get 'n' no of sub pie graphs by just giving the platform name in the across axis. Similarly will I get tabular reports corresponding to these 'n' platform? Can this be done through a procedure in a simple report? I have just shown a fragment of the code that is taken from one of the tabular Report Procedure. Here ASGN_GRP_I corresponds to the Platform ID

WHERE ( NEWDATE GE '&STRT_TIME.START DATE.' ) AND ( NEWDATE LE '&END_TIME.END DATE.' ) AND ( ASGN_GRP_I EQ 12238 );
 
Reply With QuoteReport This Post
Member
posted Hide Post
quote:
All I want to know is is their any means by which I can pass the platform name dynamic to the procedure. That is like say, I have 'n' platforms I get 'n' no of sub pie graphs by just giving the platform name in the across axis. Similarly will I get tabular reports corresponding to these 'n' platform? Can this be done through a procedure in a simple report? I have just shown a fragment of the code that is taken from one of the tabular Report Procedure. Here ASGN_GRP_I corresponds to the Platform ID

WHERE ( NEWDATE GE '&STRT_TIME.START DATE.' ) AND ( NEWDATE LE '&END_TIME.END DATE.' ) AND ( ASGN_GRP_I EQ 12238 );


You're asking for two things, and I'm not sure which you want. You say you "get 'n' no of sub pie graphs by just giving the platform name in the across axis. Can this be done through a procedure in a simple report?". But you start off by saying "All I want to know is is their any means by which I can pass the platform name dynamic to the procedure".

Both options are available.

To get several TABLES, with a 'separate' TABLE for each of a set of values (in your case Platform ID), you should add a sort for the field (BY ASGN_GRP_I), and specify the PAGE-BREAK option.

Or, if you want to pass that value to your request, code it as you do for start and end time. Your selection would look like:

ASGN_GRP_I EQ &PLATFORM_ID.ASGN_GRP_I.

The variable asked for is &PLATFORM_ID; the prompt (in this example) is ASGN_GRP_I.
 
Posts: 25 | Location: 2 Penn Plaza 28 fl | Registered: March 27, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Generating dynamic Pie charts and Simple reports

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.