SSRS boolean parameter Yes and NO instead of True and False in prompt area

Question

Hi everyone,

I am using SSRS 2008
As i want to have the Yes or No      instead of       True or false in Radio button  Boolean parameter in prompt area.

Can any one please suggest me what i need to do i n order have YES or NO in the Radio button  In Prompt area .

And there is no place where i can write the expression. Please help me.

Thanks in advance to everyone.



Affu
SSRSWORLD

Answer 1

Edit:  I just realized that you are seeking radio button changes instead of a drop-down menu change.  This response is regarding changing the values for a drop-down, not the radio buttons.  If it helps, great... but it's possible that it won't.  Sorry for the confusion.

Create the new Parameter, and set it to Data type: Boolean.  Then in the "Available values:" section, select the "Non-Queried" radio button.  In the available fields, type in "Yes" under label.  You should notice that the corresponding Value sets to "True".  This is good.  In the next line under Label, type "No".  Set its corresponding Value to "False".  Then set your default value if you so desire.

hth...

Edit:  This is written from an SSRS2005 point of view, so it might differ slightly.

Answer 2

Hi Aaron,

Thanks for your suggestion but i need the radio button not the Drop Down.

Anyways thanks. Help is really appreciated. i think so there is no such kind of an option in SSRS 2008 nor in 2005 in radio button not sure.
If anyone know about is help is really appreciated.

Thanks,

Affu,
SSRS World

Answer 3

Indeed, I'm actually getting quite confused at this point.  I'm reading a lesson on boolean parameters in SSRS 2005 here: 

http://msdn.microsoft.com/en-us/library/aa337391(SQL.90).aspx

In the lesson, it indicates that the parameter will be a boolean radio button, but I can't even get that to work. 

Answer 4

Hi Aaron,

Finally i discuss in  the meeting about this issue and change the rek from Radio button to Drop Down option.

Did it by selecting the data type as Text and and available values as YES -->0  NO --> 1 and Default values as 0.

Because it give the values for the 0 Parameter.

Anyways thanks, i dont think so that there is any way to do that. i guess i u find it please let me know i will do the same.

Enjoy the day.

Thanks,

Affu

SSRS WORLD

Answer 5

Hi,

The report parameters are placed in Drop Down box when building your report using Report Designer, other than use Visual Studio to build the custom report, which can customize the parameters with any type of boxes(combox, dropdown list, radio button....) but need a lot of program workload.

Hope this helpful,

thanks,
Jerry

Answer 6

you can use in this way

= Switch( Fields!cosl_PhotoRequired.Value=False,"No",Fields!cosl_PhotoRequired.Value=True,"Yes")