• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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)"
    "Disbursments (Unpaid)"
  • 2
1 Solution
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.

mowitAuthor Commented:

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.
mowitAuthor Commented:
thank you
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now