Skip to main content
Question

Call a Procedure from a quick report

  • Sep 29, 2022 9:47 AM UTC
  • 1 reply
  • 137 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)
  • Sep 29, 2022 10:26 AM UTC

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