I prepared a custom parameterized stored procedure which return temp table. However it is not showing in report writer data source.
Hi Jon
To confirm:
All the reports in Evolution has been designed to not accept any foreign /custom created views or any objects. The design principle here is that all views in all of the reports are closed to any externally created DB objects.
That explains why your custom parameterized stored procedure is not available.
Kind Regards
Bennie
Hi Bennie
Happy to hear from you.
Apparently the foreign/custom views can be added as data source in Report Writer. We have successfully implemented the solution in multiple projects. However I'm having doubt with stored procedure and functions and so it is confirmed.
Regards,
Jon
Hi Jon
O I see, you are referring to the Common | Reports | Report Write setup of new custom reports
Sorry, I was referring to any of the standard, existing report layout found across Evolution.
However, I would appreciate if we can setup a meeting to discuss this query a bit further.
Please send me your e-mail address in a new Sage City private chat and I will send you a MS Teams invite
Kind Regards
Bennie
*Community Hub is the new name for Sage City