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 |
|
sqlnova
Starting Member
3 Posts |
 Posted - 2009-10-25 : 02:23:22
|
| Hello,Im trying to generate Reports from a Read only version of a database holding our data. Its more of a cloud computing concept, and the vendor has given us credentials to access the dbase for report generation pupose.This is a multi-part question and I hope someone can helpExisting setup:We are using SQL Server Management Studio to write queries, test and execute them. They work absolutely well.What we want to achieve:What can I use as a Report designing tool? We are a very small company and we would like to use opensource or the cheapest alternative. Tried using jasper reports and it was unable to connect to SQL server using JDBC server connections.When I try using Access it keeps giving me errors owing to read only rights. Kind of lost and any help is much appreciated.ThanksJim2. Would like an option tosql enthusiast |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-10-25 : 07:28:42
|
| What about Microsoft Reporting Services? |
 |
|
|
sqlnova
Starting Member
3 Posts |
Posted - 2009-10-25 : 20:13:12
|
| You mean SQL Server Reporting Services? or is this different?We do not have access to SQL Server Rep Services, thats why I wanted to know if there is any other s/w we could use with sql.I have Access 2007sql enthusiast |
|
|
|
sqlnova
Starting Member
3 Posts |
Posted - 2009-10-26 : 18:38:31
|
quote:
Originally posted by robvolk
What about Microsoft Reporting Services?
HelloAny directions much appreciated.thankssql enthusiast |
|
|
|
|
|
|
Reports from a Read only SQL Server copy