Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Assign Unique Record Number? Post Reply Post New Topic
Author Message
althomas
Newbie
Newbie


Joined: 09 Nov 2010
Online Status: Offline
Posts: 36
Quote althomas Replybullet Topic: Assign Unique Record Number?
    Posted: 09 Nov 2010 at 6:10am
Hi,
 I was curious to know if there was any way to assign a unqiue record number to a report that will not be repeated again. (ex. Invoice#, PO#, etc).
My goal was to create a receiving report for our company with a unique "receiver" number assigned everytime we receive some item in to stock. This "receiver number" cannot be repeated for another receipt, so it must be unique.
 
Thank you for all of you help in advance.....
IP IP Logged
quintonmartin
Newbie
Newbie


Joined: 09 Nov 2010
Online Status: Offline
Posts: 2
Quote quintonmartin Replybullet Posted: 09 Nov 2010 at 8:46am
Hi,
  Typically your database would store that value, and your application or database would create it, and the report would just print the value that is stored in the database.  That way, if you need to reprint the invoice, it still has the original number.
 
Perhaps you could use a combination of the date + Time + milliseconds to get a pseudo-unique number.
 
Quinton
IP IP Logged
althomas
Newbie
Newbie


Joined: 09 Nov 2010
Online Status: Offline
Posts: 36
Quote althomas Replybullet Posted: 10 Nov 2010 at 2:18am

Thanks Quinton.

The problem is that our database/application does not have this particular report. i wanted to create this from scratch. But you suggestion of Date+time+millisecond seems to be logical.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.