Excel Export

[piercey]

Hi List,

I have a report that I'm exporting to Excel. It works perfectly except that when the export encounters one of my subreports it starts a new row in Excel. I can't suppress the subreport because there are shared variables that the main report uses. Hiding the subreport doesn't work either because the new row still appears.

Any ideas how I can get my subreport to run but not cause a new row to appear on my Excel export?

Thanks.

 

[Madawc]

You could make it very small, so that it is in line with an existing report row.

It helps to give your Crystal version.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[piercey]

Thanks.

Unfortunately that didn't work, it seems to put in the equivalent of a carriage return regardless of how big the subreport is. Worth a try though.

I'm on Crystal 9 with Windows XP.

 

[Madawc]

You could also try masking the subreport with a blank text-box. Never tried it, but Excel export takes a lot of notice of blank text boxes.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mwhalen]

Did you find a solution for this at all?