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.

All Forums  Development Tools  Reporting Services Development  How can I display a constant list of dim members

Author  Topic  man5ell Starting Member 1 Post Posted - 2011-07-28 : 12:30:00 How can I display a constant list of dimension members in an SSRS tablix? I have a dimension "mill name" for which I have production data measures in the same cube. The problem I have is that there are some days where a mill does not produce any product and their row is therefore missing in the tablix I have created to summarise the production data per mill. The customer would like to see every mill in the tablix, even if they have not produced anything. This is almost asking for an out-left-join on the cube dimension! How is this possible? Any advice would be greatly received. Thanks in advance Steve