[SOLVED]: 1 procedure to show 4 times on 1 HTML Page

Hi,
Here is what I am trying to do.
I have 1 procedure with a few parameters and one of the parameter is BY_TYPE.
Based on the value of BY_TYPE, the report runs either by PART, By Supplier, or By Region.
Basically, what I would like now is to call this procedure 3 times on the html page so it shows 3 different reports i.e 1 by supplier, 1 by part and 1 by region.
I realize that I can create 3 different procedures but I would prefer to keep 1 procedure.
I am not sure how to 3 different value for the same parameters 3 times using HTML composer in App studio.

Thanks

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

WebFOCUS 8202M

Posts: 167 | Location: Montreal | Registered: September 23, 2014

Dave

Master

posted

Hide Post

Hi,

I think we've all been there in some way.
We make, what we call, "starters".

This is your desired report:
smart_report.fex

Then make:

start_1.fex

-SET &BY_TYPE = 'Vanilla';
-INCLUDE ... .../smart_report.fex

start_2.fex

-SET &BY_TYPE = 'Cherry';
-INCLUDE ... .../smart_report.fex

start_3.fex

-SET &BY_TYPE = 'Kiwi';
-INCLUDE ... .../smart_report.fex

Good luck,
Dave

_____________________
WF: 8.0.0.9 > going 8.2.0.5

Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010

Ignored post by Dave posted

Show Post

Platinum Member

posted

Hide Post

Thanks..that's exactly what I am doing right now and works fine using 4 different procedures.

What I am trying to do is avoid 4 procedures and work with just 1.

Maybe I will need to go with javascript way.
Have 4 edit box (hidden) with values and pass that on.

WebFOCUS 8202M

Posts: 167 | Location: Montreal | Registered: September 23, 2014

Ignored post by BM posted

Show Post

MartinY

Virtuoso

posted

Hide Post

What Dave is suggesting, and this is how we all (most of us I think) do, it's one of the most simplest way.

In HTML Composer each element will refer to its own fex where each fex will then call a common one that creates the report. So you really only have one fex to maintain since the referenced fex only have a SET and an INCLUDE.
And no need to change the HTML/js/jquery.

Another way could be the one you mentioned where you'll need to pass a hidden parameter to call a single fex.
But this need you to manage the HTML/js/jquery which may be, according to me, more painful.

Yours to decide.

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

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Ignored post by MartinY posted

Show Post

Platinum Member

posted

Hide Post

ok .. 4 procedures it is