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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Ecxel format error
- Thread starter italy
- Start date
There's no really easy answer to this question without more information. In general, Seagate Info/Crystal Reports writes Crystal Reports best in Crystal Reports format.
If you need to export to a different format such as MS Excel, then you need to specifically design the report so that it exports correctly. The easiest way to do this is to ensure that all fields are contained within guidelines.
Depending on the layout of your report, you may also need to experiment with the various Excel export settings (if you use the extended versions).
If you need to export to a different format such as MS Excel, then you need to specifically design the report so that it exports correctly. The easiest way to do this is to ensure that all fields are contained within guidelines.
Depending on the layout of your report, you may also need to experiment with the various Excel export settings (if you use the extended versions).
The best method I have found is to extended version in a tabular format. When you design the report make sure all collumn heading fileds are the same height and heading fields and detail fields are the same width and line up as close to exactly as possible. If you have some column heading labels that are two lines and some that are one abreviate as much as possible then fix them in excel.
- Status
Similar threads
- Locked
- Question
- Locked
- Question