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 |
|
Johnathan
Starting Member
30 Posts |
 Posted - 2011-01-27 : 11:08:55
|
| Hi All,I'm trying to find out the easiest method of allowing people to run reports that I have written in SQL server. I'm currently trying to teach myself how to use Crystal Reports but have found that SQL code can't simply be coped across.Is there a way that I can copy SQL code directly into Crystal and be able to present the data in a way I see fit?Are there any other tools/techniques available that would allow me to run reports easily, from SQL code I have written in SQL Server?All help is appreciated,Thanks,Johnathan |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-27 : 11:13:55
|
| Put the code into stored procedures and base the reports on that.Why not reporting services or access?Mind you crystal reports was a fine product last time I used it (very unlike it's early days).==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Johnathan
Starting Member
30 Posts |
Posted - 2011-01-27 : 11:21:02
|
| How do I go about putting the code into Stored Procdures?Is 'Reporting Services' an add-on for SQL Server? I've had a look around in SQL Server and don't see anything about it.Yeay Crystal Reports seems to be great for creating a style for the report, I'm really just not sure how the SQL code works through it. Any advice on using Crystal would also be more than great. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-28 : 01:40:01
|
| Create procedure my_procasyour codeNow design the report whose datasource is the procedureMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Front End Query