I am using Crystal XI, R2. Which band should it be in? It is in the Detail band, I will move it to the footer.
Another question, Is there any issues with ADO data when building the report with data from one server and copying the report to another server and using the ADO data on that server?

>Two things:
>Make sure you are using Crystal XI, R2
>and
>sounds like the subreport is in the wrong band on the report.
>
>
>>My problem is if there are more than 1 record, both reports prints for each record in the subreport. The 1st dataset is always 1 record, the 2nd dataset (subreport) can be from 1 to 1000 records. There must be a property that says print all data in 1 report and I cannot find it. Please look over the code and see if I can do something different. Thanks in advance.
>>
>>I have been playing with Crystal Reports for the first time. I have the code working to send a report to the printer, no preview. I have 2 reports using ADO recordset:
>>1st report uses 1 dataset for header info
>>2nd report uses the 1st report dataset for its header info and has an embedded 2nd(subreport) report using a different dataset. The code is below: