Hi,

I have created a stock report which includes a subreport that sums the total distributor free stock. I would like to show this in the details row in the main report. I was going to use shared vars but if i'm correct the data will always show on the line below as the sum in the subreport is run after the details line of the main report.

Is there away to get around this?

Many thanks

Ad

Thanks for the reply Kevlray.

Unfortunately this one does have to be run in the details row as its showing free stock from other customers which uses different parts. I didn't think it was possible to place the sum of a sub report in the details row of the main report :(

Thanks for that. I have now separated the details line which has allowed me to pull in the figures from the sub report :) I have also placed a reset counter which works for all lines except one which is duplicating twice? Why would this occur with a reset counter in place?

Thanks Again