Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export to Excel - Data Only - Order of field headings wrong in Excel

Status
Not open for further replies.

ekta22

IS-IT--Management
May 3, 2004
359
US
Hi,

Version - Crystal XI

I am having trouble with exporting my Field Headings in Excel 97-2000 - Data Only format. Excel is messing up the order of the Field Headings. My headings are in PH and some have 3 lines of text, some 2 and some just 1.
Excel always puts the fields with 3 lines of text first, followed by 2 and then 1. This is messing up the order in Excel. How can this be fixed? Looked everywhere not finding a solution.

I have a lot of fields on the report so I can't squeeze the field heading in one line. Below is an example

DESCRIPTION----SHORT ----LOCATION------REC
--------------------NAME-----------------------CHANGE
--------------------------------------------------DATE

When these fields are exported to Excel, the order changes to this
REC-------SHORT-------DESCRIPTION----LOCATION
CHANGE---NAME
DATE

Would really appreciate an answer for this problem.

Thanks!

E
 
Make sure the heights of your filed headings are all the same size, in your case make thme all the same height as Rec Change date.

HTH

Gary Parker
MIS Data Analyst
Manchester, England
 
Yea, I have did that. One thing that I probably didn't show correctly above is that I need the labels to be bottom aligned and not top like above. With bottom aligned even if the heading is the same size it does not export it in excel correctly.
 
You should be attaching all sides of the label to guidelines, top/bottom, and left/right--in addition to making all labels the same height. Neighboring labels should be attached to the same guidelines--no spaces in between.

-LB
 
Ensure you are checking the option 'maintain relative object position' when you export
 
I attached all the labels to guidelines(top/bottom, left/right), made them the same height and attached neighboring labels to the same guidelines. But below are the two situations I am having issue with (top alignment does not look nice in crystal but exports fine in excel -

If all the labels are top aligned it exports to excel correctly but it does not look nice on crystal output.
So, I want the labels to be bottom aligned. For that I have to enter 2 hard returns for single line label ("DESCRIPTION"), 1 hard return for two line label("SHORT NAME") in order to make them bottom aligned. But the problem is that when I export the report in excel it displays the square for hard return in the label cell and if I click on the label cell and then some other cell, label disappears and it displays blank space because of the hard return. I have to manually go to each label and remove the hard returns to make it look okay.

How can I get this to work with bottom alignment and the hard return problem in excel?
 
For Excel - Data only, another option is to create a separate header (page header or report header) for each of your rows.

In your case, header row 1 would contain the text "REC" in column 4; header row 2 would contain the text "SHORT" in column 2 and "CHANGE" in column 4; header row 3 would contain the text "DESCRIPTION" in column 1, "NAME" in column 2, and "DATE" in column 4. This will eliminate the issue with the carriage return block.

You should also insert blank text fields in the columns that contain no text in order to insure proper alignment.

Heed lbass's instruction about guidelines as well.

 
Thanks mocgp! That definitely got me closer. Only issue with this solution is that it is only exporting the bottom line(PHc) in excel and not the labels in PHa and PHb. So for 'SHORT NAME' label I only see 'NAME' and for 'REC CHANGE DATE' I see just 'DATE'.

Is it possible to export the entire label? That would be great. If not I think this should be okay for now as well.
 
If you put all of the labels in the same section so that you have three rows of labels in a single section, that might work for you.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top