Skip to main content

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^';

 

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?

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.

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.

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

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.

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?

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

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.

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

Reply


Terms & ConditionsCookie settings