Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Adding table in crystal reports, using database expert

Posted on by Microsoft Employee

We have multiple entities setup under different application databases. We are modifying a report that works in all entities. 

When we go to add a new table, it is forcing us to select a specific database. When we run the report it does not work. See example below; the bottom table is what we want to add...but it is forcing us to select the separate database.

Thanks,

5344.test.png

  • Verified answer
    Mark E Profile Picture
    Mark E 6,405 on at
    RE: Adding table in crystal reports, using database expert

    It does not matter which DB you use to connect the tables, as long as that DB has all the relevant tables.  You could, for example, use the SLDemoApp60 DB as the ODBC connection for all your reports, as long as:

    1. It exists on the Server you are connected to, and

    2. Your report does not include any custom tables that do not exist in the SLDemoApp60 DB.

    You should be able to use any of your SL App DB's as the ODBC connection for your report.  Just set all the the tables to use the same App DB using "Set Datasource Location".

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans