I think you should count the qty fields using count() function and then add the number of stickers.

Hope this is what you want.

Thanks Ashish

These are the fields .....Obviously laid out in a label form

PURCHASE_ORDER.ORDER_QTY
PURCHASE_ORDER.ORDER_DATE
PURCHASE_ORDER.ORDER_NUMBER
PURCHASE_ORDER.C_ADDRESS_5
PURCHASE_ORDER.C_ADDRESS_4
PURCHASE_ORDER.C_ADDRESS_3
PURCHASE_ORDER.C_ADDRESS_2
PURCHASE_ORDER.C_ADDRESS_1
PURCHASE_ORDER.NAME

Obviously we are dealing with the
PURCHASE_ORDER.ORDER_QTY field to apply the formula to.

With the report writer I can click any of the above fields then play with that fields properties like font etc....one of the properties is Conditional formating (do I put a formula in here to replicate it)....

Or

The whole report has menu's like join,sort,filter and criteria, etc that affect the labels also.

where and in what format would I need to use the count() Function.

thanks for your patience in this...

Peter

I started in the main report filter typing

if POP_ITEM.QTY_DESPATCH Count("The value to count.")then

LOL
then what?

Not real good at this but trying

Peter

Actually you want to count the things in sql then you could do it like this:
select count(column_name) from table_name which I guess you must be knowing.
But I have a question, which technologies are you using?

not really sure of the technology
sage accounting is the package with built in report writer that supports SQL statements....Along the lines of Crystal reports....

the field is singular with just the QTY....So not sure if the count statement would work...as i think count would count occurences in a table...

Need a statement that would look at the one qty field (which let say has the number 20 in it,,,,Then repeat that data (label)20 times.....
then move onto the next label......

Peter

These are actually 2 different things:
a) If you need to count the qty then its possible in the SQL using count() function
b) To get the label repeat as per the qty is something different. This should be tackled using front end or some logic in the code.

But since its a package which you have purchased, I presume the best solution is to ask the sage team itself through their customer support and they should be helping you happily.
Which 1 are u using from the below ones?
Sage Line 50
Sage Payroll
Sage 50 Forecasting (also available to download)
ACT! by Sage

line 50 is the package

although they call it sage 2007 now.....

Very little support from sage on this and i have posted the forums looking for a solution...But no luck so far...

I am sure it could be done through a sql statement.
Just someone smarter than me.. :)

Peter

oohhhhhh

B was the option ,,,to get the label to repeat as per QTY....

Prefer it to repeat in the report/labels.

as opposed to print repeating (Eg 1 label/s on report that prints the number of times in the QTY field.

Peter

Looks like u got the answer to you problem.

Looks like u got the answer to you problem.

Looks like u got the answer to you problem.