Skip to main content

Hello IFS community,

I have a couple of custom fields to move to an RDL, but when I move them to the layout page, they do not print in the PDF.

I am running IFS Report Designer 200.2.0001 and am connected to the database that contains the custom fields.

I refreshed the cache, and the custom fields appear on the IFS page and populate data, which means the custom fields are working correctly.

You can see the custom fields and their location on the report layout (Screenshot below) . I saved the changes, after when I try to run the report, it does not display the email and phone information. I have them highlighted in yellow color (See Screenshot below)

Here is the PDF part. It does not display the data.

Any idea why the custom fields do not display?

 

 

Hi @ZTC ZTC JGOTA

Most common reason with not displaying custom fields in a report is that trying to preview with an old archive key created before adding custom fields.

Order the report from IFS again and use the newly generated archive key to preview the layout from report designer to see is it fetches the values correctly.

 

Cheers!

Damith

Hello, 

 

I have the same problem, I created CF NOTE_TEXT, it displayed in IFS REPORT Designer, but when I click on Online Preview, it showed nothing, how can I solve it? From the response above, what is archive key? When I click on Online Preview, it showed me some “Result Key”, it is this or no? 

 

Thank you for response

Hello, 

 

I have the same problem, I created CF NOTE_TEXT, it displayed in IFS REPORT Designer, but when I click on Online Preview, it showed nothing, how can I solve it? From the response above, what is archive key? When I click on Online Preview, it showed me some “Result Key”, it is this or no? 

 

Thank you for response

 

Hi @Ed22 

what it means is that once you create the custom field, the already generated result keys won’t have any value on it.

What you need to do it, Order the report again in IFS as a normal user would do, preview or print. This will generate a new result key and XML. Now go to the Report Designer and in the online preview, find the latest Result key from the list and preview. 

 

Hope it helps!

Damith

Thanks, it helps, but I have similar problem which is connected with CF. 

I dont know how can I connect Shipment and CustomerOrder views, this is my query: 

 

SELECT s.note_text FROM Shipment s
JOIN CUSTOMER_ORDER c 
ON c.COMPANY= s.COMPANY
WHERE c.order_no = :order_no

 

arguments: order_no

 

I want to display note_text from Shipment view.

But this query retrieves empty string, so I am not sure if it is possible to retrieve note_text from Shipment view in CustomerOrder entity through classical joining or creating CF, because in CF i dont have so much experiences.

Reply


Terms & ConditionsCookie settings