extending an IDO that extends SLReportDataViews

Many of the CSI report IDOs are an extension of IDO SLReportDataViews. This means that the only table in the IDO is table ReportDataView. Is there anyway to add properties to the IDO or output record set without replacing the Custom Load Method Stored Procedure?

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

SLReportDataViews is intended as a template which you extend (not replace) to copy the base IDO Properties and IDO Methods from that IDO. All reports use a Custom Load Method to load their data in place of the SLReportDataViews content. You would create Unbound IDO Properties in your copy of SLReportDataViews that map to the IDO Properties returned by the Custom Load Method. These Unbound IDO Properties are ultimately what you put on your DataView or Form Report to display the report data. See this YouTube video for more details on creating Form Reports: https://youtu.be/0ggvHyOykbs

Legacy Contributor

Tim,

Thank you for your reply. Let me see if I understand what you are saying. I started by extending (not replacing) the CSI IDO called SLPickListReport. That IDO is the primary and only collection for the "Pick List Report Viewer" which produces the Pick List Report from custom load method Rpt_PickListSp. That stored procedure returns some properties of the coitem table including the customer order number which is property ref_num in the IDO and the customer order line which is ref_line_suf in the IDO.

I would like to display some other fields from the coitem table that the stored procedure is not returning in the record set.

(1) I added table coitem as coi to my extended IDO with join text as follows:

[coi].[co_num] = [ref_num] AND [coi].[co_line] = [ref_line_suf]

Is that correct? There is no table to join to coitem because all the existing properties are unbound except for the ReportDataView properties of course.

(2) I added a new property to my extended IDO which is a property that is in table coitem.

(3) I changed the IDO in the "Pick List Report Viewer" from SLPickListReport to the name of my extended IDO so that the new property added to my extended IDO would be exposed.

(4) I added the new property to the "Pick List Report Viewer".

I saved everything and exited out of CSI many times but it isn't working. That is, the new field doe NOT display on the report.

Do you have any idea what I am doing wrong?

Legacy Contributor

Adding a table to the IDO doesn't do anything, because the report is getting the data from the Custom Load Method. You have to modify the Custom Load Method to add the property you want to display. There are three ways to do that:

EXTGEN the stored procedure using the Edit Stored Procedure form (not recommended as stored procedures are going away)
Create an IDO Custom Assembly and use the PostLoadCollection event to add the additional IDO Properties to the result set.
Create an IDO Custom Assembly that provides a new implementation of the Rpt_PickListSp stored procedure logic in .NET code.

How to do the above is a lengthy topic not suitable to a forum posting. So I would refer you again to YouTube to search for "Infor IDO Custom Assembly" and you will find some videos to help you out with that.

Once you have modified the code returning the report data, you have to add unbound IDO Properties in your IDO for any fields you added. Then you have to create a new IDO Method that copies the configuration of the original Rpt_PickListSp IDO Method, and adds the new IDO Properties to the output property list of the new IDO Method.

Then you update the Form Report with the new IDO and new Custom Load Method.

Legacy Contributor

Thank you Tim. I have been modifying Custom Load Methods so that I can have access to more fields in the CSI reports. I was hoping there was an easier way to accomplishment that. Thank you for confirming there is no easy way.

Copyright © 2025 Infor. All rights reserved.