Question

Call a Procedure from a quick report

  • 29 September 2022
  • 1 reply
  • 67 views

Userlevel 3
Badge +9

I have created a custom procedure which I wish to call from a quick report. Has anybody got this to work?


1 reply

Userlevel 5
Badge +15

Hi

 

If it is Your own procedure not presented in dictionary cache You have to explicity grant execute to IFSINFO user(grant execute on … to IFSINFO). Of course in quick report invoke with owner name “&AO” or just “IFSAPP” prefix(select …, @AO.procedureName FROM ...).

Reply