Wednesday, March 21, 2012

Formatting in Exported Reports

Hi. I have a matrix report that has very dynamic data attached to it,
specifically text that can vary in length from 5 characters to 100 or more.
I found the best solution for rendering was to keep the actual matrix row and
column widths to a minimum and let the matrix grow as required.
The problem I have run into is, when you export to Excel or PDF, it appears
the export uses these minimum column/row widths, and the report does not look
good and requires alot of formatting by hand (including another problem with
column headings I posted).
So my question is, is there any way to work around this or a best practices?
Any help would definitely be appreciated.Actually, this problem is only in Excel.
"comet61" wrote:
> Hi. I have a matrix report that has very dynamic data attached to it,
> specifically text that can vary in length from 5 characters to 100 or more.
> I found the best solution for rendering was to keep the actual matrix row and
> column widths to a minimum and let the matrix grow as required.
> The problem I have run into is, when you export to Excel or PDF, it appears
> the export uses these minimum column/row widths, and the report does not look
> good and requires alot of formatting by hand (including another problem with
> column headings I posted).
> So my question is, is there any way to work around this or a best practices?
> Any help would definitely be appreciated.sql

No comments:

Post a Comment