Skip to main content
Solved

Report Designer - Moving some custom fields - They do not appear in the report

ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14

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?

 

 

Best answer by dsj

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

View original
JL
Did this topic help you find an answer to your question?

7 replies

dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Superhero (Partner)
  • 837 replies
  • Answer
  • August 1, 2024

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

DSJ - https://dsj23.me
ZTC ZTC JGOTA
1 person likes this
  • ZTC ZTC JGOTA
    ZTC ZTC JGOTA
E
Sidekick (Customer)
Forum|alt.badge.img+9
  • Ed22
  • Sidekick (Customer)
  • 134 replies
  • October 11, 2024

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

dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Superhero (Partner)
  • 837 replies
  • October 11, 2024
Ed22 wrote:

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

DSJ - https://dsj23.me
E
1 person likes this
  • E
    Ed22
E
Sidekick (Customer)
Forum|alt.badge.img+9
  • Ed22
  • Sidekick (Customer)
  • 134 replies
  • October 15, 2024

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.

S
1 person likes this
  • S
    Sandali T
S
Do Gooder (Employee)
Forum|alt.badge.img
  • Sandali T
  • Do Gooder (Employee)
  • 2 replies
  • March 17, 2025
Ed22 wrote:

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.

Hi ​@Ed22 ,  have you found a solution for this? 🙂

E
Sidekick (Customer)
Forum|alt.badge.img+9
  • Ed22
  • Sidekick (Customer)
  • 134 replies
  • March 17, 2025

Yes, I solved this, but I have another problem….

 

I want to add new CF in entity AnalysisNorm, which belongs to modul Analysis results - attributes, but it says that in this entity cannot add new CF. So, my question is, exist some superior entity to this entity, in which I will add CF and will be also visible in my aim entity - AnalysisNorm? And If so, how can I find out superior entity of this entity?

 

Thanks

S
Do Gooder (Employee)
Forum|alt.badge.img
  • Sandali T
  • Do Gooder (Employee)
  • 2 replies
  • March 17, 2025
Ed22 wrote:

Yes, I solved this, but I have another problem….

 

I want to add new CF in entity AnalysisNorm, which belongs to modul Analysis results - attributes, but it says that in this entity cannot add new CF. So, my question is, exist some superior entity to this entity, in which I will add CF and will be also visible in my aim entity - AnalysisNorm? And If so, how can I find out superior entity of this entity?

 

Thanks

Hi ​@Ed22 , 

Could you please tell me how you solved this issue? I’d really appreciate it because I’m facing the same problem. I have created a CF (CF_NOTE_TEXT) in the Customer Order Line, but in the report, the value for the note text is empty and not showing.

Regarding your second issue, is your entity a virtual entity? Also, can you check whether ‘OBJKEY’ is available for the respective view? In order to add custom attributes to a view, an 'OBJKEY' must exist.

Smile

 

Thanks

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings