Checkbox prompt value in dataitem makes it Single select

[sumesh2429]

Hi ,

When i am taking the parameter values passed by my check box prompt in a data item which is displayed in the Report page list , the Check Box automatically becomes single select Radio button. Do i need to change some settings here to display the check box as it is with Multiselect option ?

Thanks

[pricter]

Have set to YES the multiselect property of the prompt?

[sumesh2429]

yeah. I have done it. And it is Multiselect when we dont take the data item in the report page. As soon as the data item is pulled on to the report page the check box becomes a radio button

[pricter]

How do you use the parameter of the prompt
For example do you use = or in?
Does this data item has any relationship with the parameter of the prompt?
Is it both used in the same query?

[sumesh2429]

I am using the Parameter in a dataitem only and not in any filters hence there is no = or IN operator used anywhere.
My dataitem just contains ?Par_Val? . When this dataitem is pulled in report page , the checkbox becomes radio button automatically . I am not sure why this is happening

[HalfBloodPrince]

It is because you have not used any filter with prompt. If  you want multiple values from the prompt selection then you have to use In operator in filter  [data item] in ?parameter?. Add this kind of filter and make it optional. Try this

[pricter]

I am using the Parameter in a dataitem only and not in any filters hence there is no = or IN operator used anywhere.
My dataitem just contains ?Par_Val? . When this dataitem is pulled in report page , the checkbox becomes radio button automatically . I am not sure why this is happening

In my opinion when you a parameter in a data item it is better to use a macro
#prompt(...)# for single option
#promptmany(..)# for multiple

Check this for details.

Why do you use the parameter in the data item?

[sumesh2429]

Hi Pricter ,

Adding a dummy parameter like ?Par_Val? in ?Par_Val? did the trick . Now its showing up as multiselect prompt only :)