How to pass "userName" parameter in the query ??

peraka

All,

How to pass "userName" parameter in the query ?

do I have to use params["userName"],

could you please let me know a sample query..

Suresh.

mwilliams

If you have a report parameter named "userName", in your query, you can put a where condition, like:

where userName = ?

Then, in your dataSet editor, go to the parameters section. Here, you'll see a dataSet parameter was created. If you double click it, to edit it, you'll be able to link it to your report parameter, params["userName"]. Hope this helps.