SBO Delivery Labels where user selects number of labels at run time

[Former Member]

Hi

I have requirement on SBO 8.8 to print delivery labels. I know i can use either PLD or Crystal reports to do this. The problem i have is that I need the user to be ble to enter the number of labels they want together with the order number, and for the label format to include the page numbers and page extent, e.g. label 1 of 3, 2 of 3, 3 of 3 etc.. It is the pge numbering that is causing the head-ache...

Any ideas?

Thanks in advance!

Simon

[Former Member · Accepted solution]

Hello Simon,

Well took me a little while to figure this one out!

Create a query from a table that has a recordID that starts at 1 and finishes where ever, hopefully lager then the most lables you would like to print at any one time. I created this from OINV using the field DocEntry and placed it in a view. Use this view in the detail of a Crystal Report with the parameter as follows:

{QueryName.DocEntry} <= {No of Copies} 'Just using these as an example'

Now create your query for your label and place this in as a sub report with the following parameter or what ever it is you are going to use:

[QueryName.DocNum}=?{Invoice Number} 'Just using these as an example'

Make sure you have the parameters correct i.e the first one in the detail and the second one in the Sub

There you go, you should have what you want and be able to have your page number from Special Fields as you wished. A little bit of designing required though....

Let me know how you go!

Kind Regards,

Ben

[Former Member · Accepted solution]

Thanks Ben, Sorry for the delay,

You answer was very helpful and indeed enabled to put a solution in place... Its good to know the tricks!

Best Regards

Simon

[Former Member]

Hi Simon,

What page numbers are you referring to?

Thanks,

Gordon