Friday, February 24, 2012

Export to Excel

Hi,

When our report exported to Excel, In the Excel file it is giving some extra columns between the data columns.How to avoid those extra columns.This extra columns causes problems when we want to sort one column it is throwing sort can't be applied on merged columns.

How to avoid the Extra columns.

Thanks in advance

Hello Mahima,

You need to make sure that everything in your report lines up, this includes objects in your report header and footer. When objects do not line up, it creates a column so that the excel export looks like the actual report (or as close as it can).

Hope this helps.

Jarret

|||

Hi Jarret,

Lineup means what we need to check, In my report I have one table in which table header is formed by merging two cells.

|||

Try to merge all the cells in the header. If it was a list you had to make sure that all fields (header and data) are vertically aligned i.e. same Y-Axis location.

Shyam

|||

Hi,

In my report header i have the text boxes those are in the following format:

Date: Parameters!Date.value

Name: parameters!Name.Value

and one image

How to merge these to line up to avoid excel extra columns

Thanks

|||

Hello,

Here's what I would do...

Turn 'Snap to grid' and 'Draw grid' options on. Set the position of the first textbox to have the same left position as one of the columns dividers in the table, then increase/decrease the width of the textbox so that the right edge falls on the same Y coordinate as another one of your column dividers. Do the same for your second textbox and your image.

Jarret

No comments:

Post a Comment