#1 2018-05-17 11:21:14

kdamir@ping.ba
Member
From: Bosnia and Herzegovina
Registered: 2018-03-29
Website

Executing database stored procedure with parameters

Hi,

There is an issue I have to solve that is related to feature of ReportServer Datasources (i.e. database connectivity) I can't find. Our applications and reports rely on Oracle database context that is set programaticaly in order to segregate data that application user can access.

My question is: Is there any way to execute existing database stored procedure or function with parameters available within ReportServer (like ${_RS_USER_USERNAME}) immediately after establishing of database connection or before executing database query in order to programaticaly setup database context? If you need more elaborate explanation of required feature, please let me know and I will be glad to provide it.

Thanks,
Damir

Offline

Board footer

Powered by FluxBB