UpdateablePivotGrid toolbar button hide empty rows

May 18, 2010 at 8:10 AM


I am just trying out the UpdateablePivotGrid and it really seems great.Well done guys.

One quick question. How would I hide the empty rows on the updateablepivotgrid on first load ? I have noticed that this can be set once the grid has loaded but I cannot find out how to do this prior to the grid being loaded.  I have noticed that if I manually do this in the mdx by using Non Empty or NonEmpty Cross Join this works on first load but not on further drill downs.

EG I do an MDX statement which has a couple of empty rows in it and load it into the grid. I then have to click the "Hide Empty rows" button to hide the emptys. How can this be done on first load ?



May 31, 2010 at 8:08 AM

Hello Guys,

I worked this out.

I just use the non empty statement prior to using cross join in my mdx.The grid then maintains this in the drill down