Using SQL objects in Report Studio

[guthikv]

Hi all,

I am trying to create a report with three sql objects s1, s2, s3. S1 populates first prompt and S2 popluates second prompt and S3 is the report query. I am doing a cascading prompt from S1 to S2 and run the report.All the sql objects hace a simple 'select' statements only. For some reason after selecting S1 it throws an error saying that S2.columnname doesn't exists. Any thoughts how it should be implemented?
I am using Cognos 10.1, Oracle DB.

Thanks.

[guthikv]

Anyone ideas??? Did anyone implement the same and have issues?

Thanx

[squish88]

Did you set the cascade source in s2?