Hi All, been stuck with this issue for a few days now and i'm hoping someone can help me.
I have the following item which is used as a prompt filter for a Query Item. The properties of the Query Item is set to: Prompt Type, Select with Search.
#promptmany('P_GroupType','[Shared Groups].[Group Type Desc]')#
The problem I have is that when i expose the package to Query Studio and drag an item from the Query Subject with the prompt filter the prompt type seems to revert to the one which I can only provide a value(s) (exact values only! :(), rather than 'Select with Search' I so dearly want. Aside from the incorrect Prompt Type, the solution works well.
Any advise would be appreciated. I have tried a few things to no avail. Can go into more detail as required.
Thanks!
Bump. Any idea?
Thanks.