CR xi - problem display

[campia]

Hi,

I created a main report with a few subreports.
After entered a date period (StartDate and EndDate) I see the right result in my subreports but I have duplicates in my report...instead of having 3 pages I have more than 300 pages.

Can you help me?

 

[Tatertot45]

It could be any number of things. Check the place ment of your subreports and make sure they are place where they should be, like not in the details or group header/footer, where it will execute for every group or every detail entry. Also, check your table linking. I had a report where i linked in an item table to a product code table. I got 132 pages. I wanted a product code descrition, 1 desc for each diff prod code. Instead, becuase of my linking, i got a prod code for each item, so i had a ton of dupes. Although linking my seem logical, and you think you got it right, double check, and run it by the DBA. After that, think abuot suppressing duplicates. If you do that, becareful using running totals, as the totals will accumulate suppressed data.

 

[campia]

excuse-me I placed my subreports in the Details...
why cannot i do it?
where can I put it?

 

[campia]

you are right....i put the subreports in the "report footer" and I do not have duplicates anymore

thanks