I have watched Q1 video and searched all through the Product Per Sales Demo but can not seem to find any solution.
In my cross tab datasource I am selecting three fields (a, b, c from 3 joined tables). In my cross tab I want field A to be the rows header, field B to be the column header and field C to be the data. Which is fine except not all rows have a match for every column. So for each cell where there is not a match I get Object Reference error. How do I handle this, where there is no data for the intersection of the row and header?
-chabian