locked
Crystal reports issue RRS feed

  • Question

  • User1407496128 posted

    Hi all,

    I need small alphabets(a,b,c,d ...) instead of numbers(1,2,3,4...) in serial number field, How can i assign. In Visual studio 2008, crystal reports.

    Thanks.

    Monday, August 6, 2012 5:58 AM

Answers

  • User-578610739 posted

    Hi Sampath,

    you can do also like this. This is also readable and maintainable.

    select {?Client}
    
    case "XNORT01" : "North Lambeth"
    case "RLBLH05" : "Hostels"
    case "RLBLE01" : "Ethelred"
    case "RLETT01" : "Lettings First"
    case "RHOLL01" : "Holland Town"
    case "RCEDA01" : "Cedars"
    case "RCROY01" : "CCHA"
    case "RSOUT01" : "Southern"
    case "RGALL05" : "Gallions"
    case "RPENG01" : "Penge"
    case "RSWAN02" : "Swan"
    case "RPEAB01" : "Peabody" 
    
    
    if the value is same in multiple option then do this.
    
    Select {Customer.Country}
        Case "Canada", "Mexico", "USA":
            "North America"
        Default:
            "Outside North America"; 



    Select {Customer.Country}
        Case "Canada", "Mexico", "USA":
            "North America"
        Default:
            "Outside North America";

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 6, 2012 6:50 AM

All replies

  • User1407496128 posted

    I got the sollution using below code

    right click the s.no field, select display string field and wrote the below formula

    if {SubS_No} = 1 then 'a' else if {SubS_No} = 2 then 'b' else if {SubS_No} = 3 then 'c'

    Monday, August 6, 2012 6:43 AM
  • User-578610739 posted

    Hi Sampath,

    you can do also like this. This is also readable and maintainable.

    select {?Client}
    
    case "XNORT01" : "North Lambeth"
    case "RLBLH05" : "Hostels"
    case "RLBLE01" : "Ethelred"
    case "RLETT01" : "Lettings First"
    case "RHOLL01" : "Holland Town"
    case "RCEDA01" : "Cedars"
    case "RCROY01" : "CCHA"
    case "RSOUT01" : "Southern"
    case "RGALL05" : "Gallions"
    case "RPENG01" : "Penge"
    case "RSWAN02" : "Swan"
    case "RPEAB01" : "Peabody" 
    
    
    if the value is same in multiple option then do this.
    
    Select {Customer.Country}
        Case "Canada", "Mexico", "USA":
            "North America"
        Default:
            "Outside North America"; 



    Select {Customer.Country}
        Case "Canada", "Mexico", "USA":
            "North America"
        Default:
            "Outside North America";

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 6, 2012 6:50 AM
  • User1196771204 posted

    hi Ajay2707

    thanks for sharing this valuable information. I appreciate it :)

    Tuesday, August 7, 2012 3:19 AM