Rank: Newbie
Groups: Registered
Joined: 6/30/2014(UTC) Posts: 6  Location: New York Thanks: 2 times
|
What would be the preferred way of creating a report based on a local database, then distributing that report to different locations that all use their own copy of that database?
In other words, if I create a report in my office, how can someone in a different location use the same report on their own database? The structures of the two databases are identical, but the info is different. There is no connection between the two offices, they just need the same reports.
Thanks!
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Reports distribution can be achieved by simply copying the .srex files from the repository of the source machine to destination machines...
I would recommend to create Data Source files with the Server Manager, and used it for all of your reports, it will simplify the maintenance, evolution and connection definitions depending on the target database (avoid to define directly Data Sources in reports !)...
To simplify the connection management, you could also decide to create always the same ODBC connection names on all the machines (using ODBC MAnager 32bit), and use it to define your data sources...
Finally the deployment of your reports would be done by file copies...
epf
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/30/2014(UTC) Posts: 6 Location: New York Thanks: 2 times
|
Excellent! Thanks very much.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
