Query is different between 2 machines

[bhattm]

Hi,

I am moving an impromptu IMR to different Machine, But the query is different,
The query actually have all correct joins, But when the IMR is moved it looks like an indvidual queries?
The catalog is same. I do not know what is the issue or where should I start

[kcjones]

Open the report on each machine and look at the Query dialog under the Client/Server tab and make sure the Query processing options are the same on both machines.