remove duplicates

Hi I have a report where I am adding up totals of a group in the the report footer my code for this is

IF {BKGCNT.BKESIZ}= 20 and
{BKGCNT.BKETYP}=["DC","DH","FP","HC","HW","OT"]then
numbervar X:=X +{BKGDTL.BTEQTY}

My problem is that BKGDTL.BTEQTY has duplicates which are also added to the equation giving a false total.

I am new to crystal but is there a code I could use to either delete the duplicate or ensure it is not added.

Any help would be great... thankyou in advance.1 thing I can think of is select distinct records. On the toolbar under database select distinct records. That should help eliminate dups.
That is for CR 9

Hope that helps,

GJ|||Thankyou... I did try this but it didn't work unfortunately...
I will just keep trolling the web to see if I can find something..

cheers

Remove Decimal Points

I have the following summary string used in a Group Footer
=Count(Fields!Title.Value) &" Opportunities worth: " &
Format(Sum(Fields!Estimated_Value.Value),"C")
it gives the proper results
7 Opportunities worth $750.60
How can I remove the decimal points from the formatting?How about Format(Sum(Fields!Estimated_Value.Value),"C0")
On Mar 5, 1:28=A0pm, BLAW <brad...@.gmail.com> wrote:
> I have the following summary string used in a Group Footer
> =3DCount(Fields!Title.Value) &" Opportunities worth: " &
> Format(Sum(Fields!Estimated_Value.Value),"C")
> it gives the proper results
> 7 Opportunities worth $750.60
> How can I remove the decimal points from the formatting?|||Thanks! Easy fix. Any help on
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2be09ac8fcf5e49a/5238a4bc8bd90c98#5238a4bc8bd90c98
?

Remove Comma from an integer value

I am using crystal report 8.
I have a data base field called batch_number of type integer.
I am grouping it by batch_number.
In the report group footer i am using the Format Field and setting the
format to (1123) for the batch_number.
When the report is executed ,on the left hand side we get a Group Option which shows value that are in a group.
My problem is that the batch_number always comes with a comma
for example 10,001.In the report i am able to eliminate the comma
by using format filed dialog.
Does any one has idea on how to remove comma ?

Thanks and RegardsIs the problem with the group value? if so this also you can go to format field and make the same to eliminate the comma.|||yes this value i am using to group it.I am able to remove comma in the report footer by format field.
how can i remove comma in the top left area where the group value gets
populated when the report is executed.
How can i use format field for that value?|||i also have the same problem?help me help me

examlpe my code:

"LMB/"&ToText(truncate(tonumber({dsKertasLMB_B.BilMesyuarat}),0),0)&"/"& totext((year({dsKertasLMB_B.Tahun})),0)&"(B)"

the result:
LMB/101/2,007(B)

i need to remove the saparete thousand so that the result like this:LMB/101/2007(B)

tq

Remove "blank" space?

I have a report that contains a table with two rows. Each of these rows
contains a table with a header row, detail row and footer row. When the
report loads, these inner tables expand to 5-20 rows of data. All well and
good. However, sometimes the top inner table has no data to render. But when
the report renders, this space is blank (the height of the row of the outer
table). So there's a big gap of whitespace at the top of the report.
Is there any way to have this space shrink to nothing (or nearly nothing)?
Or at least very small? I can't seem to find any way to make this happen.
Thanks,
Ripleywrite an expression on the visibilty expression
"Ripley" <ripley@.ihatespam.com> wrote in message
news:epyIiUg0GHA.4228@.TK2MSFTNGP06.phx.gbl...
>I have a report that contains a table with two rows. Each of these rows
>contains a table with a header row, detail row and footer row. When the
>report loads, these inner tables expand to 5-20 rows of data. All well and
>good. However, sometimes the top inner table has no data to render. But
>when the report renders, this space is blank (the height of the row of the
>outer table). So there's a big gap of whitespace at the top of the report.
> Is there any way to have this space shrink to nothing (or nearly nothing)?
> Or at least very small? I can't seem to find any way to make this happen.
> Thanks,
> Ripley
>sql