| Author |
Topic |
|
sprotson
Yak Posting Veteran
75 Posts |
 Posted - 2013-04-22 : 04:14:57
|
| I curretly deploy reports built in Visual Studio to SSRS.I have been asked to investigate other reporting tools in order to build reports for Oracle servers.I understand that I can connect to an Oracle database using SSRS, but I have a question around deployment of reports.Is it possible to install SSRS on a machine that does not have SQL server, so that reports can be deployed to it? The reports would be built on a machine that hs sql server and then deployed to SSRS on a machine that does not have SQL server. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-22 : 04:27:41
|
| ssrs should have a native database engine installation, as the metadata about reports are stored in two sql server databases itself.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
sprotson
Yak Posting Veteran
75 Posts |
Posted - 2013-04-22 : 05:25:36
|
| Thanks, not the answer I was looking for unfortunately.I have tried various free reporting tools that have all been a bit of a letdown and were not as easy to use as SSRS.The best that I have seen was Jasper, but it was still a lot more difficult to use than SSRS |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-22 : 05:29:45
|
quote:
Originally posted by sprotson
Thanks, not the answer I was looking for unfortunately.I have tried various free reporting tools that have all been a bit of a letdown and were not as easy to use as SSRS.The best that I have seen was Jasper, but it was still a lot more difficult to use than SSRS
If you've a machine with SQL Server why cant you install SSRS also on it and deploy the reports there itself? you can always invoke reports using report viewer URL------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sprotson
Yak Posting Veteran
75 Posts |
Posted - 2013-04-22 : 06:27:43
|
| The reports are built using visual studio and then deployed to a client.In the main most of our clients use SQL server, but a few new clients use Oracle.It has been suggested by a colleague that we could maybe use SQL express, and install that on our clients machines.Does that sound plausible? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-22 : 07:10:35
|
| SQL express doesnt have SSRS included unless you install advanced services too------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sprotson
Yak Posting Veteran
75 Posts |
Posted - 2013-04-23 : 05:04:35
|
| Should you be able to connect to an oracle databse using SSRS in SQL Express with advanced services? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-23 : 13:10:57
|
| it depends on data source you define and has nothing to do with edition i guess------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
SSRS - Oracle Data Deploy Report