Group formula produces duplicates

I have the following  group formula in a sub report. It produces duplicate records, any ideas ?

if isnull({ListOfProfDetailCost.CostCard1__Voucher1__OpenAmt}) or ({ListOfProfDetailCost.CostCard1__Voucher1__OpenAmt}=0) then
    "Disbursments (Paid)"
else
    "Disbursments (Unpaid)"
mowitAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Wht do you mean it produces duplicate records?

A formula cannot produce duplicates.

The duplicates are produced by the SQL your report uses most likely through an incorrect link between tables.

mlmcc
0
 
mowitAuthor Commented:
mlmcc,

when i remove the group and place a field in the details section 1 record prints but when I add this group i get duplicates. I'm using XML datasource. I verified only one record exists.
0
 
mowitAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.