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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting to excel 1
- Thread starter matpj
- Start date
-
1
- #2
goesnowhere
Technical User
If you do not require report header/footer, page header/footer, or group header/footer in excel, then suppress those sections in crystal.
Sometimes the section height causes Excel to add the extra row because of extra space beneath the field in a specific section.
If you are just exporting records to excel, then:
suppress any subsections, if they exist, for the details section in the report.
Try to make the details section smaller or use the fit section option by right clicking on that section.
I have sometimes found this to be a trial and error method to get the right formatting in Excel.
Good luck.
D.
Sometimes the section height causes Excel to add the extra row because of extra space beneath the field in a specific section.
If you are just exporting records to excel, then:
suppress any subsections, if they exist, for the details section in the report.
Try to make the details section smaller or use the fit section option by right clicking on that section.
I have sometimes found this to be a trial and error method to get the right formatting in Excel.
Good luck.
D.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question