Mofify a Production ticket to Print attached PD Ffrom BOM

Hi TSburv Freshman II, do you have any examples I could follow please?

Hello, here is an example setup: Link the BOM file to the production ticket.

First, you need to add the BOM schema in the report designer. Open the Production ticket report in report Designer. In the database schema panel, right-click and select Add schema -> Select the BOM table/scheme and include the necessary fields, such as:
BOM ID
Description
NoteID (These link attachments).

Then join BOM to production order. Create a join between Production Order.BOMID and BOM.BOMID to fetch BOM-related data. For the PDF, you also need to add the File table:
Join BOM.NoteID with File.RefNoteID.
Include fields like FileName or FileURL.

Now embed the PDF in the layout. In the Layout Editor, add a new Subreport or Image field to display the PDF.

Option 1: For embedding, bind the field to File.Data (if your system supports file embedding).

Option 2: Use a hyperlink to the PDF file by binding a text box to File.URL.

Example: Create a text box with the formula [=File.URL] and format it as a clickable link.

SELECT  
    ProductionOrder.OrderNbr,  
    BOM.BOMID,  
    File.FileName,  
    File.URL  
FROM  
    ProductionOrder  
JOIN BOM ON ProductionOrder.BOMID = BOM.BOMID  
JOIN File ON BOM.NoteID = File.RefNoteID  
WHERE  
    ProductionOrder.OrderNbr = @OrderNbr  

An example of a test
1. Create a test production order with an attached BOM.
2. Attach a PDF (like a drawing) to the BOM via the File Attachments section.
3. Run the Production Ticket report to ensure the file reference or PDF appears.

I hope this helps to clarify it more 

Hello TSBurv, Thank you for your Reply,  As I am new to this, please find following current active tables in my BOM.

See available BOM tables

These are the File Elements

with the attached file I wish to Print?

Kind Regards  Andrew

Hi, ​@TSburv . I am also struggling with this. I have the proper joins to the file table, but I cannot get the pdf to display as an image on the report. Can you please provide screenshots of how you got Option 1 to work with file embedding? Thank you!