Details duplicating

[jedder18]

Crystal V 2008

Have a report

Group 1 = person we pay
Group 2 = rate we pay them
Detail a = item we pay group 1 for, group 1 has code attached to them, by date range
detail B = item we pay group 1 for, with different code

What is happening...Group 2 is showing up 2x for each rate
(the data entry is written over the rate field in application)

Joe Schmo (detail)
12/1/12 thru 12/10/12 @ $30(group 2) ea day
12/11/12 thru 12/31/12 @ $30(group 2) ea day

Joe Schmo (detail)
12/1/12 thru 12/10/12 @ $40(group 2) ea day
12/11/12 thru 12/31/12 @ $40(group 2) ea day


what it should look like is....

Joe Schmo(detail)
12/1/12 thru 12/10/12 @ $30 ea day


Joe Schmo
12/11/12 thru 12/31/12 @ $40 ea day


Any ideas?


Jedder

 

[Madawc]

Suppress detail sections. Use the group header or footer. Show the main details, plus minimum and maximum for date. (These will be summary totals. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.)

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[jedder18]

We have tried the min/max date ranges.
It doesn't work for our scenario due to having to count the number of days, and also use that count for days x rate and having to total number of days in report footer.
So the min/max ranges don't seem to work with the running totals, sum and date diff functions.

Jedder

 

[jedder18]

I took off the fields on report that were summing and totaling and created a field for a min and a max date.
Placed those on report and grouped by the different rates for the date ranges.
Still duplicating the dates with the different rates.
UGH!

Jedder

 

[Madawc]

If you want to separate rates, have that as a second group.

Or consider crosstabs, which can use a Formula Field that combines two data fields.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[jedder18]

group 2 is the rate field

 

[Madawc]

So what's the problem? It should work.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[jedder18]

It shows both rates 2x..
I think because in the data entry the rate is being overwritten with the new rate..it doesn't get entered into a new field.

Jedder

 

[Madawc]

THen use two separate fields

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP