Dashboard HTML page, output block, multiple selections - how to do?

For the fex that generates the bar graph, can you add list of different graphs in a drop down list, and have it rerun its self to the new graph.

Waz...

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

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Gold member

posted

That's what I'm going for - do you know where i can find some documentation on how to do such a thing? The entire page is considered an 'output' block in BID, and I built the all the frames/graphs/reports in HTML composer. So, composer would be where I need to make these changes and allow for a list of graphs to run for that frame.

WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active

Posts: 90 | Registered: November 03, 2009

Ignored post by jseaburn posted

Gold member

posted

Anyone have any suggestions or can direct me to some documentation?

WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active

Posts: 90 | Registered: November 03, 2009

Ignored post by jseaburn posted

Todd_Wallace

Member

posted

I have some sample code that prompts for different reports. You could easily modify it to point to different graphs. Just build a little interface page with a dropdown of the possible choices.

  
-DEFAULT &SWITCH = 'BMW'
-IF &SWITCH EQ 'BMW' THEN GOTO BMW ELSE IF &SWITCH EQ 'AUDI' THEN GOTO AUDI ELSE GOTO FINISH;


-BMW
TABLE FILE CAR
PRINT 
     CAR.CARREC.MODEL
BY  LOWEST CAR.COMP.CAR
WHERE CAR.COMP.CAR EQ 'BMW';
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
-EXIT
-AUDI
TABLE FILE CAR
PRINT 
     CAR.CARREC.MODEL
BY  LOWEST CAR.COMP.CAR
WHERE CAR.COMP.CAR EQ 'AUDI';
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
-EXIT
-FINISH
END

WebFOCUS 8.1.05
Windows-iSeries DB2, All Outputs
HTML

Posts: 29 | Location: Cincinnati, OH | Registered: August 23, 2011

Ignored post by Todd_Wallace posted

Gold member

posted

This could be what I need! Thanks Todd! I'll give it a shot.

WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active

Posts: 90 | Registered: November 03, 2009

Ignored post by jseaburn posted

Gold member

posted

This works Todd! But my next step is to make that frame a part of an overall dashboard page created in HTML Composer. The parameters are selected for the entire form - I'm assuming this technique would fit right in and can be run using the parameters that are selected for the rest of the page?

WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active

Posts: 90 | Registered: November 03, 2009

Ignored post by jseaburn posted

Todd_Wallace

Member

posted

I have only used it for reports accessed by a single HTML composer page that accesses multiple reportlets in the same FEX. I have seen parameters passed from report to report/graphs in a single HTML page so I know it's possible with compound reporting but I have not done it before. As long as you used the same variable names, accessing the same types of data you should be able to accomplish it though. I saw a presentation about Info Assist where one of our support reps put several graphs and reports on the same page and in the same frame and changed a single variable to change all the reports at once. They did not cross a frame barrier though.
Hope that helps,
Todd

WebFOCUS 8.1.05
Windows-iSeries DB2, All Outputs
HTML

Posts: 29 | Location: Cincinnati, OH | Registered: August 23, 2011

Ignored post by Todd_Wallace posted