Subreport producing multiple results

[timopp]

Hi,

I am having some trouble with my subreport reproducing results in my main report by the number of rows produced in the subreport. So if my subreport has three rows in it, the main report will produce three subreport sections, each with three rows in it. I hope I have explained this well enough

I know this is something really easy, but I have jacked with it all day.

TIA 

Tim

[zh3ntil]

Hi,

It seems your main dataset query generates three rows and you subreport is on detail band. Put subreport on summary band or change main dataset as generating one dummy record if it is not in use.

[timopp]

Thanks.

Could you detail this part?

or change main dataset as generating one dummy record if it is not in use.

Tim

[zh3ntil]

If your main dataset result doesn't fill any field on main report, you can use a query like 'select 1 as field' just to be sure the dataset returns at least a row. Because if your dataset returns no result, your report shows no data section. So, If your main dataset returns a dummy result like that just a row, your detail section runs just one time.