Crystal Report -> Adding a sequential #

In the same spirit as Calvin's number 2 item, I have used a single UD
table (UD40 in my case) filled with 10000 records with the number01 field
being 1,2,3,4,5..9999. I then add that to the report Dataset and do the
join in Crystal as he described. The benefit of this over an excel file is
you don't have to worry about the excel file changing or moving. Dunno
just food for thought. It uses a whole UD table. but.. I think 39 more is
enough, depends on your needs.



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Dekker
Sent: Tuesday, August 6, 2013 11:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Crystal Report -> Adding a sequential #





Michelle -

Here are a couple ways I have done this:
1. Add a formula to loop through a counter (moderately tricky if printing
more than a 1 page document)
2. Add external table (eg: excel file) with max copies count and suppress
all page numbers > ProdQty (easiest method I've found)
3. Set number of copies programmatically before calling Crystal Report and
reference the internal variable in CR

Hope This Helps,
Calvin Dekker
[cid:image001.jpg@01CE929A.1B3A2F60
<mailto:image001.jpg%4001CE929A.1B3A2F60> ]<http://www.codabears.com/>
630-672-7688 x1484

*Solutions for Epicor users.

"No trees were harmed during the sending of this message, however a large
number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Michelle Chamberlain
Sent: Monday, August 05, 2013 4:11 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Report -> Adding a sequential #

On our job travelers, we print a separate traveler for each part that
needs to be produced. So if the production qty = 100 pcs, we print 100
travelers so QC can document all of the dimensions. How can I add a
formula to the travelers to let the users know which copy they are looking
at? For example, the first copy would read 1 of 100, the second copy would
show 2 of 100, etc.

Thanks

Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
On our job travelers, we print a separate traveler for each part that needs to be produced. So if the production qty = 100 pcs, we print 100 travelers so QC can document all of the dimensions. How can I add a formula to the travelers to let the users know which copy they are looking at? For example, the first copy would read 1 of 100, the second copy would show 2 of 100, etc.

Thanks

Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817



[Non-text portions of this message have been removed]
Michelle -

Here are a couple ways I have done this:
1. Add a formula to loop through a counter (moderately tricky if printing more than a 1 page document)
2. Add external table (eg: excel file) with max copies count and suppress all page numbers > ProdQty (easiest method I've found)
3. Set number of copies programmatically before calling Crystal Report and reference the internal variable in CR

Hope This Helps,
Calvin Dekker
[cid:image001.jpg@01CE929A.1B3A2F60]<http://www.codabears.com/>
630-672-7688 x1484

*Solutions for Epicor users.

"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Michelle Chamberlain
Sent: Monday, August 05, 2013 4:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report -> Adding a sequential #



On our job travelers, we print a separate traveler for each part that needs to be produced. So if the production qty = 100 pcs, we print 100 travelers so QC can document all of the dimensions. How can I add a formula to the travelers to let the users know which copy they are looking at? For example, the first copy would read 1 of 100, the second copy would show 2 of 100, etc.

Thanks

Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]