Detailed Filter

[srinu_anu2007]

Hi,

How to write the below Sql statement in cognos detailed filter and when I run the report [Update TMP] should show as current date.

I am attaching a file for [Update Tmp] data. Please suggest you inputs.

2. How to merge two different list reports in one report and there is prompt for those report. I am thinking render variable will work if not please give ideas.

Date ([UPDATE_TMP])=current_date

Environment: Cognos 10.2.2, Report studio, Relational model, db2

Thanks,

[MFGF]

Hi,

How to write the below Sql statement in cognos detailed filter and when I run the report [Update TMP] should show as current date.

I am attaching a file for [Update Tmp] data. Please suggest you inputs.

2. How to merge two different list reports in one report and there is prompt for those report. I am thinking render variable will work if not please give ideas.

Date ([UPDATE_TMP])=current_date

Environment: Cognos 10.2.2, Report studio, Relational model, db2

Thanks,

So the item is a date-time datatype?

Try casting it to a date in your expression

cast([UPDATE_TMP], Date) = current_date

It's not clear what you are asking for your second question. Do you want the contents of two current lists in a single list? Do you want both lists preserving but to exist in the same report? Something else?

MF.

[srinu_anu2007]

Exactly It's a date-time data type.

Cast is not giving any data.

I will post you later about my 2nd question.

Thanks,