Tips and Tricks: Shipping Label

Print Page | Close Window

Shipping Label

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10751
Printed Date: 03 May 2025 at 8:27pm

Topic: Shipping Label

Posted By: elr738
Subject: Shipping Label
Date Posted: 05 Aug 2010 at 7:01am

I need help with writing a formula. Making a shipping label and I need a formula that will read Box 1 of 5, Box 2 of 5, Box 3 of 5 and so on. Just not sure how this is done.

Any suggestions?

Replies:

Posted By: kevlray
Date Posted: 05 Aug 2010 at 9:28am

If the label is the same size as the page, then you can use the page numbering (special fields). Otherwise, short of having a stored procedure that counts all the 'labels' and passes that to CR, I am not sure.

Posted By: sukhveer
Date Posted: 30 Aug 2010 at 7:29am

Create a RunningTotal (RT1)

select:

Field to summarize -> database_field_box

Type of summary -> count

Evaluate -> for each record

Reset -> Never

----

Create a formula (F1)

Whileprintingrecords;

Stringvar sss;

sss := totext(RT1)+"Of"+totext(Count({database_field_box}));

sss;

---

Now place F1 in the detail section.. you should be good!

Print Page | Close Window