Report delivered with out data

[guntupalli]

Hi all

iam unsing cognos 8.2 version.when i run the report .report result is empty its not showing any data,

report is having prompts in it.

As my knowledge i have done the below things

1.i have taken the native sql query from the report & ran in sql developer schema
its showing data with out any errors
so the problem is at report end..

2.i tried deleting each column to find whether any problem with the particular query subject.
but there is no data still after running the report

GUYS

as iam new to cognos.....

could you please suggest me some senarios to get the report with data

thanks in advance

kiru

[Lynn]

I suspect something to do with your prompts. If they are optional then you won't necessarily see the constraint included in the where clause of the generated SQL. So it would run in the database but when you run in Cognos and select a value the additional where clause constraint comes into play.

[guntupalli]

Actually i have selected some values in prompts still no data..

what all the changes need to do with prompts and where.

thanks
kiru