I created a report where A,B,C are cities and e and f are the distance between them respectively.i am getting the report but some of the records are duplicate where the distance in the first line shows correct but the second line is the duplicate record with the distance showing as "-" null.
what could be the possible problem?
City1 City2 City3 Distance 1 Distance2
A B C 10 25
A B C 10 -
B C D 10 100
The above shows my report I dont want the same record now i can check the supress null values here but there are few records where the cities are not present so even those records will be supress I do not want that.