Skip to main content
Question

Unable to add Field for Report Designer

  • October 21, 2024
  • 9 replies
  • 144 views

Forum|alt.badge.img+5
  • Sidekick
  • 27 replies

I added a new field to an existing report’s XML via the .rdf file in IFS Developer Studio, yet the Report Designer does not display the new field in the list of available fields.

Xml_Record_Writer_SYS.Add_Element(xml_,'OUR_EXTERNAL_ID', our_external_id);

The documentation for this is very limited.

How does the Report Designer become aware of the available fields, if not via the XML from the rdf?

Edit:

I also added the field to the view and added a comment on the column:

CREATE OR REPLACE VIEW &VIEW AS
SELECT 

       ''                                      OUR_EXTERNAL_ID
FROM  &VIEW_RPV h, &VIEW_RPV d

...

COMMENT ON COLUMN &VIEW..our_external_id
   IS 'FLAGS=A----^DATATYPE=STRING(100)^TITLE=Our Id (external)^ITEM_NAME=iOurExternalId^';

 

9 replies

Forum|alt.badge.img+9
  • Sidekick (Employee)
  • 118 replies
  • October 21, 2024

I did not see a delivery in your text.

Correct me if I’m wrong, but doesn’t Developer Studio edit the source files - that then need to be packaged into a delivery and delivered to a specific IFS Cloud env in order to take effect?


Forum|alt.badge.img+5
  • Author
  • Sidekick
  • 27 replies
  • October 21, 2024

I was told to use the “Deploy to database” option in the context menu of the .rdf file in the Project explorer.

I made several changes already (adding some queries to enrich the data) and these changes worked, so i assumed this should work too.


Forum|alt.badge.img+9
  • Sidekick (Employee)
  • 118 replies
  • October 21, 2024

That is a way to deploy as well, so it has been done.

There’s some info at https://docs.ifs.com/techdocs/Foundation1/050_development/025_operational_reporting/045_report_modeling/100_working_with/ - does that get you forward (especially Step 2)  ?

Sorry, I’m not an expert of Report Designer specifically, hopefully someone who is can pick this up.


Forum|alt.badge.img+5
  • Author
  • Sidekick
  • 27 replies
  • October 21, 2024

Unfortunately, this is only tells me what i already know, but thank you anyways!


Forum|alt.badge.img+19
  • Superhero (Employee)
  • 488 replies
  • October 21, 2024

Report designer uses the XSD as input for the structure and fields. 

If you add the new fields in the report model using developer studio, the schema file will automatically be generated and include your new fields when you save the file.


Forum|alt.badge.img+5
  • Author
  • Sidekick
  • 27 replies
  • October 21, 2024

I added the field to the .report file and saved it, yet the .xsd file does not contain any mention of it.


block Blanket {
   SQL-Statement
   SELECT 
      ...
      NULL            our_external_id

   FROM dual;
   attributes {
      ...
      attribute OurExternalId              Text(200);
   }
}

If i try the “Generate Code” option i get an error:

…\purch\deploy.ini' for project 'XXX' could not be found!

I am unsure how to proceed, as this is all the access i have been given by our Partners, and i can only really deploy the .rdf file.

Is there some documentation i am missing?


SaaAvinak
Do Gooder (Customer)
Forum|alt.badge.img+7
  • 18 replies
  • October 21, 2024

can you check if your new field is visible in schema file (.XSD), if not you need to add it there too


Forum|alt.badge.img+5
  • Author
  • Sidekick
  • 27 replies
  • October 22, 2024

It is not visible and when saving the .report file i get an Error complaining about the missing deploy.ini file.

Is there documentation on what to do with the .xsd file once i manually added these fields?

It doesn’t look like report designer lets me open it directly and i know of no way of uploading the file to the server.


Forum|alt.badge.img+10
  • Hero (Partner)
  • 120 replies
  • October 22, 2024

Does the report in question support custom fields on the entities you need? If so, that’s a lot easier to configure.


Reply


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