Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
disha
Starting Member
34 Posts |
 Posted - 2008-09-06 : 05:10:46
|
| .how do we combine data fro Excel sheet and oracle db .into one single report ...is it possible?actually we are evaluating businessobjects and reporting services. so please let me know pros and cons .. |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-10 : 08:19:11
|
| You can create 2 data sources, one for Oracle & one for Excel via ODBC. This way you can for example put a table from Oracle & a table from your Excel sheet in the one report. However, I don't think you can combine them into one table in SSRS. If you want to mix the data, SSIS is probably the way to go. I would recommend creating a regular load process into SQL Server, combine your data how you want & then run the report off the combined data. |
 |
|
|
|
|
|
Combine Data fro Excel Sheet and Oracle