I am building a report using the Matrix for the first time. It's showing duplicate days across the columns and I can't figure how to filter so that a unique day appears.
I have 2 row groups, quality_code and product_name, and 1 column group repair_dt. In the Date column I showing count of serial_id - associated with product_name
I can't test this right now. But I am guessing that you're repair_dt field is DateTime; that is the time portions in 12/15/2010 dates make those dates different; so get rid of the time portions either in your SQL query or in your Group by column expression.
In your SQL you do SELECT ... , convert(varchar(10),repairt_dt,101) as repair_dt ...
OR in your group expression you can do =CDate(Fields!repair_dt!Value).Date()
Marked as answer by RDowdall on Dec 20, 2010 01:06 PM
RDowdall
Member
361 Points
215 Posts
Matrix Date Columns are showing duplicate days
Dec 17, 2010 05:05 PM|LINK
I am building a report using the Matrix for the first time. It's showing duplicate days across the columns and I can't figure how to filter so that a unique day appears.
I have 2 row groups, quality_code and product_name, and 1 column group repair_dt. In the Date column I showing count of serial_id - associated with product_name
this is what I am getting
12/15/2010 12/16/2010 12/17/2010 12/15/2010 12/17/2010
code A
product 1 1 2 0 0 1
can anyone help?
Thanks
FileFoundExc...
Contributor
2633 Points
428 Posts
Re: Matrix Date Columns are showing duplicate days
Dec 17, 2010 09:52 PM|LINK
I can't test this right now. But I am guessing that you're repair_dt field is DateTime; that is the time portions in 12/15/2010 dates make those dates different; so get rid of the time portions either in your SQL query or in your Group by column expression.
In your SQL you do SELECT ... , convert(varchar(10),repairt_dt,101) as repair_dt ...
OR in your group expression you can do =CDate(Fields!repair_dt!Value).Date()
RDowdall
Member
361 Points
215 Posts
Re: Matrix Date Columns are showing duplicate days
Dec 20, 2010 01:07 PM|LINK
That worked. Thanks