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,
*This post is locked for comments
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".
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
