Sub Report duplicate data if i use from and to on my reference number

In the conditions you have to replace ARPayment.RefNbr isbetween @RefNbr (value 1) and @RefNbrTo (Value2)

Or

do two lines where

ARPayment.RefNbr Is Greater than or equal to @RefNbr

ARPayment.RefNbr Is less than or equal to @RefNbrTo

There might be more issues, but that is the first step.

​@bwhite49  i already tried it but now no data is showing on the subreport

i already fix this my problem is its not seperating 
 

Sorry, looking at this again… These conditions are a little over-engineered… Lots of duplication going on

I would delete all of this and start over. You need 

((ARPayment.DocType = @DocType AND

ARPayment.RefNbr = @RefNbr)

OR

(@RefNbr ISNULL AND

ARPayment.ExtRef = @PaymentRef))

You will need to the subreport conditions to be this…

(ARPayment.DocType = @DocType AND

ARPayment.RefNbr = @RefNbr)

You don’t need the @RefNbrTo parameter

You subreport just needs to list all of the invoices under that payment. You don’t need a payment nbr range. 

Your subreport will need these two parameters as well...

@DocType

@RefNbr

​@bwhite49  I need a date range so I can get multiple reports at once there are too many to print one by one. If it’s just a single report, that’s fine.