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 |
|
chrisghemm
Starting Member
2 Posts |
 Posted - 2005-11-17 : 22:36:27
|
| Hi! I'm new to SQL so please bear with my question.My question: Is it possible to produce report in SQL without using any reporting software such as crystal report?I'm using a book by Philip Pratt "A Guide to SQL 7th Edition" and working on Exercise 7 on Page 222 (in case someone have it). Questions 5-7 is specifically saying to produce the report if using Oracle. Well the book is Guide to SQL and I was trying to use the codes provided but It does not work on SQL. When I search online for SQL report the only stuff that I can find is using plug-in software. So I'm curious if it is even posible to produce a report in SQL by just using the regular view and/or select statement or do I really need a plug-in software.Thanks! |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-18 : 00:04:47
|
| Hi chrisghemm, Welcome to SQL Team!You can produce the output using a standard SELECT statement, but you won't be able to format it, put headers & footers and paginate it.But you could cut & paste the data to Excel or something like that.Microsoft's Report Services is a free (I think) add-on to SQL Server, so if you need a proper reporting tool for your studies that might be a way to go.Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-18 : 01:26:31
|
| Are you using any Front End Application?If you use VB6, Data Report is part of itMadhivananFailing to plan is Planning to fail |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2005-11-18 : 08:09:09
|
| sql reporting services 2000 is easy to use if u have VB.NET 2003Vicky |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-11-21 : 03:24:43
|
quote:
Microsoft's Report Services is a free (I think) add-on to SQL Server
It's 'free' if you already have a licence for SQL Server or it comes with SQL Server 2005. There is also a forum here that can help you with Reporting Services problemssteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
chrisghemm
Starting Member
2 Posts |
Posted - 2005-11-21 : 14:25:40
|
| Thanks for all your responses. Anyway, I do not have the SQL Software myself. I'm only using a Client Software to connect to our schools/class database to do our assignments from home. This is a great community. I got responses in less than a day. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-11-23 : 18:57:14
|
It's only free MS RS, if it is placed on the same server as a licensed sql server box. Otherwise you must purchase a license.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
Report in SQL