Label - SWA_LD_ItemLabel

Chi Fai Cheung

Hi Philippe,

I try to use the layout 'SWA_LD_ItemLabel' in the 'Item Master Data' screen which should print the information of the item.

But i want also the 'Unit price' which the user select from the choicebox Price List, how can I do this?

Other question is, the item description in SBO is entered with small letters, but need to be shown in capitals on the Coresuite layout. How can i do this in the Layout Designer?

Thanks in advance,
Chi Fai

Philipp Knecht

Hi Chi Fai

In this case i would make a copy of SWA_LD_ItemLabel because:

- It's designed to be used in marketing doc Printorders
- It's datasource (The query) is fixed to marketing docs.

Don't forget to provide also your won query when you copy it.

hth

Chi Fai Cheung

[quote]"Philipp"]
Hi Chi Fai

In this case i would make a copy of SWA_LD_ItemLabel because:

- It's designed to be used in marketing doc Printorders
- It's datasource (The query) is fixed to marketing docs.

Don't forget to provide also your won query when you copy it.

hth


[/quote]
Thanks Philipp, i already did it :).

Other question is the item descriptions in SBO is entered with small letters, but need to be shown in capitals. How can i do this in the Layout Designer?

I have also the following problems is that the customer want to print the label by selecting the items. The label is A4 with 20 labels in 1 page. Now i have create a layout label for 1 item.

How to create it with more then 1 label layout?

Thanks in advance,
Chi Fai

Philipp Knecht

Hi Chi Fai

1. In the Expression write dataBand(xyz).ToUpper() to get the Uppercase characters.
2. You need a field or a entry parameter and then you need to extend your query like:

SELECT U_MyQuantity AS @@RepeatRow FROM ...

Or when using Entry Parameter:

SELECT [%LabelQty] AS @@RepeatRow FROM ...

hth

Chi Fai Cheung

[quote]"Philipp"]
Hi Chi Fai

1. In the Expression write dataBand(xyz).ToUpper() to get the Uppercase characters.
2. You need a field or a entry parameter and then you need to extend your query like:

SELECT U_MyQuantity AS @@RepeatRow FROM ...

Or when using Entry Parameter:

SELECT [%LabelQty] AS @@RepeatRow FROM ...

hth

[/quote]

Thanks Philipp,

I can't find the 'Expression'-field can you tell me where i have to put in?

Thanks

Philipp Knecht

Hi Chi Fai

If it is not in the bindings (Value Property) youll find a similar expresiion in the GenerateScript.

hth

Chi Fai Cheung

[quote]"Philipp"]
Hi Chi Fai

2. You need a field or a entry parameter and then you need to extend your query like:

SELECT U_MyQuantity AS @@RepeatRow FROM ...

Or when using Entry Parameter:

SELECT [%LabelQty] AS @@RepeatRow FROM ...

hth

[/quote]
Hi Philipp,

I still don't understand how to do this, what i have is the following
i have a query and 4 different layouts:

The query:
SELECT T0.[ItemCode], T0.[ItemName], T1.[Price], *
FROM OITM T0 INNER JOIN ITM1 T1 ON T0.ItemCode = T1.ItemCode INNER JOIN OPLN T2 ON T1.PriceList = T2.ListNum
WHERE T0.ItemCode = '[%ItemCode]'

1 parameter for the ItemCode in table OITM

The labels defined in the layout need to be printed on a labelsheet (20 stickers per labelsheet, 2x10). How can I ensure that the single item-label layout is printed multiple times on the labelsheet?

Thanks in advance, Chi Fai


Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/vicichief/scr4.JPG]scr4.JPG[/url]

Philipp Knecht

Hi Chi Fai

It will be best if we solve this via remote support.
Let me know when i can open up an service ticket (121 EUR / hr).

I think one hour should be enough.
Optionally you can buy support packages via our homepage http://www.coresuite.com

hth

Chi Fai Cheung

[quote]"Philipp"]
Hi Chi Fai

It will be best if we solve this via remote support.
Let me know when i can open up an service ticket (121 EUR / hr).

I think one hour should be enough.
Optionally you can buy support packages via our homepage http://www.coresuite.com

hth

[/quote]
Thanks.:(