What's the problem I'm facing?

[rajrev]

Hi guys,

CR8.5, CE 8.5 and SQL Server 2000

Tables:

Tbl1
Discrption
Emp No
Due date
case

Tbl2
Emp No
Due date
col1
col2
I need this Tbl2 because in the report I have to include the col1 field.

Links :

I GAVE THE LINK BETWEEN EMP NO AND DUE DATE.

Parameters:
I'm using 2 parameters due Date range and empno.

the out put of my report is:

Discription Name Case Due date Col1
xxxxxxxxx name1 1 02/01/02 yyyy
2 01/01/03 i
uuuuuuuuu name2 3 08/08/98
4 08/08/98
3 08/08/98
4 08/08/98 sss

There is no group field here, all are in detail.

Case no. 3 and 4 have the same date, which gave me doupicates.
(ie) if there are 3 cases for an emp., and have the same due date, then cases are repeted for 3 times.
I'm trying to find out the solution for this.
If any one have suggestion/solution, please help me out.
I'm not sure about how clearly I explined the problem,need more information please let me know.
waiting for guidence.
Thanks
MK

 

[FVTrainer]

As I understand your problem, both Tbl1 and Tbl2 can have multiple records per Emp No and Due Date. Is that correct? And in Tbl1 your unique identifier is Emp No, Due Date, and Case, while in Tbl2 your unique identifier is Emp No and Due Date. Is that correct? If so, I'll ask one more question: If you have two (or more) records in Tbl2 for a single Emp No and Due Date, is the col1 value different in each of those records?

 

[Madawc]

When fields are duplicate, you can use a [Suppress] formula for the section. Test
{field}=Previous({field})

Madawc Williams
East Anglia, Great Britain