Max # of columns in Excel Export

I am exporting a report which consists of one simple table. The data is
simply exported to excel.
I am noticing that if I add more than 65 columns to the report (i.e. 66 or
more) then, after exporting to excel, there is a problem re-sizing the
columns in excel. For some reason the data automatically gets a line wrap
character within the cell, and double-clicking the column to resize it
effectively does nothing.
Specifically, my data in column #34 looks like:
"Here is a really really really long sentence." <- there are no carriage
returns
If you double click on the cell the data goes into, in Excel, it ends up
displaying like:
"Here is a" <--
"really really" <-- all of this is in ONE cell in the spreadsheet.
"really long" <--
"sentence" <--
How can I overcome this? Or how can I change how the expansion is handled
in Excel?
Thanks!
DavidMore specifically, if I have more than 65 columns, then the "wrap text"
checkbox is checked (and applied) for all columns/rows in Excel. If I have
65 or less, it is not.
"david boardman" wrote:
> I am exporting a report which consists of one simple table. The data is
> simply exported to excel.
> I am noticing that if I add more than 65 columns to the report (i.e. 66 or
> more) then, after exporting to excel, there is a problem re-sizing the
> columns in excel. For some reason the data automatically gets a line wrap
> character within the cell, and double-clicking the column to resize it
> effectively does nothing.
> Specifically, my data in column #34 looks like:
> "Here is a really really really long sentence." <- there are no carriage
> returns
> If you double click on the cell the data goes into, in Excel, it ends up
> displaying like:
> "Here is a" <--
> "really really" <-- all of this is in ONE cell in the spreadsheet.
> "really long" <--
> "sentence" <--
> How can I overcome this? Or how can I change how the expansion is handled
> in Excel?
> Thanks!
> David|||> Or how can I change how the expansion is handled in Excel?
David,
In Excel, hit Ctrl-A to select the entire active range then go to
Format/Cells.../Alignment and uncheck 'Wrap text'.
HTH,
Chris|||Hi Chris - thanks for the reply. I'm curious as to why this happens with
more than 65 columns of data. It's just an annoying extra little step that
the receivers of this report have to do. If at all possible I'd like to
eliminate it as, like I said, this doesn't happen with less columns of data.
Strange...
Dave
"Chris" wrote:
> > Or how can I change how the expansion is handled in Excel?
> David,
> In Excel, hit Ctrl-A to select the entire active range then go to
> Format/Cells.../Alignment and uncheck 'Wrap text'.
> HTH,
> Chris|||Yeah, I would agree that it is annoying and odd that it only happens when
there are more than 65 columns in the output. Sorry I can't be of more help.
Chris

Matrix Report Exporting

I have a Matrix report in RS and I am trying to export it to Excel. The data in the report is formatted as currency. The data does transfer fine, but the currency values are stored as strings. This will not allow me to perform calculations. I have not had this problem with table reports, only the matrix. Is there any solution that be performed on the server side?

It shouldn't matter if the textbox is part of a matrix or a table. What matters is the definition of your text box: the expression you use to calculate its value, the data base field type you bound the textbox to.

Thank you,

Nico

|||The data type in the database is SQL money, and the field type in SQL RS is currency, but it exports into Excel, not as string as I originally thought, but as a custom data type that will not easily convert into a numeric data type.|||

Try this: in the matrix cell textbox, instead of just using the field value (=Sum(Fields!A.Value)), convert it into a double: =Sum(CDbl(Fields!A.Value)).

-- Robert

Matrix Report Exporting

I have a Matrix report in RS and I am trying to export it to Excel. The data in the report is formatted as currency. The data does transfer fine, but the currency values are stored as strings. This will not allow me to perform calculations. I have not had this problem with table reports, only the matrix. Is there any solution that be performed on the server side?

It shouldn't matter if the textbox is part of a matrix or a table. What matters is the definition of your text box: the expression you use to calculate its value, the data base field type you bound the textbox to.

Thank you,

Nico

|||The data type in the database is SQL money, and the field type in SQL RS is currency, but it exports into Excel, not as string as I originally thought, but as a custom data type that will not easily convert into a numeric data type.|||

Try this: in the matrix cell textbox, instead of just using the field value (=Sum(Fields!A.Value)), convert it into a double: =Sum(CDbl(Fields!A.Value)).

-- Robert