Hi all,
I am developing some custom reports based on Infor SQL stored procedures. I have created an IDO and added the SP as a method and everything is working fine.
What I want to do is add a derived field to the IDO to use a SQL function to display a nicely formatted address. I added a dervied value with a SQL call that points to my "CustNum" unbound property. However, when I run the report it does not populate.
I have done this with other IDOs, but with bound properties. Is it not supported with unbound properties? Any suggestions on a "best practice" for these types of customizations? Usually we would just copy the SQL stored procedure and name it something custom to our company and leave it at that. But we are trying to move to having mongoose handle all these types of customizations.
Thanks!
Ryan