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!

Export to Excel - Data in Column getting truncated

Status
Not open for further replies.

donv

Programmer
Jun 11, 2001
18
US
Hi
I am struck with this problem for quite some time.I request help on this.I am runnning a SCR Web report and trying to export it to MS Excel format(Office 2000).The export from the Smart viewer works fine but there is a problem.I am not able to see the complete export of a particular column(with a can expand option) in the excel sheet and the characters get truncated after a certain length.Why is it happening? Is there any workaround ? Please help.

Thanks
Donv
 
Have you tried extending the length of the formulas by clicking and dragging. This should prevent truncation. Good luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top