Adding dates to a matrix

Hi,
I have a matrix showing transactions between two dates. I want to show those
dates to the users in columns. Let's say the user chose all transactions
between 1/1/03 and 30/10/03. How can I add columns to represent all months in
that period (or days, years, etc.)?
ThanksHi G,
If you don't have any data rows for a certain month/day, then it will not
show up in the matrix grouping. To ensure that certain groups/data values
are always present, you will need an outer join in your dataset query e.g.
in case of months with a simple table that just has 12 rows with one column
and values from 1 to 12.
Using parameters makes it a little bit more complex. You could either
integrate modify the outer join query to select only subsets of the table
(and achieve better performance), or you apply filters on the matrix
groupings in RS.
Details on how to use outer joins are available here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_09_0zqr.asp
http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_09_1h6b.asp
HTH,
Robert
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <G@.discussions.microsoft.com> wrote in message
news:A1D100A0-E235-4EEC-B4F5-22AA80C170B4@.microsoft.com...
> Hi,
> I have a matrix showing transactions between two dates. I want to show
those
> dates to the users in columns. Let's say the user chose all transactions
> between 1/1/03 and 30/10/03. How can I add columns to represent all months
in
> that period (or days, years, etc.)?
> Thanks