This is a migrated thread and some comments may be shown as answers.

Oracle Package.Procedure in Report Designer

2 Answers 186 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Yousung
Top achievements
Rank 1
Yousung asked on 05 Aug 2016, 09:00 PM

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 Answers, 1 is accepted

Sort by
0
Accepted
Stef
Telerik team
answered on 09 Aug 2016, 01:12 PM
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.

Regards,
Stef
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
0
Yousung
Top achievements
Rank 1
answered on 09 Aug 2016, 06:39 PM

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.

Tags
Databases and Data Types
Asked by
Yousung
Top achievements
Rank 1
Answers by
Stef
Telerik team
Yousung
Top achievements
Rank 1
Share this question
or