If I understand you correctly, you have a subreport that returns some piece of data on the same line as other data in your main report. Is that correct?
The Excel exports in Crystal are really picky about formatting. Here's what I would try:
1. In the subreport, suppress all sections except the one that contains your data.
2. In the subreport, go to File>Page Setup and set ALL of the margins to 0.
3. In the main report, turn off the borders on the subreport.
4. In the main report, set the location of the top of the subreport to be the same as other data on the line. If you have column headers, set the location of the left of the subreport to be the same as the column header that it is under.
5. In the main report, set the height of the subreport to be the same as the other data in the section where it's located.
I can't guarantee that this will work, but I believe it will.
-Dell
IP Logged
