Possible to go to separate report based on drill down parm value?

I have a report that sorts and sums Part records into three part types. When a Part Type is clicked, the report drills to a detail report for that part type.

A request was put in to not show some columns on the detail report for one of the part types.

Is it possible to create another report and drill down to this one with less columns by checking the drilldown parameter (part type)?

Or, can I use the same report for all part type, and in the drilldown report, have a way to not show certain columns if the part type is equal to a certain value?

Any help is appreciated.

Posts: 57 | Registered: February 24, 2004

k.lane

Platinum Member

posted

Hide Post

Of course you can. You can just imbed a -IF into the column display. Something like this:

TABLE FILE CAR
SUM SALES
DCOST
-IF &VALUE EQ '1' THEN GOTO JUMPTHIS ;
RCOST
-JUMPTHIS
BY COUNTRY
END

&VALUE would have been passed from your first report.

Ken

Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Databases: Oracle 10g, SQL Server 2000, DB2.

Posts: 177 | Location: Calgary, Alberta, Canada | Registered: April 25, 2005

Ignored post by k.lane posted

Show Post

Tim J

Gold member

posted

Hide Post

Thanks Ken. Should have known that one. My brain cells already took off for the weekend.
This will work out nice since it happens to be the last group of columns in my report and I can accomplish this with one -IF.

Thanks!

Posts: 57 | Registered: February 24, 2004

Ignored post by Tim J posted

Show Post

Tony A

Expert

posted

Hide Post

One of the methods I use rather than a load of IF THEN statements, particularly if you have the same thing to repeat throughout your fex, is to use something like -

-DEFAULT &Country = 'ENGLAND'
-SET &Ctry_Cmt = IF &Country EQ 'JAPAN' THEN '-*' ELSE '';
TABLE FILE CAR
SUM DCOST
    RCOST
&Ctry_Cmt.EVAL SEATS
&Ctry_Cmt.EVAL LENGTH
BY COUNTRY
BY CAR
BY MODEL
WHERE COUNTRY EQ '&Country'
END

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Tim J

Gold member

posted

Hide Post

Thanks Tony! That also works well! I don't know why I was thinking of solving this at the Summary report level and not directly in the Detail report. I come here to learn!

Thanks,
Tim

Posts: 57 | Registered: February 24, 2004

Ignored post by Tim J posted

Show Post

Please Wait. Your request is being processed...