Hello,

    I am a new Crystal Reports user, and I apologize in advance for my lack of knowledge of the subject. I am using Crystal Reports XI to connect to an ACT! 2011 database for reporting. I have created three reports called 'Pipeline', 'Forecast' & 'Activity'. I am attempting to create a 'primary' report that includes these three reports as subreports.

From my main report I would like to be able to specify the name of the client/company for which the reports are to be run. With my database, this is accomplished with the 'Select Expert' and a field called 'OPPORTUNITY.ASSOCIATED_WITH'. From my main report I have successfully linked this field with each subreport, and when I run the reports the correct data is pulled. However, my report generates a subreport for each record found in the database (ie, if there are 7 matching records, I end up with 21 pages in the report when I should only end up with 3). When these reports are run individually (not as subreports but on their own) I don't get any such duplication.

As I mentioned, my experience with Crystal Reports (and SQL reporting) is quite limited, so I hope this makes some sense. any help or guidance would be greatly appreciated.

Hi John,

  I actually managed to figure this one out with a tip from the SAP forums. By placing the subreports into individual groups and then surpressing the detail and footer sections, I am getting just what I want.

 Thanks for the reply!

 http://forums.sdn.sap.com/thread.jspa?threadID=1981575&tstart=0