Data is Changing When Report is Moved From Dev to QA

[psandhya408]

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

[wyconian]

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 ;-)

[psandhya408]

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