Skip to main content
Question

zip code field not appearing in report designer

  • August 27, 2024
  • 1 reply
  • 62 views
G
Do Gooder (Customer)
Forum|alt.badge.img+2

I want to add a new field named zip_code in the IFS Report Designer. To do this, I have already added a function and XML in the RPI file. I tested the function and its parameters in SQL, and the zip_code result was returned correctly. However, after saving the RPI file, the zip_code field still does not appear in the IFS Report Designer.

I have saved the changes, and there were no error indications. At this stage, I also downloaded the schema in IFS CRP and tried to add it in the IFS Report Designer, but there is no layout available to display the zip_code.

Did I miss a step that is causing the zip_code field not to appear when I try to add it? 

1 reply

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Marcel.Ausan
  • Ultimate Hero (Partner)
  • 1306 replies
  • August 27, 2024

@gexplore what report are you trying to modify and add the zip_code to it?

Normally this can be achieved in 2 ways:

  1. Configuration:
    1. Create custom field/attribute on the entity that is connected to the report → make sure to check the ‘enabled on reports’ checkbox.
    2. after publishing the custom field it should be available in the the report designer
  2. MOD
    1. edit the %RPI package and add the logic to fetch the extra field (cursor)
    2. edit the %RPI to add the new field to the XML
    3. edit the rdl schema of the report and add the field in the schema structure
    4. the field should be visible in Report Designer

For all the work I did until now in this area I was always able to do it via Custom Fields / Attributes as it’s by far the easiest way to do it and maintain the solution long term.

https://www.linkedin.com/in/marcelausan/


Terms & ConditionsCookie settingsAccessibility statement