Add Stored Procedure as Report Writer Data Source

I prepared a custom parameterized stored procedure which return temp table. However it is not showing in report writer data source. 

  • 0

    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 

  • 0 in reply to Bennie Pienaar

    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

  • 0 in reply to jon.eor

    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