Skip to main content
Question

Call a Procedure from a quick report

  • September 29, 2022
  • 1 reply
  • 118 views

Forum|alt.badge.img+9

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

1 reply

Forum|alt.badge.img+17
  • Superhero (Partner)
  • 514 replies
  • September 29, 2022

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 ...).