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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bottom Aligning a text object

Status
Not open for further replies.

dev1212

Programmer
May 11, 2010
117
US
Hi,
i have one text object on my report, when i am exporting it to excel it is not appearing as bottom aligned.
Is there any way to make a text object as bottom aligned when exporting to Excel..?
 
Highlight both the item out of alignment and the one in alignment by holding the Shift key down and clicking on the item.
Right-click on the correct item.
Click on Align
Click on Bottoms

 
I tried it already but it is not appearing as bottom aligned after excel export. You can try it on report.. just create two text objects and highlight 'em both and select align-> bottom.. and after exporting to excel you wont see it as bottom aligned.

Appreciate your response but the solution doesnt work.. need another solution

Thanks
 
Make sure they are both formatted the same with the same font size and no borders, ect.

Also make sure the field is wide enough and not wrapping around to a second line or unselect the can grow box.
 
Everything is same for these two text objects.. you can see it if you create two simple text objects and export it to excel..
 
I created 2 simple text objects and exported to Excel and I do not see a problem. What version of Crystal? I used 10 for the test, but I also have 11 and 8.5.

Sometimes it just best to delete the incorrect field and re-add it to the report. Also if it is text, delete the bad one, copy the other and paste, and then edit the text value. Now you know they should be defined the same.
 
i am using 2008 version of crystal and i do see a problem of bottom alignment while exporting to excel. Version 11 may be having the same problem.
 
Well I tried with Crystal 11 and still no problem, so I would do the Copy of the good field and paste and edit the value. Sorry,
since I cannot replicate the problem, that is all I can do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top