Hai friends,
Generally If we run a report from BaaN we will get
the data from the default company (i.e From The
company which we are running the report).But if we need the
data from all the companies what we have to do?
where to specify that?

Thanks in advance
Regards,
Rajendar G

in the select statement you can add to the where condition:

...
and tablename._compnr = company_number

Hi Rajendar,
You can select a company by using table._compnr = company.number. But make sure user who runs the report has proper authorizations to that table and also the company should present in same VRC.
Regards,
Rajasekhar

A user does not need security for all compnies in a select when using the tablename._compnr = xxx in the select. Security only comes into play when you switch comanies. The tables do indeed need to be in the same VRC and have the same 1st day of the week.