numbering items in a report

[mikeder]

Hi,

I have a report that generates a list of project numbers along with a project description. I want to have each project numbered in the report. For example:

1. file 000456 - Bakery shop financials
2. file 000123 - Grocery store financials
3. file 000598 - Department store auditing
4. file 000124 - Restaurant auditing

what i want is to be able to have the numbers 1, 2, 3, 4, 5 etc... next to each item in the report.

Thanks for the help.

 

[Matt Brown]

Ah yes the number a line problem in a report, no it well, heres the solution:

Create a blank text box in the details section of your report next to the line that you want to number.

Right click and select properties.

Enter the following in the control Source:

=+1

In the running Sum property select Over all.

Thats it, you should now get accumalitive numbers next to each row.

Hope this helps

Matt

 

[mikeder]

Thanks!

Works like a charm. Is there a way to put the # symbol and a period after each numbering? i.e.

#1.
#2.
#3.

 

[Matt Brown]

Not sure how to get it to do that the "proper" way but if you create a text box right next to the number box and enter the following in the control source:

="#"

This will produce the hash on every line produced, as for the period after i'm not to sure.
There may be a way of doing this but havn't found it yet.

Matt

 

[Matt Brown]

Ah got it!

Create a text box next door to the number box.
Enter the following in the Control Source

="#" & [NumberBox] & "."

(Dont set it to running sum)

"NumberBox" being the name of your accumalitive box.

Make the accumalitive box (NumberBox) invisible and voila!!

hope this helps

Matt

 

[mikeder]

thanks!

it's Brilliant!!! Thanks for all your help!!