May 3, 2011 at 11:11 pm
In Matrix report I want to Display all month Names in row group
i write Expression as =MonthName(Month(Fields!SchedulteDate.Value)) it diplays the record only for Available months..
please give ideas to rectity this problem...
thanks in advance
May 4, 2011 at 12:38 am
This is a bit of a pain, I remember they've done (something) in 2008 R2 that pre-fills all the month names, I can't for the life of me remember what though.
One messy way I deal with it is doing a UNION with a bunch of NULL records that have a complete set of months in it.
May 4, 2011 at 12:48 am
AM not Able to modify SP that's my Problem
May 4, 2011 at 1:14 am
Then instead of making a matrix, make 12 column groups, one for each month and with a filter.
May 4, 2011 at 5:52 am
If you can't modify the SP then you can try this approach.
1. Create a table in your db with the correct column names and data definitions to receive data from your stored procedure.
2. Create a date table in your db. Google date dimension or date script and I am sure you will find several useful scripts.
3. In the dataset for your report use this code (in Text mode, it is easier) for your dataset:
INSERT TableNameYouBuiltInStep1
EXEC YourStoredProcedureName
SELECT appropriate field names here
FROM DateTableNameYouBuiltInStep2
LEFT JOIN TableNameYouBuiltInStep1
ON AppropriateJoinHere
Obviously I have simplified the SELECT quite a bit, but hopefully you get the idea. If you don't want to build a Date table, you could always UNION with the Months predefined with NULL values as mentioned in one of the other posts.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply