Hello,
I have a basic crosstab report created. It involves a large set of data and several of the combinations don't exist.
For example, I have Account IDs as the rows and Locations as the columns. But each location does not use all the accounts. Thus a blank space shows up because there is data in the row for a different location but none for this one.
How do I get the report to say that if there is a null value or blank space, replace it with "N/A"
Highlight the data space, go to properties, and edit the data format. Change the "missing Values" property to fill in as '0' or whatever you want.
Click inside measures and go properties. Under Data, click on Data format. I'm assuming that the format type is text for your report. Inside properties, next to 'Missing Value Characters' type N/A. This should solve your problem