May 8, 2008 at 5:13 pm
Hello All,
Is there a way to add a new row to matrix in reporting services.
I'm trying to display a row with 0 values if there's no data for that particular month.
This row will display if there's data.
This is how it looks it there data for at least one month.
Volume Processed Jan Feb Mar Apr
Volume Negotiated 134 91 115 100
Volume Pending 0 0 6 0
Volume Not Negotiated 1 0 0 0
But if there's no data for one row it will dispaly this
Volume Processe Jan Feb Mar Apr
Volume Negotiated 110 58 150 160
Volume Pending 0 0 8 0
Thanks in advance
May 9, 2008 at 7:35 am
In your dataset include row for zero values, which will force the row to appear.
orignal dataset
union
Select
'' as volume negotiated,
'' as volume pending,
'' as volume not negotiated
May 13, 2008 at 9:59 am
If I do the union when I add the totals in reporting services then It will add an extra one. Do u know if that posibility exist to add a dymanic row or column that will allow yiu to enter default values.
Thank you for the contribution to this matter.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply