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 |
|
kdford10
Starting Member
7 Posts |
 Posted - 2011-01-29 : 19:37:45
|
| am creating a report. Below is an example of actually what I am trying to accomplish. I know I will have to use a matrix but I'm not sure how I can achieve this layout format. I'm also not sure if I need to implement it in my query somehow or if modify the report layout. 1 Month 2 Month 3 Month 4 Month Total100 123 345 600 600122 145 590 590134 259 259456 456812 1339 2274 2874 2874Thanks, |
|
|
fabri
Starting Member
16 Posts |
Posted - 2011-02-03 : 01:46:54
|
| Hi you will have to do a matrix, in your top row what you can do is create a dataset to get your months or write an expression and then drop this in the top row, this will break your rows up into the relavent months. If there will be no data for a specific month it wont be visable. EG. our year to date reports for this year only show up to February. If its vital to see these months even if there is no data you'll have to do a case statement.Live for nothing or Die for something |
 |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2011-02-25 : 06:48:21
|
| Personally, I'd use a table and do all the calculations in SQL. This is something I did in a previous job and we called it a stairstep report owing to the fact that the finished product looks like a set of steps. The problem with matrices is that they are hard to control.You may need a quite complex bit of SQL code but that's the way i'd go about it, but then I love writing SQL and I'm not a big fan of visual studio.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club |
|
|
|
|
|
|
Report Layout