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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-09-14 : 05:47:18
|
| Hi i have lots of data on my SQL server and have built up a data warehouse but my biggest problem seems to be on how to provide a reporting tool to provide to the end users as i've alot of data and pivotable tables on excel are great but i've also drill downs which can slow things up big time, i'd just like to know what other options there is out their for providing reporting, i've heard of Business objects but it cost allot so am seek a low cost model ? Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-14 : 05:57:07
|
SO what is wrong with SQL server reporting services?Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-09-14 : 06:06:58
|
| I know very little about it, is it a extra add on to SQL, do you have to install it on the SQL server ? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-14 : 07:41:51
|
| it's a separate product.there's a licencing "catch". If you install it on the same server as your sql server then it's free, otherwise it's not.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-09-14 : 08:00:26
|
| Well we have a few SQL servers so we could install it on one of them. Were would be the best place to keep good advice about it or ro get a download and maybe work with a trial version of it... see some examples etc.. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-14 : 08:05:46
|
reporting services come with the sql servers instalation.i guess google is as good as place as any  i haven't done much work with RS so i don't know of any "good" page.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Reporting other than in excel