Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to change the boolean parameter value Expand / Collapse
Author
Message
Posted Wednesday, October 22, 2008 5:51 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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

Post #589723
Posted Wednesday, October 22, 2008 5:55 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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

Post #589729
Posted Thursday, October 23, 2008 7:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, 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
Post #590431
Posted Thursday, November 20, 2008 12:27 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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

Post #605613
Posted Thursday, November 20, 2008 1:44 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 7, 2011 1:41 AM
Points: 346, 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
Post #605629
Posted Thursday, November 20, 2008 2:53 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:59 PM
Points: 229, 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



  Post Attachments 
BooleanParamScreenshot.JPG (21 views, 159.90 KB)
Post #605659
Posted Sunday, November 23, 2008 3:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 9, 2012 11:12 AM
Points: 104, 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.




Post #607229
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse