I'm working on a drill down report that involves a links in an HTML setting. When I click the link, instead of getting the information for that particular link, I get the information for all the links. I know this is something simple, but I can't figure it out. Here's the source:
TABLE FILE VIEW_NETCOLLS SUM VIEW_NETCOLLS.NETCOLLS.BADDEBT VIEW_NETCOLLS.NETCOLLS.CHARITY BY VIEW_NETCOLLS.LOCCAT2DSC.LOCCAT2DSC WHERE VIEW_NETCOLLS.NETCOLLS.VPSTPDFY EQ 2015; ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE ROW-TOTAL AS 'TOTAL' ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty, $ TYPE=DATA, COLUMN=N1, FOCEXEC=IBFS:/WFC/Repository/Bad_Debt_Charity/rpt_base.fex( \ LOCCATDSC2=N1 \ ), TARGET='_blank', $ ENDSTYLE END
Any direction would be greatly appreciated!
TonyThis message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8.1.05 Windows, All Outputs
August 06, 2015, 03:58 PM
John_Edwards
Can you show us rpt_base.fex as well?
Also, can you show us the html link tag that gets created for the drill-down when you run this focexec?
In my experience it's easier to make the mistake in the target of the drill-down, where you misspell the incoming field name or don't apply it right. Easy enough to do.
And -- a peek at the html that the drill-down generates is useful for figuring out which side of the divide you mis-coded.This message has been edited. Last edited by: John_Edwards,
August 06, 2015, 04:15 PM
Pondog
I think this may be the rpt_base.fex. I've had to hunt around for it.
-* File: IBFS:/Dev/WFC/Repository/Bad_Debt_Charity/Report1.fex Created by WebFOCUS AppStudio TABLE FILE VIEW_NETCOLLS SUM VIEW_NETCOLLS.NETCOLLS.BADDEBT AS 'BAD DEBT' VIEW_NETCOLLS.NETCOLLS.CHARITY CNT.VIEW_NETCOLLS.DEPARTMENT.DEPTDESC NOPRINT AS 'COUNT,VIEW_NETCOLLS.DEPARTMENT.DEPTDESC' BY VIEW_NETCOLLS.LOCCAT2DSC.LOCCAT2DSC AS 'LOCATION' WHERE VIEW_NETCOLLS.NETCOLLS.VPSTPDFY EQ 2015; ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE ROW-TOTAL AS 'TOTAL' ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty, $ TYPE=DATA, COLUMN=N1, FOCEXEC=IBFS:/WFC/Repository/Bad_Debt_Charity/rpt_base.fex( \ LOCCATDSC2=N1 \ DEPTDESC=N4 \ ), TARGET='_blank', $ ENDSTYLE END
Where would I find the HTML link tag?
WebFOCUS 8.1.05 Windows, All Outputs
August 06, 2015, 04:42 PM
Pondog
John_Edwards,
I tried posting the HTML but inadvertently posted some info I'm not sure should be public. I deleted the post and am thinking I should do some more research on Drilldowns and approach the task with a little more knowledge. I greatly appreciate your willingness to help. I'm sure I'll be back.
Thank you, Tony
WebFOCUS 8.1.05 Windows, All Outputs
August 06, 2015, 05:14 PM
John_Edwards
You need to use the incoming variable to limit your search. Something on the lines of
WHERE FIELD1 EQ &LOCCATDSC2
That's the variable you're throwing, you need to catch it in the target and use it. Whatever field you define in the calling fex's drill-down will appear in the target as an amper-variable.