Unable to use Postgre SQL Stored Procedure or Select Query using dynamic Parameterized input in the reports

[Bipin]

Hello Community

 I'm currently facing an issue with utilizing PostgreSQL stored procedures and select queries in my reports when attempting to use dynamic parameterized input. Despite various attempts, I haven't been able to achieve the desired outcome.

Specifically, I am encountering challenges when trying to incorporate dynamic parameters into my stored procedures or select queries for report generation. The reports seem to be unable to properly handle dynamic input, and I'm struggling to identify the root cause of the problem.

If anyone has experience or insights into efficiently using dynamic parameterized input with PostgreSQL stored procedures or select queries for reports, I would greatly appreciate your guidance. Additionally, any examples or best practices related to this issue would be invaluable.

 

Thank you in advance for your time and assistance.

[Eyup]

Hello Bipin,

 

Thank you for writing to us. I hope you are doing well.

I am afraid third-party data providers are beyond our support scope, but if you can somehow access the data with a custom database call, you can bind it to the MVC Grid component:
https://demos.telerik.com/aspnet-mvc/grid/remote-data-binding

Or use custom binding logic to send your own parameters to the stored procedure:
https://demos.telerik.com/aspnet-mvc/grid/customajaxbinding

Perhaps external sources like this one might help:
https://stackoverflow.com/questions/11948131/postgresql-writing-dynamic-sql-in-stored-procedure-that-returns-a-result-set

 

Regards,
Eyup
Progress Telerik