Showing data from SQL with variable content

[wdv72]

Hi all,
We would like to create a Cognos report based on content from different tables where the table name is prompted. The content in the tables is variable.

The report should function as drillthrough detail report in a dashboard where the table to get details from is variable.

Without being said that direct SQL should be used, in simple SQL it could look something like this:

Select *
from ?put table name here?

Any ideas anyone?

[MFGF]

Hi all,
We would like to create a Cognos report based on content from different tables where the table name is prompted. The content in the tables is variable.

The report should function as drillthrough detail report in a dashboard where the table to get details from is variable.

Without being said that direct SQL should be used, in simple SQL it could look something like this:

Select *
from ?put table name here?

Any ideas anyone?

Hi,

I can't ever see this approach working. When you author a report and save it, you are defining an XML specification of how to generate the query, which specific items to retrieve, how to arrange those items and how to render them. If the table and the items will be variable, you can never create a report spec to accommodate this - it's not the way a Cognos report works.

Sorry if that's not what you were hoping to hear, but hopefully it means you can look for other solutions without wasting much time on this one.

Cheers!

MF.