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 : Tuesday, July 1, 2014 2:58:59 PM(UTC)
jcarr

Rank: Newbie

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

Thanks: 2 times
Using the Seal Server Manager, is there a way to create a data source in the repository that contains tables that come from two different places?

For example, Let's say I have a SQL database that tracks materials usage over time, but does not have any pricing or costs built into it. All of my pricing/costs are listed in an Excel Spreadsheet. Is there a way to marry the two in Seal Reports so I could generate a report showing cost per unit produced over time or cost of materials used over time?

Thanks again, I have very little SQL query knowledge and I'm trying to wrap my head around it. The graphic interface of Seal Reports has made it much easier!
epf  
#2 Posted : Wednesday, July 2, 2014 6:10:45 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)
No, you cannot have tables from different databases into the same Data Source...
To do that, you need to import your Excel Sheet into your database (using an ETL like SqlServer Integration Services) and then you can add it to your data source and query it in your reports...
jcarr  
#3 Posted : Wednesday, July 2, 2014 1:32:41 PM(UTC)
jcarr

Rank: Newbie

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

Thanks: 2 times
Okay, sounds good. Thanks for the info.
Marc  
#4 Posted : Wednesday, December 12, 2018 10:41:32 AM(UTC)
Marc

Rank: Newbie

Groups: Registered
Joined: 12/12/2018(UTC)
Posts: 1
Netherlands

Originally Posted by: epf Go to Quoted Post
No, you cannot have tables from different databases into the same Data Source...
To do that, you need to import your Excel Sheet into your database (using an ETL like SqlServer Integration Services) and then you can add it to your data source and query it in your reports...

What is the use of creating several connections, if only one (the first?) can be used?
epf  
#5 Posted : Wednesday, December 12, 2018 4:17:16 PM(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)
Mainly to handle different environnements (like DEV, INTEGRATION, PRODUCTION) having the same database schema and tables.

Note that you may use Seal Report Tasks to import Excel Sheets as a simple ETL.
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.