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,
Quote from: srinu_anu2007 on 01 Oct 2015 09:39:29 AM
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.
Exactly It's a date-time data type.
Cast is not giving any data.
I will post you later about my 2nd question.
Thanks,