Replacing 999 with Unlimitted in a report 1

[ICTECH]

Hi All..

I've created a report for tracking Software Licences our company uses and it works great.. But our Auditors don't want to see "999" for Unlimitted Number of Licences. They want it to print "Unlimitted" in place of the "999".. Can anyone tell me how to super impose this over top of the data in the report on the fly????

Thanks..

 

[lbass]

Is number of licenses a field in your database of number datatype? If so, try:

if {table.numberoflicenses} = 999 then "Unlimited" else
totext({table.numberoflicenses},0,"")

-LB

 

[ICTECH]

Hi lbass...

I just tried your tip and I get an message from Crystal saying "A string is required here"

I'm using Crystal Reports 9 that came with VB.Net.. The field in question is a number datatype.. I'm reading an XML file into the report at runtime as I had trouble getting Crystal to connect to a MySQl database...

 

[lbass]

My formula should work if it is a number. Roll your mouse over the field to verify its datatype--look for the tooltip.

If it is already a string, then use:

if {table.numberoflicenses} = "999" then "Unlimited" else
{table.numberoflicenses}

-LB

 

[ICTECH]

Hi lbass..

It is a String field.. When I make the slight change.. I get "The result of selection formula must be a boolean." Hmm.. got to love things that get you say hmmm....
The formula if not "999" then it would leave the value alone with out changing them?

 

[mdwyer]

= =

 

[lbass]

You are creating the formula in the wrong place. You should be creating it in the formula expert, not the record selection formula. You should then place the formula on your report instead of {table.numberoflicenses}.

-LB

 

[ICTECH]

Hi lbass..

That did it.. I'm still very green around the collare with Cystal Reports.. Thank you very much for the help...