Skip to Content
author's profile photo Former Member
Former Member

Can this be done using Crystal Reports????

Good Day to All,

I have a label request but doesn't use data coming off a database. It pretty simple label at that.

Just a title and unique sequential number and a barcode. That's about it.

- An unique sequential number is required for each request. Need to have the ability to somehow recognize the last sequential number used in-order to print the next sequential number(s).

- Always print two (2) identical labels for each request

- Need to have he ability to print more than one unique sequential number label at a time

- Full ASCII barcode

- The format of the sequential number is:

sequential alpha/number is eight (8) characters long

the FIRST character is ALWAYS an "A"

the SECOND character is ALWAYS "2"

the remaining 6 characters are numeric sequential

start with A2035000 as the 1st sequential number for testing and Go-Live

For example, if 3 unique sequential labels are needed, the following needs to be generated:

A2035000

A2035001

A2035002

Kind Regards,

David Martinez

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2011 at 07:11 PM

    Hi

    At a stretch if you run all your batches Yes, it is possible. Crystal can't remember till what number it has printed the numbers for your batches.

    If you can retain this information in your database end then it is possible otherwise it is not possible.

    Crystal reports will refresh all the report and while refreshing it will generate all formulas and give fresh results based on your batches.

    You can write the following formula to get serial number :

    WhileprintingRecords;

    Numbervar x:=3500;

    x:=x+1;

    'A20'&X;

    Thanks,

    Sastry

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.