Run Crystal reports for multiple companies

mohit0989

Hi,

Can anyone please guide how to run multiple companies in Crystal reports ??I have made a crystal report for a particular company and its working fine,now i want to make it run for all the companies in the Database.How can we pass the company as a parameter ?
Suggestions are welcome =D>

Thanks!!!

Savatage

As far as I know you are probably using crystal reports via ODBC.

That ODBC is probably set up for 1 company.
You can try to setup multiple ODBC connections - giving each company it's own name.
When creating the report you will need to select the proper connection to the company you want.
Which will then allow you to get the fields you want.

let us know if that works for you..we only have 1 company so I've never tried it personally.