SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to change the boolean parameter value


How to change the boolean parameter value

Author
Message
Arunkumar S P
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1647 Visits: 870
Arum

Hi,
how to change the boolean parameter label?

Thanks & regards

Arun

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


Arunkumar S P
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1647 Visits: 870
arunkumar.sp (10/22/2008)
Arum

Hi,
how to change the boolean parameter label (True,False) ?.
Kindly help me to solve this issue. Thanks in advance.

Thanks & regards

Arun



-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


Siva Gurusamy
Siva Gurusamy
Say Hey Kid
Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)

Group: General Forum Members
Points: 705 Visits: 386
In Available Values sections of that boolean parameter, in the label column enter 'Yes'. In value 'True' would appear by default.
Move to the next row and enter in lable column 'No' and select 'False' in value column.

View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Arunkumar S P
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1647 Visits: 870
Thanks for your suggestion Gurusamy.

I tried this but not working.
I preview yes,no is coming in combo format.
But in deployment (http://localhost/reports/ ) it is coming as true,false in boolean format.
Any SP needs to install?
Pls help me

Thanks,
Arunkumar

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


krayknot
krayknot
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1960 Visits: 534
arunkumar.sp (11/20/2008)
Thanks for your suggestion Gurusamy.

I tried this but not working.
I preview yes,no is coming in combo format.
But in deployment (http://localhost/reports/ ) it is coming as true,false in boolean format.
Any SP needs to install?
Pls help me

Thanks,
Arunkumar

not any special sp is required . just put the case statement on the boolean column and based on the true/false value of that column produce the desired results.

kshitij kumar
kshitij@krayknot.com
www.krayknot.com
Arunkumar S P
Arunkumar S P
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1647 Visits: 870
Hi

Thanks for your suggestion kshitij kumar,sgurusamy. Thanks a lot.

I cleared explain my problem in the attached screenshot.

This is what i done. I'm not getting output.

Pls help me to solve this issue.

Thanks,
Arunkumar

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


Attachments
BooleanParamScreenshot.JPG (30 views, 159.00 KB)
r_achar
r_achar
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 320
Hi,

Here is an alternative to Boolean type.
Use the data type Integer with available values 0 and 1.

Label Value
Open 1
History 0

You can treat 1 as true and 0 as false.

Hope this helps.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search