Run Crystal reports for multiple companies

mohit0989
Member Posts: 13
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!!!
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!!!
0
Comments
-
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.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions