[CLOSED] 1 report - several ways of presenting

May 15, 2012, 01:03 PM

Hi,

I'm new to WebFocus, so please bare with me if I'm blabbering...
I'm trying to create a guided report with the following content:

A number of filters/column selectors (easy enough)
A pivot table depending on the chosen attributes/measures (no real challenge)
Some graphs on subsets of the pivot table data (this one's a pickle...)

The pivot table fex is created and the html-file works too, but the graphs are giving me a run for my money:
To avoid launching several queries, I'd like the graphs to use the data from the pivot table fex. (1 query --> 4 different presentations)
I'm guessing I need to use a hold-file and create a fex for each graph, but then how do I make sure the hold file is created once?
Also, is it necessary to create a separate fex for each graph?

Am I even making sense? (long day at the office

)

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

May 21, 2012, 01:52 PM

Kerry

Hi Peter,

Has this issue been resolved? If not and if you have not done so, for this kind of involved issues, please open a case with Customer Support Services for assistance. You may call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

May 22, 2012, 11:31 AM

susannah

when you say 'Pivot Table', do you actually mean Excel Pivot Table?

June 06, 2012, 11:34 AM

Peter

@Kerry: Sorry, I got sidetracked on other issues; I did indeed receive feedback from IB
@Susannah: No, I meant to say a table with 'across' fields; I'm still new to the IB vocabulary

To properly close this thread; I was advised to create a fex in 4 steps - see the abbreviated example below

-* Step1: Dump data in holdfile
TABLE FILE CAR
  SUM
    DEALER_COST
  BY CAR
  ON TABLE HOLD AS HLDDATA
END
-RUN
-* Step2: Run graph on holdfile + store as xchart holdfile
GRAPH FILE HLDDATA
  SUM
    DEALER_COST AS ''
  BY CAR
  ON TABLE HOLD AS XCHART FORMAT HTMTABLE 
END 
-RUN
-* Step3: Run table on holdfile + store as xdata holdfile
TABLE FILE HLDDATA
  SUM
    DEALER_COST
  BY CAR
  ON TABLE HOLD AS XDATA FORMAT HTMTABLE 
END
-RUN
-* Step4: include hold files in HTMLform
-HTMLFORM BEGIN
<html>!IBI.FIL.XDATA;<BR/>!IBI.FIL.XCHART;</html>
-HTMLFORM END