Seal Report Forum
»
Report Edition
»
Data Source Creation
»
Can I use multiple connections to create tables?
Rank: Newbie
Groups: Registered
Joined: 6/30/2014(UTC) Posts: 6  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!
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  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...
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/30/2014(UTC) Posts: 6 Location: New York Thanks: 2 times
|
Okay, sounds good. Thanks for the info.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 12/12/2018(UTC) Posts: 1 
|
Originally Posted by: epf  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?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 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.
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
Can I use multiple connections to create tables?
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.
