Hi, is there a solution to add a serial number in report.

I have a report that show me totals of sales sorted by customer name
and I want to add serial number for each apperiance of part subsummery
in my report.


This is example of July's report:

Mount: July
1. Customer ABC 258.00
2. Customer XYZ 205.00
3. Customer QWE 105.00


But in August sales for Customer XYZ is 500.00

Mount: August
1. Customer XYZ 500.00
2. Customer ABC 300.00
3. Customer QWE 200.00

How to add a serial number for report (the number before customer's
name)?


Sorry, but I'm not familiar with English language.
Thanks

<myanakiev [at] gmail.com> wrote in message
news:1187158291.749842.286200 [at] 19g2000hsx.googlegroups.com...
> Hi, is there a solution to add a serial number in report.
>
> I have a report that show me totals of sales sorted by customer name
> and I want to add serial number for each apperiance of part subsummery
> in my report.
>
>
> This is example of July's report:
>
> Mount: July
> 1. Customer ABC 258.00
> 2. Customer XYZ 205.00
> 3. Customer QWE 105.00
>
>
> But in August sales for Customer XYZ is 500.00
>
> Mount: August
> 1. Customer XYZ 500.00
> 2. Customer ABC 300.00
> 3. Customer QWE 200.00
>
> How to add a serial number for report (the number before customer's
> name)?
>
>
> Sorry, but I'm not familiar with English language.
> Thanks
>
you can create sequential serial numbers to uniquely identify records using
the "auto-enter serial" feature under "options" in the field creation
window. if you need to add serial numbers as an after thought use the
"replace field contents" feature.

hope this helps

In article <1187158291.749842.286200 [at] 19g2000hsx.googlegroups.com>,
myanakiev [at] gmail.com wrote:

> Hi, is there a solution to add a serial number in report.
>
> I have a report that show me totals of sales sorted by customer name
> and I want to add serial number for each apperiance of part subsummery
> in my report.
>
>
> This is example of July's report:
>
> Mount: July
> 1. Customer ABC 258.00
> 2. Customer XYZ 205.00
> 3. Customer QWE 105.00
>
>
> But in August sales for Customer XYZ is 500.00
>
> Mount: August
> 1. Customer XYZ 500.00
> 2. Customer ABC 300.00
> 3. Customer QWE 200.00
>
> How to add a serial number for report (the number before customer's
> name)?
>
>
> Sorry, but I'm not familiar with English language.
> Thanks

It really depends on HOW you are obtaining those totals, sorting the
records and structuring the Layout Parts of the report.

Probably the easiest way to achieve this type of report would be to use
a separate "Report" table that uses a Relationship to summarise the
main table's records into one record per Customer Name. That way you
can simply sort by the total and use the Get(CurrentRecordNumber)
function to print the "1.", "2.", "3.", etc. next to each line of the
report.

Another way would be to use a script that loops through all the sorted
records numbering them with each change in Customer Name (ie. in August
all Customer XYZ records are given the number "1."), and then print the
report.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)