I have a variable set up called company. The field is 60 positions long and I need the last 8 positions. I have wset up the function as =SubStr(Trim(<Partid>) ,-8 ,8) but all I ever get is the first 8 not the last 8. What am I doing wrong?
The user wants a new report to come out in landscape. How is this done if the report is created automatically everyday at a specific time. Can I design a report in landscape?
Also I have a field called partid and it consists of xxxxxxxxx~xxxxxxxx~yyyyyyyy. This field is not the same size for...
I have a BO report that I need to add the sql statemnt to. The SQL staements when I hit the SQL button is
SELECT
NIM_SHIP_INV_LINE.IMPORT_SHIP_NO,
NIM_SHIP_INV_LINE.PARTID,
NIM_SHIP_INV_LINE.HTS_NUMBER1,
PRODUCT.SYNBOLIZATION_NAME,
PRODUCT.PDESC,
NIM_SHIPMENT.DOB...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.