Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I create a unique number for each report automatically?

Status
Not open for further replies.

medreports2

Technical User
Dec 23, 2003
16
US
I need to have an "auto number" field to assign a unique number to each report generated. Is this possible?
 
Consider that obtaining technical information on software is largely version dependent, add to that database when using Crystal.

There is a random function (RND) you might use, or you might create a subreport for each report which uses an SP that increments some value in a table.

-k
 
You could generate hash total, say the year multiplied by three added to the day-number multipled by 77.

Madawc Williams
East Anglia, Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top