I have a SSRS report which is based on an SSAS Cube. In the Cube the formating of numeric fields that NULL values are properly shown as NULL values. In the Cube Browser and Excel this is shown correctly. However when I design the report already the query against SSAS shows these fields as "0" instead of NULL. Is there a way to fix this or is this a bug ?

Hi Ernest, By default, the null values should show blank in the report cells. So, following these suggestions to troubleshoot this issue: 1. Does the report cube dataset show null or 0 or blank for these "null" values? If it is 0, it should be caused because your mdx string with some format expression for them. 2. If it is (null), but shows 0 on the report data region, it might be caused because you set the numeric field Format property. please let us know more details (i.e. version info of ssrs) if the above suggestion does not help. thanks, Jerry

Hello Jerry, the value is in the database NULL, when I go in VS on the cube browser the value is displayed as a blank cell. When I go into the VS Report designer, connect to the cube and let the query run within the designer (datasets) it already shows the values as "0". I run against SSRS2008 R2 with CU3 and use VS2008 (9.0.30729.4462 QFE) The MDX created by the designer looks like this SELECT NON EMPTY { [Measures].[Intrinsic Value - USD, [Measures].[Clean Carry Value - USD] } ON COLUMNS, NON EMPTY { ([Date_Report Date].[Report Date].[Report Date].ALLMEMBERS * [Cat_InstrumentID].[SecurityID].[SecurityID].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( null : STRTOMEMBER(@ToDateReportDateReportDate, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CatInstrumentIDSecurityID, CONSTRAINED) ) ON COLUMNS FROM [Positions])) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS I took out some information, but I think the MDX still should give enough information in case some syntax would cause this behaviour. If I run this MDX in QA also get 0 where there should be NULL values. The measure is in the database defined as money and in the cube it was changed to double (inherited) and the formating string is #.