sql server business intelligence development studio demo

You can use an expression for color property of row.

It would still be nice to know how to have alternate row shading in the matrix.Thanks

If you know how I can shade alternate lines in a matrix that would be a great help.Īlternate shading in rows for the matrix.Thanks for your assistance because I have the information like I need it in table format and alternate rows are shaded. I'm trying to put the information in a table because I know how to do alternating shaded lines in a table but not in a matrix. I want the shading because the actual report is thousands of lines and hard to read without alternate shaded lines. I have the info in a matrix, but I don't know how to get alternating shading on the information for every other line. If you want to generate this in BIDS add a matrix container with row group as customer and column group as year. SELECT Customer,MAX(CASE WHEN Year=2007 THEN Shipments ELSE NULL END) AS Shipment2007,MAX(CASE WHEN Year=2007 THEN Revenue ELSE NULL END) AS Revenue2007,MAX(CASE WHEN Year=2008 THEN Shipments ELSE NULL END) AS Shipment2008,MAX(CASE WHEN Year=2008 THEN Revenue ELSE NULL END) AS Revenue2008,MAX(CASE WHEN Year=2009 THEN Shipments ELSE NULL END) AS Shipment2009,MAX(CASE WHEN Year=2009 THEN Revenue ELSE NULL END) AS Revenue2009FROM tableGROUP BY Customer I'm trying to format my results in a table in BIDS but can't figure out how to do it. All Forumsīusiness Intelligence Development Studio Table We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.

Sql server business intelligence development studio demo