logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
jcarr  
#1 Posted : Monday, June 30, 2014 12:37:33 PM(UTC)
jcarr

Rank: Newbie

Groups: Registered
Joined: 6/30/2014(UTC)
Posts: 6
United States
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!
epf  
#2 Posted : Tuesday, July 1, 2014 10:38:25 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

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

thanks 1 user thanked epf for this useful post.
jcarr on 7/1/2014(UTC)
jcarr  
#3 Posted : Tuesday, July 1, 2014 12:51:20 PM(UTC)
jcarr

Rank: Newbie

Groups: Registered
Joined: 6/30/2014(UTC)
Posts: 6
United States
Location: New York

Thanks: 2 times
Excellent! Thanks very much.
Users browsing this topic
Guest
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.