Hey,
I am a beginner of Web Focus 8104. I want to create a Drill Through report and I donot know the way. I read help topics and manual and looks like stuck somewhere. I created a small Summary report and small Details report.
The common field between two report is RETURNDATE. I try to hyperlink the two RETURNDATE from both report. After that I donot know what to do. I think a small video of creating a simple drill through would help. I am stuck , please advice

This message has been edited. Last edited by: <Kathryn Henning>,

Ok let recap.
You have a summary report that include a RETURNDATE as one of your fields. You would like to click on the RETURNDATE field and get all the detail information for that date.
You also have the detail report that has similar WHERE statement:
WHERE RETURNDATE EQ &RETURNDATE

Here is how to link them in App Studio:
1) On the report canvas select the field RETURNDATE
2) on the menu tab select "Appearance" and then click on "Hyperlink" to open the hyperlink popup
3) click on the "Add new item" on the top right side of the popup.

3a) delete the value for "Drill Menu Items" or change it to something that make scenes.
3b) select "External Procedure" in "Drill Down Type".
3c) Double click on the source cell to open another popup to select your detail report.
3d) change the "target Frame" to what you desire.
3e) double click on parameter cell to start a new popup
3f) click on the "Add new item" on the top right side of the popup.

3f i) enter the "Parameter Name" to match the parameter name on the detail WHERE statement. in this case "RETURNDATE"
3f ii) "Parameter Type" should be "Field"
3f iii) select the RETURNDATE in "Parameter Value" and click OK

at the end you should have a similar code in the style section of your procedure:

TYPE=DATA,
COLUMN=N6,
FOCEXEC=IBFS:/WFC/Repository/xxx/yyy.fex( \
RETURNDATE=N6 \
),
TARGET='_blank',
$

where N6 represents the RETURNDATE column on your summary report.
The value of the FOCEXEC could be different based on where you are building report (Data Server or Content).
Clearly you could pass more parameters depend on your application.

In Dev. Studio is very similar.
Right click on RETURNDATE field in summary report and select "Options..." and click on "Drill Down" Tab.
Change the "Drill Down Type" to "Execute Procedure" and all the options will appear.

Thanks a lot!