Hi,
Sometimes cognos doesnt work well with IN clauses. So you can replace IN with OR... it may not be an optimal solution but it worked for me once..
Also, if above doesnt work, then try re-building the whole report in the new version of Cognos.
hi, i have not worked with Impromptu 7 but going from the resolution posted, does it mean that there is no NULL in Impromptu 7 ???
I had this problem in Impromptu 6 when connecting to DB2 on os/390 when NULL in Impromptu was not being recognised. So i used to compare with ''.
hi,
what i would suggest is that you dont try to capture user requirements in the Macro.
What i would do is make an Impromptu report with in-built impromptu promts and run this report via the Cognos Macro.
So what would happen is that a user invokes the macro which in turn triggers off the...
hi,
this can be easily done in the SQL's that you use for your IQD's. In that, for each month, for a particular case, you would have to calculate the STATE of the case as to whether it is Active etc.. based on the date of the state and the running month in the SQL. The condition you can use is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.