[SOLVED] Using a hold file as a filter in a report

HI there

I worked myself through the chapter regarding hold files, but didn't find a solution for my issue (or did not understand).

I got following Data Structure

Article Project
x 10
c 10
d 10
x 11
a 11
b 12
g 12

Now I want to know which articles went in the same Project as my "Selection" article.

So I select "x", I got projects 10 and 11.

Article Project
x 10
x 11

In the Report Output I'd like now to filter on projects 10 & 11, but showing all articles.

Article Project
x 10
c 10
d 10
x 11
a 11

So I first select the article, giving the related projects. Then I want to use those filtered projects to filter on the total data base.

Could you please advise how to do that in Infoassist? For my understanding the basic "hold" files are not able to do that?

thanks & regards

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

Webfocus 8.1
Windows 7
HTML, Excel, PDF

Posts: 10 | Registered: November 09, 2015

BabakNYC

Virtuoso

posted

Hide Post

You could make both columns drilldowns that will call the report. Here's an example called self_drill.fex.


ENGINE INT CACHE SET ON
-DEFAULT &COUNTRY =FOC_NONE;
-DEFAULT &BODYTYPE = FOC_NONE;
TABLE FILE CAR
BY COUNTRY
BY BODYTYPE
WHERE COUNTRY EQ '&COUNTRY';
WHERE BODYTYPE EQ '&BODYTYPE';
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N1, TARGET='_self', FOCEXEC=IBFS:/WFC/Repository/Techniques/self_drill.fex(COUNTRY=CAR.ORIGIN.COUNTRY), $
TYPE=DATA, COLUMN=N2, TARGET='_self', FOCEXEC=IBFS:/WFC/Repository/Techniques/self_drill.fex(BODYTYPE=CAR.BODY.BODYTYPE), $
TYPE=TITLE, TARGET='_self', FOCEXEC=IBFS:/WFC/Repository/Techniques/self_drill.fex, $
ENDSTYLE
END

Alternatively, if you're licensed for Active Technology you could analyze your data the way you describe without much coding.

WebFOCUS 8206, Unix, Windows

Posts: 1853 | Location: New York City | Registered: December 30, 2015

J.L. Hinds

Gold member

posted

Hide Post

Try holding the projects.

ON TABLE HOLD AS 'WHAT_PROJECT'

Then add this where statement to the last table.

WHERE PROJECT IN FILE WHAT_PROJECT

WebFOCUS 7.6
Windows, All Outputs

Posts: 74 | Registered: December 23, 2013

Ignored post by J.L. Hinds posted

Show Post