Cross Tab Query Export to Excel with Formatting
Posted on 2007-03-21
I have a cross tab query. I am using the query to allow users to export the data to excel. With the cross tab, I have 'SOX Control' on the vertical access and 'Project' on the horizontal access. With the cross tab, I have instances where 1 = True (selected by check box) and 0 = False.
Two things, is it possible to format the data before it is exported to excel, to have 1 = 'X' and 0 = 'N/A'?
The other thing, can I code the query when exported to have all cells that do not contain values (i.e., 1 or 0) to be greyed out in excel?