report runs in XI but not in 8.5

[vijendras]

Hi,

I have this report which was built in 8.5 and was running fine earlier and then we moved this to XI , which works fine as well. When I try to run the initial copy of the report which is in 8.5 I am facing some problems, the report being generated is not the same which I used to get earlier.

Cross checked everything in the report with XI , nothing seems to be differenet. XI report is running good but not 8.5 ...

Why this could be happening??

[phandlin]

If you have two tables linked, the main change between 8.5 and 9/XI is in the SQL statement. I had 8.5 reports where I had to "manually" edit the SQL statement to get a concatenated field in one table to match the 2 separate fields in the other table:
8.5 - SQL statement edited
e.g. BUILDING+ROOM = BLDGROOM

9/XI
you now have to "Add Command" and put the statement in the new command, (you can right click to rename the command), but the fields show up in your list of fields as command.xxxx, not table.xxxx

see if that's a possible problem in your old 8.5 reports