Making Text Italics with Formula and Changing Order

Are you saying you want the Product Code and Description in Italics when the Product Code = Text?

I can think of 2 ways to do it.

SInce the fields are formulas modify the formulas as below.  Note the addition of HTML codes

ProdCode

if Trim({TRANSDETAILS.ItemAcType})= 'P' then {PRODUCTS.ProductCode} 
ELSE if Trim({TRANSDETAILS.ItemAcType}) = 'J' then {JOBS.JobCode} 
ELSE if Trim({TRANSDETAILS.ItemAcType}) = 'L' then  {LEDGER.AccountNo} 
ELSE if Trim({TRANSDETAILS.ItemAcType}) = 'T' then "<i>Text</i>" else ''

Select allOpen in new window

Right click the field
Click FORMAT FIELD
Click the COMMON TAB
At the bottom set the TEXT INTERPRETAION to HTML

The other way is
Right click the field
Click FORMAT FIELD
CLick the FONT Tab
Click the formula Button to the right of style
Add the formula

if Trim({TRANSDETAILS.ItemAcType}) = 'T' Then
    crItalic
Else
    crRegular

Select allOpen in new window

mlmcc

Great, thanks that helps me for point 1.

Are you able to help me with point 2?

For a set of dates? or for a customer?

I don't think you can since the second group is the line number.

There is one way it could work to sort the OrderLine groups

Add a formula
Name - zOrder

If Trim({TRANSDETAILS.ItemAcType}) = 'T' then
    0
Else
    1

Select allOpen in new window

Put it in the detail area and create a summary (sum) for Group Footer 2
You can then sort the OrderLine groups by it with the Group Sort Expert

Check my example

mlmcc
CustomerOutstandingOrders.rpt

That's it, thanks

Hi mlmcc,

I have just realised that this isn't doing what I need.
It is sorting the 'text' lines altogether (taking them out of each sales order and putting them at the top of the report).

Can this be done within the actual sales order? So make any 'text' lines within the sales order come first?

Thanks.

Yes, thanks.