Madatory Prompt from a package

[spicysudhi]

Hi

I want to place a mandatory user prompt for every query designed from a package.

My package contains the currency code column and for every currency there is one record. User must select one currency before he successfully runs any query from that package. How to make this filter mandatory?

-------------------------

Alternativelly....
Can someone suggest me a better way to do currency conversion in ReportNet. Problems like:
1. User must be able to see the value in any desired currency
2. Currency symbol must be the currency selected by the user

Example: A report contains some values, I dont want to match the user locale to the currency, since a user in Europe may want to see the values in USDs. It must be something similar to PowerPlay.

thanks in advance.

regards,
Sudhi

http://www.sudhi.com

Yahoo!,MSN,AIM: spicysudhi

 

[spicysudhi]

an update and a query.

i found the optionn to force to user to enter value when the query using the prompt macro function.

[DB].[CURRENCY].[CURR_CODE] IN ( #promptmany ( 'Currency Code')# )


but the question I got is is there anyway of amnking this Input firld filter to a Drop down or list box filter, from where user cans select the values instead of type-in.

thanks

sudhi

http://www.sudhi.com

Yahoo!,MSN,AIM: spicysudhi