I have a list report in dev environment. When i move the report dev to QA, the values in the list report are changing. What could be the reason
I have columns which are numbers in the report
when I move it to Qa the numbers are preceeding with zero...(but in dev I don't see that issue)
Also I use the data format setting in the properties of that column to be number
What could be the reason ? Please advice
Hi
Sounds like you have different data in your dev and QA environments. Do you have accesss to the underlying database via something like Toad or pl/SQL? If you do check the data in both environments.
The different date formats sounds like the database settings in QA are different from the settings in dev. I'd suggest you get a dba to check if there are any differences.
I think there are also some settings in the cognos ini files that set date formats, it may be worth checking these are the same. Sorry I can't give you any more details on that but try researching the ini files.
Hope that helps
Good luck ;-)
Thank u for the reply. I changed the data format to the number. Still it is showing the value preceding zero.
Anyways I used cast function and changed it to integer