SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS - Oracle Data Deploy Report
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sprotson
Yak Posting Veteran

70 Posts

Posted - 04/22/2013 :  04:14:57  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 04/22/2013 :  04:27:41  Show Profile  Reply with Quote
ssrs should have a native database engine installation, as the metadata about reports are stored in two sql server databases itself.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sprotson
Yak Posting Veteran

70 Posts

Posted - 04/22/2013 :  05:25:36  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 04/22/2013 :  05:29:45  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sprotson
Yak Posting Veteran

70 Posts

Posted - 04/22/2013 :  06:27:43  Show Profile  Reply with Quote
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?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 04/22/2013 :  07:10:35  Show Profile  Reply with Quote
SQL express doesnt have SSRS included unless you install advanced services too

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sprotson
Yak Posting Veteran

70 Posts

Posted - 04/23/2013 :  05:04:35  Show Profile  Reply with Quote
Should you be able to connect to an oracle databse using SSRS in SQL Express with advanced services?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 04/23/2013 :  13:10:57  Show Profile  Reply with Quote
it depends on data source you define and has nothing to do with edition i guess

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000