How to create company specific and all company reports

guganvarman_21

Hi

I have to create a report for sales.I have 10 companies in single database.So now i need to create a sales report that includes all the companies data. In case if i need to see the report for single company alone then i should have an option to select the respective company.
By default i need it to get report for all companies.

Thanks
Gugan

SanderDk

Hi Gugan,
What i do is create the first dataitem of a report with Company.
Foreach for the dataitem I use ex CUSTOMER.CHANGECOMPANY(Company.name)

guganvarman_21

Sure SanderDk
But the thing is Company information table has only that respective companies information.When i select different company and open that company's info table it has only that respective company details.How can i link all the company within one companies database.

AK

It's not the "Company Information" table but the "Company" table, as SanderDk wrote.

SanderDk

@AK is correct
It is table 2000000006 - Company