[development-axapta] Quering Through multiple companies

[themudmullet]

Hi All

I need to find out wether it is possible to write a query in a 
report that will look through more that one companies data.

Currently i am doing something like this 

if (DPS)
       { ChangeCompany('DPS')
          { this.DoQuery(); //This writes all the data into a 
                            //tmp table so i can get the report out
          }
       }
      if (EPS)
       { ChangeCompany('EPS')
            { this.DoQuery();
            }
       }
but would like to know if there is a better or easier way.

Maybe if i can force Axapta to let me use normal SQL statement and i 
can just include the relevant DataAreaID's

Any help would be appreciated

Thank
Jason