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 |
|
collinsca
Starting Member
23 Posts |
 Posted - 2007-08-08 : 07:01:26
|
| HiI’m quite new to SQL- I would like to know a bit about reporting services and how it works.Say ive got a table about car sales. I have the ‘emp no’ and the ‘value of individual car’.I would like to produce a report with a row which states the total value of sales per employee per month.And also the year to date. How would the calculation be done?How would the date system work?*I don’t actually need to produce the report- but I want to know how it would be done.Would this best be done in reporting services or SSIS? This data would be required every month.Thanks very much |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-08 : 08:10:48
|
| create a stored procedure that you use for the source of the report._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
collinsca
Starting Member
23 Posts |
Posted - 2007-08-08 : 08:40:30
|
| thanks for replyingcan you please expand a little bit on the process...as mentioned- i dont need to do it- i need to know how it is done.thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-08 : 08:41:48
|
| moving this from new to sql server to reporting services forum.i don't know exact steps to do in RS for this._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
reporting services- how would this be done?