Solved

Group formula produces duplicates

Posted on 2011-09-08
3
252 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
Comment Utility
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
Comment Utility
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
Comment Utility
thank you
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

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 …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now