Specify ODBC database in RD @ runtime?

[cgv]

Greetings.

I am trying to specify which ODBC database to use in generating a report...ideally via a user parameter. Note the ODBC datasource is not changing - I dont want to have to create a seperate datasource for every database we have.

I can remove the DB name & owner from the report just fine... however I cant figure out how to make the query accept a variable database name. This example works fine:

SELECT
PA01201."PAprojname", PA01201."PAPROJNUMBER"
FROM
"DATA1"."dbo". "PA01201" PA01201

as does this:

SELECT
PA01201."PAprojname", PA01201."PAPROJNUMBER"
FROM
"DATA2"."dbo". "PA01201" PA01201


however.. this does not:

SELECT
PA01201."PAprojname", PA01201."PAPROJNUMBER"
FROM
{?db_parm}."dbo". "PA01201" PA01201


any idea how this can be done without using the RDC?

Thanks!

 

[deepsheep]

You can use a stored procedure to generate a temporary table with the relavent information in it. you can pass the table name to the procedure and then have it fill the temporary table.