Anyone know how to mask data while inputting values for a parameter?

[dwilliams]

If I have a table that looks something like this
Key Name
--- ----
-2 <cr.2>
-1 <cr.3>
203 Me
206 Dan
208 Bob

I want to mask out all occurences of a -{Key} so that I can add all valid names to the default value window in the Set Default Values window of creating a parameter.

Can you use a formula to do so:
If {table.Key} >0 Then {table.Name}

Is this even possible?

 

[kenhamady]

What version of CR are you using? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[dwilliams]

I'm using CR v.8....

 

[billie]

Are you going to pass parameter value from VB or directly? If from VB then you can change there only. By using DBList where display value is different and retreive value could be different

 

[kenhamady]

If you are using the parameter 'default values' window to create the list there are no formulas you can use.

However you can also load these values from a a formated text file. This text file could be based on an export of values from another report which can incorporate your criteria.

to see the format of the text file, create a short list in the window manually and save it as a text file. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal