Hi,
Start “XMLADataSource” example.
Include “Growth in Customer Base” measure and “Date.Calendar” hierarchy in the query.
The grid will show an empty cell.
When I get the value of the same cell using MDX in Microsoft SQL Server Management studio it returns “NA”.
I like PivotGrid to show “NA” instead of an empty cell. What should I change?
Regards,
Plamen
Hi Plamen,
In august Service Release this issue will be fixed. The SR is planned to be released at 1 of August
RegardsTodor
The proterty can be use in order to show NA in cells
XmlaDataSource ds; ds.UseNativeNonNumericValues = true;
Todor
Hello,
can i do the same but with flatdatasource?
when the measure value is -1 i want to display "N/A" in the pivot grid.
Thanks,