Value prompts not displaying values using sql generated macro prompt

[andershedin]

Hello guys,

I am working on a sql generated report, and cant get the value prompt to display drop down values. I have tried using both the ?org? in the filters pane and adding a #prompt('org')# in the where clause but it remains empty when clicking the value prompt, any idea?

thanks,

Anders