Report Designer question

Hi gurus.
I have the following challenge:
Let's imagine you have a report containing a table/list of salespeople from
one table, their sales per year from another table, and thirdly for instance
the salesperson's zip code.
If a given salesperson have sales in 2003, 2004, 2005 and 2006, he will have
3 rows returned in the list, and the same zip code listed 4 times.
What you do not want for the report is that the total for the zip coded
column is summed up, so it shows 4 times the zip code. You just want the
single zip code returned on the summary line.
Is there an easy way to achieve this?
Kind Regards,
Torkild HagenYou can use First(Fields!fieldname.value) instead of Sum.
daw
"thagen" wrote:
> Hi gurus.
> I have the following challenge:
> Let's imagine you have a report containing a table/list of salespeople from
> one table, their sales per year from another table, and thirdly for instance
> the salesperson's zip code.
> If a given salesperson have sales in 2003, 2004, 2005 and 2006, he will have
> 3 rows returned in the list, and the same zip code listed 4 times.
> What you do not want for the report is that the total for the zip coded
> column is summed up, so it shows 4 times the zip code. You just want the
> single zip code returned on the summary line.
> Is there an easy way to achieve this?
> Kind Regards,
> Torkild Hagen