Exportin to Excel Format Issue

I have a report that contains a matrix control on it. The problem I'm having
is when I export the report to Excel some of the data is not recognized a
numeric and I get the green triangle in the corner of the cell. I believe
this is due to the matrix having some blank columns along with numeric data.
If I fill the report with a 0â's instead of "", the report becomes very hard
to read and is not acceptable by the client.
I have tried setting the textbox visibility to false, but then that also
removes the grid lines around the cell.
I have tried to create a custom format based on the data type and that did
not work.
Does anyone know how I can format just the numeric fields to a number and
the still leave the blank cells as blank when I export to Excel? Thanks...
I have provided a basic example below.
Row1 - 45 - 55 - - 60
Row2 - 50 - - 45 - 45We are having a similiar problem. The only way we have found is the copy,
paste special, values in a new worksheet. You loose all formating in that
case.
"cws" wrote:
> I have a report that contains a matrix control on it. The problem I'm having
> is when I export the report to Excel some of the data is not recognized a
> numeric and I get the green triangle in the corner of the cell. I believe
> this is due to the matrix having some blank columns along with numeric data.
> If I fill the report with a 0â's instead of "", the report becomes very hard
> to read and is not acceptable by the client.
> I have tried setting the textbox visibility to false, but then that also
> removes the grid lines around the cell.
> I have tried to create a custom format based on the data type and that did
> not work.
> Does anyone know how I can format just the numeric fields to a number and
> the still leave the blank cells as blank when I export to Excel? Thanks...
> I have provided a basic example below.
> Row1 - 45 - 55 - - 60
> Row2 - 50 - - 45 - 45
>sql