March 09, 2007, 09:35 AM
Jeff ElamDrilldown report in same format as host report.
I am calling a report from an external application. One of the parameters that is being passed is &Format, which I use in the following method to display the report in the correct format: ON TABLE PCHOLD FORMAT &Format. I have a drilldown to another report. I'd like that report to display in the same format that was selected from the external app. I've played around with passing &Format and also with using OUTPUT= , but can't get it to work. The documentation seems to indicate that the DEFUALT format will take the format that is passed, but I can't get it to work. Does anyone have a tried and true method?
We are using version 7.6 on Windows XP, with a WebSphere app server.
March 09, 2007, 10:50 AM
Alan BNormally I do something like this:
.
.
ON TABLE PCHOLD FORMAT &Format
.
.
.
TYPE=DATA,
FOCEXEC=FNAME(.... Format='&Format' ......),
.
.
And use &Format in the procedure FNAME. Is this what you mean?
March 09, 2007, 10:54 AM
KameshAre you using SET statement to set the value for format in your drilldown report? If you are using, it will take only the SET value instead of the one you are passing.
Just use the DEFAULT in your drilldown report and give ON TABLE PCHOLD FORMAT &Format under your table. May be you can try with different variable name ie., DISPFORMAT or whatever it's easy.
just a thought,
March 09, 2007, 11:47 AM
Jeff ElamThanks for your help. I was missing the single quotes around my &Format. Works like a charm. Have a great day!