Hi @DevBob ,

Not the most elegant way to do this but you can probably include a dummy parameter to that the user gets to see the prompting window and see the comments section for user info.

Something like this would give you the prompt and would not have any impact on the eventual output.

select identity,web_user,active
from fnd_user
where 'X' in
(select 'X'
from dual where NVL('&NOTE','X') = NVl('&NOTE','X')
) 

Cheers,

Hi 

On the quick reports screen you should be able to add the Comments Field using column chooser

Regards

Lee

Wyre Solutions

thank you both! I can use both of these solutions.

Follow-up question- is there a way to default a parameter? That would be very useful.

Hi 

Not in the input screen but you could use something like this in the SQL WHERE Clause

e.g. SELECT * FROM CUSTOMER_ORDER WHERE ORDER_NO LIKE '%&ORDER_NO%'

Regards

Lee

Wyre Solutions

Thx for our quick reply! however I would like ‘A206203’ to be defaulted for ORDER_NO when the prompt window appears.

The only thing you could do is use the saved parameters drop down and save the settings. 

I’ve not really used the feature but I suspect it will be saved to a users profile so would need to save it against a base profile to apply to multiple users. 

Regards

Lee

Wyre Solutions

good idea!

however, they would still have to select it from the saved list; i want them to not have to enter anything initially.

you think it would be easy:

...
and NVL('&NOTE','X') = '<default value>'

or as a 3rd parameter:

and NVL('&NOTE','X','<default value>')

Hi 

The only solution is going to be hard coding a value into the report SQL. 

Give this a try 

WHERE <Field> = NVL(‘<Parameter’,’ABC123’)

Hopefully this will work when the input is null it uses the ABC123 value but is flexible enough to enter an alternative if needed. I think the ‘%’ wildcard should also work.

thx for your reply, however that didn’t prompt anything at all. I tried something similar with no luck.

Hi 

I’ve just tried this in our test environment and it gives the desired result. 

Displays data for BP10111 when no parameter entered and when a parameter is entered returns said record. 

SELECT * FROM CUSTOMER_ORDER WHERE ORDER_NO = nvl('&Order_no', 'BP10111')

Regards

Lee

Wyre Solutions

hmm, i tried that and here’s my results: