I am using SQL Server 2000 and CR9. While we do store Invoice Numbers in the DB and we have User Functions to Auto-Generate Numbers, I need this done in CR.
I basically Just want to use the parameter, which is a date, and append an incremented number to the end of it. The Number needs to show up in the Group Header and Group Footer. Here is what I have:
//@Counter
Whileprintingrecords;
numbervar Invoice:= Invoice + 1
AND
//@InvNum
DatePart ("m",{?@StartDate} ) & DatePart ("y",{?@StartDate} ) & DatePart ("yyyy",{?@StartDate} )
& "-" & {@Count}
So it would look like: 112006-1, 112006-2, 112006-3, etc.
The problem I am having is the group footer increments the counter so I end up with 112006-1 in the Group Header and 112006-2 in the group footer. Obviously I need it to be the same number.
Thanks,
Bryan
I basically Just want to use the parameter, which is a date, and append an incremented number to the end of it. The Number needs to show up in the Group Header and Group Footer. Here is what I have:
//@Counter
Whileprintingrecords;
numbervar Invoice:= Invoice + 1
AND
//@InvNum
DatePart ("m",{?@StartDate} ) & DatePart ("y",{?@StartDate} ) & DatePart ("yyyy",{?@StartDate} )
& "-" & {@Count}
So it would look like: 112006-1, 112006-2, 112006-3, etc.
The problem I am having is the group footer increments the counter so I end up with 112006-1 in the Group Header and 112006-2 in the group footer. Obviously I need it to be the same number.
Thanks,
Bryan