Hide null members  from a set Hierarchy in a matrix object
Hi , I have a Hierarchy that doesn't contain null value. but when I run it in the dataset pane it returns a null values let say I run this query in the managment studio it doesn't contain null select Non Empty {[Measures].[Internet Sales Amount]} on columns, Non Empty {[Geography].[Geography].allmembers} on rows from [Adventure Works] but when I run it on the dataset pane in reporting services ,I see members that contain null the I want to display the query in a matrix object , and displaying totals how can I change the query that I want see the rows that contain, or eliminate those null rows inside the matrix object any help appreciated thank you Thanks
February 8th, 2011 4:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics