| Author |
Topic |
|
meef
Posting Yak Master
113 Posts |
 Posted - 2012-08-20 : 12:07:06
|
I have a report here that is supposed to show spending from one year to another. So, for example, you put in a start date of 1/1/11 and an end date of 8/20/12 and it will compare last year to this year month by month. My problem is it's totaling all of 2011 instead of just the first 8 months, as seen below: There are no weird grouping or anything in the report, I'm just grouping the years and another field not shown in the image. As you can see, the numbers for 2011 definitely do not add up to $627,250, that's the the total for the entire year of 2011. How can I make it only total up the months it has in common with the current year (in this example, only months 1-8)? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-20 : 17:16:22
|
| Are you bringing entire years data to matrix or only first 8 months?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
meef
Posting Yak Master
113 Posts |
Posted - 2012-08-21 : 08:19:07
|
| It's bringing everything from the date range, this is probably a case where adding something to the stored procedure will be the best solution but I'm not sure what to add. Right now it's not really limiting on anything other than the date, so if I put in 1/1/11-8/22/12 it's pulling all of it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-21 : 10:50:00
|
| either add filter to bring only 8 months data from procedure or add a filter on matrix to filter out data after 8 months------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
meef
Posting Yak Master
113 Posts |
Posted - 2012-08-21 : 14:22:22
|
| It's not always going to be 8 months though, it's however long the period between the two dates would be. That's what I'm not sure how to do in the SP, take the dates and count how many days between the two and only display that data. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-21 : 15:00:57
|
quote:
Originally posted by meef
It's not always going to be 8 months though, it's however long the period between the two dates would be. That's what I'm not sure how to do in the SP, take the dates and count how many days between the two and only display that data.
is value parameter driven?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
meef
Posting Yak Master
113 Posts |
Posted - 2012-08-21 : 15:45:15
|
| It is. The user can put it whatever start and end date they want when the report is run. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-21 : 15:57:35
|
| ok. then what you can do is to have a hidden parameter to get month details from user input enddate value and use it to filter matrix data------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Issues with totaling in a matrix