Hi all, hope this is the correct group to ask this.
Does anyone know of any tutorials or help docs which clearly show how to use a SQL Stored Procedure as the data source without a base table?
When creating an IDO it requires a Table name.. but there's no base table for the IDO because all data is coming out of the stored procedure..
If I try to "Fake it out" and put a table in, then I can only see the fields from the table and not the output fields from the stored procedure in Properties.
I've looked at some of the base SyteLine IDOs which do this... but I've been able to replicate.. they somehow use a table called ReportDataView which doesn't appear to be an actual table or view.
Thanks for any help I can get!
Matt