Report problem !

[HadiRezaee]

Hi there,
I have a table with below structure:

ID ---> Number(long) INDEX FIELD(Unique = false)
PID1 ---> Number(long)
PID2 ---> Number(long)
OPERATE ---> Yes/No(boolean)
TOTAL ---> Number(double)

It is a example of:

1, 1, 2, YES, 2000 (Help: ID = 1, PID1 = 1, PID2 = 2, OPERATE = YES, TOTAL = 2000)
1, 2, 1, NO, 2000 (Help: ID = 1, PID1 = 2, PID2 = 1, OPERATE = NO, TOTAL = 2000)

2, 3, 4, NO, 5500 (Help: ID = 2, PID1 = 3, PID2 = 4, OPERATE = NO, TOTAL = 5500)
2, 4, 3, YES, 5500 (Help: ID = 2, PID1 = 4, PID2 = 3, OPERATE = YES, TOTAL = 5500)


That was just a small example of the stored data in database about this table !

Now, i wanna show report like this:

1, 1, 2, YES, 2000
2, 3, 4, NO, 5500

Do you got it ?

I wanna delete the records in my report that has frequency value in ID field !

Please help me !

 

[kenhamady]

I am not sure what a frequency value is, but it looks like you want to eliminate duplicates.

One way is to group by your ID, sort the details so that the one you want to diplay is last, and then hide the details and move the fields to the group footer. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[HadiRezaee]

Hi kenhamady,
Yes, i want to eliminate duplicates ...
I made a group on ID field in ascending order.
And then i moved all fields to group footer,
But i can see the duplicate records, still.
What is the wrong ?

Please help me.

 

[kenhamady]

You should only see one GF for each ID.
Did you hide the details and group header sections? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[HadiRezaee]

Hi kenhamady,
Yes, I hide detail and GH, but i can see duplicate records, still !!!

Please help me

 

[kenhamady]

That doesn't make any sense.

When you group on the ID you should get one group for each ID, and each ID should be listed in the Group Tree on the left of your screen. Are you also seeing the same ID twice in the group tree? What is the data type of the ID field, character or numeric? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[HadiRezaee]

Hi kenhamady,
Thanks alooooooooooooooooooot !!!
You helped me very very much, thank you !
Yes, i had BIG wrong in my report ...
I made again my report and now that wroks very well !!!

Thanks again

 

[Guest_imported]

After design in crystal reports not able to save