Focal Point
[SOLVED] Create chart from Report?

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

October 30, 2017, 01:15 PM
BSBAL18
[SOLVED] Create chart from Report?
I know this has to be possible. I have a report that i would like to generate a chart from.. .whenever i go to "new chart", it prompts me for a .MAS to reference and does not show any .fex files. I must just be doing something backwards....

This message has been edited. Last edited by: BSBAL18,


AS Version: 8201
Gen: 10202016
Windows, All Outputs
October 30, 2017, 01:25 PM
MartinY
You cannot create a chart from a report. You can drill (link) a report to a chart or vice versa.

Every input for a report or a chart has to be a master file (a source of data).

If your "report" (fex) do create a HOLD file, then from that HOLD file you can create a graph/report but you are still creating the graph from a source of data not from a fex.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
October 30, 2017, 01:32 PM
BabakNYC
I can think of two ways of accomplishing this.

1. Create an Active Report with all the metrics and dimensions you'll need in a chart. Once you run the report, you can chart any of the columns by another column with many different chart types.

2. In InfoAssist+ while you're creating a report, you can click the Chart button from the top left hand side, and the columns you have in the report will switch to a default chart using the same master file and columns you have in the report.


WebFOCUS 8206, Unix, Windows
October 30, 2017, 01:48 PM
MartinY
quote:

I can think of two ways of accomplishing this.

1. Create an Active Report with all the metrics and dimensions you'll need in a chart. Once you run the report, you can chart any of the columns by another column with many different chart types.

2. In InfoAssist+ while you're creating a report, you can click the Chart button from the top left hand side, and the columns you have in the report will switch to a default chart using the same master file and columns you have in the report.


Not to contradict you Babak, but technically the above solutions do not create "New Chart".
In the first one, once the report is executed you are using an option to show the report result as a graph but nothing is "new", you cannot "save" the new chart as something you can reuse.
In the second you just change the output format to become a graph instead of a tabular report. Sure that if your original report already been saved and you then change the output from report to graph and perform a "save as", yes it's kind of creating a chart from a report.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
October 30, 2017, 01:49 PM
Doug
The most basic way is to change
"TABLE FILE [filename]" TO
"GRAPH FILE [filename]" ... and go from there.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
November 06, 2017, 10:46 AM
BSBAL18
I am having trouble implementing this. I am new to WF (2017) and use primarily the GUI. I understand the hold-file, but how do i run the report to hold the file, and then use that as my reference for the chart?


AS Version: 8201
Gen: 10202016
Windows, All Outputs
November 06, 2017, 11:05 AM
Mike Williams
On the report go to the FORMAT tab then choose your output (format/database formats) choose FOCUS or XFOCUS. You will be prompted to add index fields at this point, after hitting "Ok" stay on the FORMAT tab and click on the DESTINATION(HOLD) icon, name your hold file.

Keeping your current procedure open, move over to the Procedure View window, right-click New - Chart. When the Chart Wizard window opens select the master file from the hold file you just created.


WF Version 8105
November 06, 2017, 11:07 AM
BabakNYC
https://webfocusinfocenter.inf.../pdfs/wfinfoasst.pdf

Chapter 11.


WebFOCUS 8206, Unix, Windows