How do I dynamically set parameters?

[kkrobinson]

Hi,

This may be a very simple question, but I'm fairly new to RS.

I'm calling an RS report using a parameterized URL and passing in the value for the parameter p_rptId.  Using this parameter I need to run a query against the database to return the report name and some other values.  The query looks like this:
select rpt_name, val1, val2, val3 from rpt_info where rpt_id = ?rptId?" and since rpt_id is the primary key I know I'll only get back one record.

The result looks like this:
rpt_name            val1 val2   val3
--------------------- ----- ----- -------
Cashier Report    X      Y     Z

I need to use the rpt_name, val1, val2, and val3 returned values throughout the prompt pages in the RS report.  I know I can use a value prompt and then, using Javascript, grab the data value, but was hoping to do this w/o Javascript.

1. Is there a cleaner way to do this without Javascript?  I would need to be able to access the four values returned in the one record from the database.

Thanks in advance for your help.

Keith

[CognosPaul]

If you're trying to stay away from JavaScript, you could try using a parameter map. You'll need to set up four parameter maps, one for each value, with the key as the rpt_id. Then you could reference it in the queries as #$rpt_nameLookup{prompt('rptId','string')}#

[kkrobinson]

Thanks.  I'll give that a try, but I was hoping to grab the data from a table to make it dynamic.

[CognosPaul]

You can set a parameter map to look at a table.