Dynamic datasource selection - Report Studio Report

Settings at the Framework Manager

See the prompt and prompt static value which shows the data source that you have for selection. Name of the parameter should be same as given at FM level.


Thanks
Vishwas

#prompt# macro

We use #prompt(...)# macro function in the FM so that few things can be dynamically decided. But #prompt # works with one value only I mean you get a text box prompt when you run a report using #prompt # macro.
but if you want that user should be able to see multiple values so that he can select one of values rather then typing in the text box prompt.
It will also help developer as there is no chance user making mistake by typing wrong value.
To do this just create any prompt at the report studio level with the same name that you have given to prompt in the #prompt(..)#.
Report studio prompt will override the FM prompt and values you select will be taken as #macro # prompt value only. This way you will be able to do that.

Thanks
Vishwas