Douplicate issue in detail. Pl. help me out from this problem.

[rajrev]

Two days before I expined this problem, but not in clear.
But I got response. Thanks for the response to that question from FVTrainer and Madawc. As per Madawc's advice I tried to use previous function, but strugleing with where I'm suppose to use that funcation.

Any way I explined the problem in detail. I hope this will give the clear picture.

VIEWS and FIELDS

VIEW1
EmpNo
EmpName
Meetwith
Meet Date

VIEW2
EmpNo
Meet Date
Result

LINKS

V1.EmpNo -- V2.EmpNo
V1.MeetDate -- V2.MeetDate

PARAMETERS

Meet Date: Date Range
EmpNo : All as default

FORMULA
(
{V1.MeetDate}={?MeetDate}
)
and
(
if {?EmpNo} <> &quot;All&quot; then
{V1.EmpNo}={?EmpNo}
else if {?EmpNo} = &quot;All&quot; then
true
)

REPORT OUTPUT
EmpName EmpNo Meet-with Meet-Date Result

AAAAAAA 11111 xxxx 01/01/2001 result1
---blank--------------------yyyy 01/03/1999
BBBBBBBB 22222 zzzz 01/01/2001 result2
---blank--------------------yyyy 01/01/2001
---blank--------------------zzzz 01/01/2001 result2
---blank--------------------yyyy 01/01/2001
CCCCCCC 33333 zzzz 08/08/2000
DDDDDDD 44444 qqqq 01/01/2001 result3

(Note: NO GROUPS, ALL ARE IN DETAIL)
ISSUE
Doublicate values for the EmpName BBBBBBB, because of the meet-date (ie meeting with different person, but on the same date).

suggestion/solution please let me know.

Thanks
MK

 

[synapsevampire]

OK then, how can these be duplicates unless the blanks are really the same Empname just suppressed when duplicated?

Assuming that to be the case, try:

Right click the detail and select format section->Click X 2 next to suppress and place something like:

{v1.EmpName} = previous({v1.EmpName})
and
{v1.Meet-Date} = previous({v1.Meet-Date})

-k

 

[rajrev]

Thanks for your help. it works. I got the second answer from you. First one is the parameter combination formula.
I have another issue, I'll expline it asap.
Thanks,
MK