How to get Notes & Specs (binary) into reports

I need to develop a report where note and specs from Customer Orders show, in exactly the form seen in "Notations - Order" sub-window in Visual 7.0, with the multiple notes showing in order of creation, with the date the note was written. Infor BI (Synoptix) does not have a pre-canned view/sphere to do this.

Help!

Wichtige Hinweise zur PROFILE Donglelizenzierung.pdf

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

unknown

I used this to create a view in SQL server that shows the binary data so I can use it in crystal reports. This can be modified to use binarys in all the different tables.

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[CUST_LINE_BIN_VIEW]
AS select CUST_ORDER_ID,CUST_ORDER_LINE_NO,TYPE, CONVERT(varchar(8000), CONVERT(binary(8000), BITS)) AS BITS,
BITS_LENGTH
from cust_line_binary
GO

FordUS_ship_req.pdf

unknown

Thanks. I created the view via Synoptix, but when I run the report, the Bits Length and Bits fields show no data. I must be missing something...

unknown

Here's what worked in Synoptix for me:

CREATE VIEW
CO_NOTATION AS
SELECT
CUSTOMER_ORDER.ID AS SO_AAAA_CustomerOrderNum,
CUSTOMER_ORDER.STATUS AS SO_AAA_Status,
CUSTOMER_ORDER.DESIRED_SHIP_DATE AS SO_Date_ShipDate,
CUSTOMER_ORDER.PROMISE_DATE AS SO_Date_PromiseDate,
CUSTOMER_ORDER.LAST_SHIPPED_DATE AS SO_Date_LastShippedDate,
(CAST(CAST(notation.note AS VARBINARY(8000)) AS VARCHAR(8000))) as NOTATION,
NOTATION.CREATE_DATE AS NOTATION_DATE,
NOTATION.OWNER_ID AS NOTATION_C_CO_PO_NUMBER,
NOTATION.TYPE AS NOTATION_OWNER_PROGRAM
FROM
CUSTOMER_ORDER, NOTATION
WHERE
CUSTOMER_ORDER.ID = NOTATION.OWNER_ID AND NOTATION.TYPE = ‘CO’

CREATE VIEW
WO_NOTATION AS
SELECT
WORK_ORDER.BASE_ID AS WO_AAAA_WO Number,
WORK_ORDER.STATUS AS WO_AAA_Status,
WORK_ORDER.DESIRED_WANT_DATE AS WO_WANT_DATE,
WORK_ORDER.CLOSE_DATE AS WO_CLOSE_DATE,
(CAST(CAST(notation.note AS VARBINARY(8000)) AS VARCHAR(8000))) as NOTATION,
NOTATION.CREATE_DATE AS NOTATION_DATE,
NOTATION.OWNER_ID AS NOTATION_WO_NUMBER,
NOTATION.TYPE AS NOTATION_OWNER_PROGRAM
FROM
WORK_ORDER, NOTATION
WHERE
WORK_ORDER.BASE_ID = NOTATION.OWNER_ID

CREATE VIEW WO_SPEC AS
SELECT
(CAST(CAST(WORKORDER_BINARY.BITS AS VARBINARY(8000)) AS VARCHAR(8000))) as WO_SPEC,
WORK_ORDER.BASE_ID AS WO_NO,
WORK_ORDER.STATUS AS WOSTATUS,
WORK_ORDER.CLOSE_DATE AS WO_CLOSED_DATE,
WORK_ORDER.DESIRED_WANT_DATE AS WO_WANT_DATE
FROM
WORK_ORDER, WORKORDER_BINARY
WHERE
WORK_ORDER.BASE_ID = WORKORDER_BINARY.WORKORDER_BASE_ID

Copyright © 2025 Infor. All rights reserved.