Report is Repeating itself

[lgmin]

I have created a report in Crystal Reports that contains 20 subreports. The subreports repeat themselves but the report header does not. How do I get the subreports to stop repeating themselves. It happens for any parameter selection except for the one I developed it under.

llgmin

 

[synapsevampire]

Subreports never repeat.

What you are probably experiencing is that the subreports are returning more than one row, which means that you need to learn how the database works.

Consult with your dba.

-k

 

[lbass]

I think this could be an issue of where you have placed the subreport, so if you want further help, you should supply information about your main report group structure and where you have placed the subreport.

-LB

 

[lgmin]

I have already reviewed the data in the database for duplicate information or hits, and there are none. It runs through all 20 subreports, and then repeats them with the exact same information. I have one parameter for the identifier, and 20 different pieces of information that I am trying to bring in. I can isolate the subreports and it works fine, but when I bring them together is when they repeat.

For the report layout, I have all the subreports in their own Details section, ie. Details a, Details, b, details c...details u. There is a report and page header and footer. Any ideas would be greatly appreciated.

Thanks.

 

[lbass]

Try placing the subreports in separate report header or report footer sections. If you want to use the main reports page header and page footer sections, then create a formula like the following that includes all main report records:

whilereadingrecords;
1

Insert a group on this and then insert additional group header sections a,b,c,d,etc. and place one subreport in each. You should then get only one instance of each subreport, with page headers and footers available on each page.

-LB

 

[lgmin]

I moved the subreports to the footer section and that solved my problem. My page headers and footers seem ok so I didn't need to create the formula. Thanks a million!!!

llg