Solved

Group formula produces duplicates

Posted on 2011-09-08
3
255 Views
Last Modified: 2012-05-12
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)"
0
Comment
Question by:mowit
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 36507296
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
 

Author Comment

by:mowit
ID: 36507318
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
 

Author Closing Comment

by:mowit
ID: 36507441
thank you
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Report Error 14 84
Formula to get month and year from date 5 60
C# Crystal Reports 15 88
Crystal Reports 2013 25 34
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question