Using dataset in impromptu

[sri11]

I have created two different reports from a same catalog. I want to use the second report as a dataset for the first report. So in the filter when I choose dataset and click on the second report - I am getting an error No column selected!

I have not modified any of the sql of the reports.
Any thing wrong in my approach.

Thanks in advance
Sri

 

[griffindm]

Sri,

Depending on what you are trying to do, you are either very close, or a ways off what you need to do.

If you are using data from the first report as a filter in the second report, all you need to do is select the column from the first report while in the Open dialog created when you selected DATASET ( as in a filter of Acct in DATASET - select column acct in the first report). If you click on the Open button of the dialog without selecting a column in the dataset report you will get the "No column selected!" message.

If what your are trying to do is use the data from the first report as main query data in the second report, there is a different method needed to make that work. Let me know if that is the case.

HTH,

Dave Griffin