Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sturner
Starting Member
1 Post |
 Posted - 2011-02-15 : 03:39:43
|
| Hi AllI am fairly new to Reporting Services.I trying to create a table, I am grouping the rows by product and the columns by shift. It works well when I have at least one product per shift. If I don't have any products for a shift then the column does not appear. If I could display a zero value instead of not displaying the column at all I would be in business!!I hope this makes sense.Please help getting frustrated!!CheersSimon |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2011-02-22 : 12:07:30
|
| That's kind of the basis of the Tablix (I am presuming you're referring to what I would call a Matrix). If you want the row or column to appear when there's no data, my suggestion is that you use a straightforward table.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club |
 |
|
|
|
|
|
Grouping in a Tablix using Reports Services