In exporting a report to Excel I get a blank row between each record. The detail section of the report is as small as it can go, so there isn't any blank space between records on the report when you view it in CR. Is there a setting to get rid of those blank sections in Version 8?
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!
Exporting to Excel 1
- Thread starter LucyColey
- Start date
What I have done in the past is to supress any section you are not really using - page header and footer, report footers, etc. Do you have any sections like that with no or insignificant data in it that you can suppress? Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
-
1
- Thread starter
- #4
What version of CR are you using? I had that problem years ago and when I sat down to troubleshoot the problem, it mysteriously went away. I could never replicate it.
One thing I did when I was desperate, was I exported to Lotus 1-2-3, the old WKS format, and then opened that with Excel. Formatting is gone, but there weren't any spaces. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
One thing I did when I was desperate, was I exported to Lotus 1-2-3, the old WKS format, and then opened that with Excel. Formatting is gone, but there weren't any spaces. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question