Hello when i try and validate my SQL in Cognos report studio i get the below error.
ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Inconsistent types (7481)
When i use the prompt for invoice_doc.kdate i get the above error.
When i use invoice_doc.kperiod its fine however i want to prompt between dates.
I have tried a few cast functions but not sure if they are correct because i am fairly new to SQL writing.
Thanks
Chris
Quote from: cbyrne123 on 25 Apr 2014 10:06:21 AM
Hello when i try and validate my SQL in Cognos report studio i get the below error.
ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Inconsistent types (7481)
When i use the prompt for invoice_doc.kdate i get the above error.
When i use invoice_doc.kperiod its fine however i want to prompt between dates.
I have tried a few cast functions but not sure if they are correct because i am fairly new to SQL writing.
Thanks
Chris
Looks like a known defect in Progress 11:
http://knowledgebase.progress.com/articles/Article/000046804
If you can tell us more detail about your report and how you need it to work we might be able to suggest a workaround?
Cheers!
MF.