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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub reports question

Status
Not open for further replies.

shannonlp

Technical User
Feb 9, 2006
163
US
Hi,

I’ve got my main report with 2 sub reports. Sub report 1 is placed within report footer A and sub report 2 is place within report footer B.

My question is when I export this to Excel, (MS Excel 97- 2000 – Data Only) an empty row is added between where the main report ends and where the 1st sub report beings. There is also an empty row between the two sub reports.

I’ve looked through all the formatting options for sub reports and can’t find anything that makes a difference.

If anyone knows any tricks on how to deal with empty rows in exported data where the CR contains sub reports I would greatly appreciate it.

Thanks,
Shannon
 
Do you have spaces on the Crystal? Excel might interpret this as an empty row.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
All page footers and report footers are supressed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top