CSI10 - Adding one field to an existing report

robert-smith

I'm moving to CSI10 from SyteLine 8 - learning mongoose reporting in place of crystal reports.  I have to migrate reports where I'm working with a base report with one or two additional fields from another table.  

I had a discussion with my local consultant on ways to get this done.  I was told that secondary collections are not working as a feature in CSI10 yet for reports.  I was also told that extending a report IDO will not work because the data source in this case is a view, not a table.  

I was told the only way to do this is to copy and re-implement the original report - copy the SP and add the new data field, create a new IDO with duplicate properties and a new load method, and attach all this to a copy of the original report.  I've done this and it appears to work.  It's just ludicrously tedious.  

Is there a better way to do this? 

My report is done and I can do this again, but it's not really efficient for both report creation and updates.  I was expecting to extend and replace the original report with adding a field from a secondary collection.  

Legacy Contributor

In a nutshell, no. But what you were advised is not correct either.

SQL stored procedures are going away as the basis for form-based reports. If you have kept up with Uplifts, most of the report stored procedures have already been replaced (even though they are still in the database).

The correct way to do it is with an IDO Extension Class which is a .NET class library in which you write a function that returns a DataTable containing the data for your report using C# or VB.NET. The DataTable is built up from call(s) to IDO collections whose responses you process and merge into the DataTable. To extend an existing "procedure" you write an IDO Extension Class that executes after the vendor default one is executed, via an event handler in the IDO Extension Class code. You basically take the original request's response and then do queries to extend the response adding the extra columns and data you want to return. No, it is not simple, but that is the direction the Mongoose Framework is going, unless they make any further changes to the reporting process. 

People still writing stored procedures as the basis of a form-based report are doing so at their own peril. You will have to re-write those at some point in the near future.

See the "IDO Development Guide" and "Infor Mongoose Creating and Customizing Reports" documents at support.infor.com.