Oracle Package.Procedure in Report Designer

Thread is closed for posting
3 posts, 1 answers
  1. Yousung
    Yousung avatar
    4 posts
    Member since:
    Dec 2015

    Posted 05 Aug 2016 Link to this post

    Could you please show me how to call Oracle package.procedure in Report Designer (with out parameter)?

    It would be very nice if I can get step by step guide. I couldn't find the proper threads here so far.

    Thank you in advance!


  2. Answer
    Stef avatar
    3610 posts

    Posted 09 Aug 2016 Link to this post

    Hello Yousung,

    If you are using Telerik Reporting Standalone Report Designer, you can use a SqlDataSource component and proper .NET provider suitable for the type of SQL query that will be used.
    For example, please check my colleague's post in How to write an Oracle stored procedure to work with Telerik Reporting Wizard?

    In case there is no suitable .NET provider, you can create custom data access layer in code. The business objects loaded with data can be consumed in reports via Object/EntityDataSource components. To use these in the Standalone Report Designer, you will have to extend the designers configuration - Extending Report Designer. Tutorials are available at the bottom of the linked article.

    If you need further help, please post your questions in Telerik Reporting forums or in a support ticket with selected Telerik Reporting as a product of interest.

    Thank you for your understanding.

    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Yousung
    Yousung avatar
    4 posts
    Member since:
    Dec 2015

    Posted 09 Aug 2016 in reply to Stef Link to this post

    Thank you so much! Actually we solved the problem. It was due to the option of the providers.

    We had to change the Data Source to '<other>' (not Oracle Database)

    and then we chose the ".NET Framework Data Provider for Oracle".

    Thank you. again.

Back to Top