Hi,

I am new to WebFocus and trying to create a report on App Studio where I have a summary report which drills down to a detailed report.
I need to create an optional multi-select prompt on a field called 'Vendor' but I do not want to include it in the report canvas in the summary report (because it is further detailed information and thus setting it to noprint would also not work). When a hyperlink is clicked on the summary report, I need to be able to pass any selection made for the 'Vendor' prompt as filter to the detailed report as well.
Is there a way to pass selected value(s) for optional prompt in a hyperlink to another report, without including the field on which the prompt is created in the report canvas?
Any help would be greatly appreciated!

Thanks,
Shweta

This message has been edited. Last edited by: <Emily McAllister>,

Hi,
I'm not sure I completely follow you.

-You have a drill down from a Summary fex to a detail fex
-You want the user to have the option to get a prompt from this drill down that gives them a list to choose multiple?

Do you mind using the auto prompt or do you want to pass them to an HTML page?

Below is for an autoprompt:

If I have this correct, one option would be to set a filter WHERE statement with a dynamic parameter with the values embedded in the WHERE statement in the detail report on it's own line.



From the drilldown:

Set a drill down menu option that will not include the auto prompt. For this drill set the auto prompt parameter to Constant Value = 'FOC_NONE '. (You may want to read up on FOC_NONE and _FOC_NULL)
This will cause the line to be ignored when this link is used.

Set another drill down menu option and do not include the auto prompt variable. When you run this link the auto prompt will pop up and the user will have to make a selection to continue.

Please let me know if you need anything clarified.

Also, let me know if you want to pass variables and open an HTML page with listbox/run button on it instead.

-Msondra