USING A FORMULA FOR A PARAMETER 1

[Bestbegood]

I AM USING CR10 and I needed a user's full name but in my table I just have separate fields of First name and last name so I created a formula to put them together. I now need to create parameter that uses the formula called name to get its default values from (so user can have a dropdown list of names to select from) CR10 only lets me uses a value from one of my tables in the report not a formula
is there a way to make the parameter use a formula as a default value?? I appreciate anyone's help.

 

[lbass]

You could populate the list of values with a command that concatenates the names. How you do this depends upon your datasource. For Oracle, you would use a command like:

select "table"."fname"||' '||"table"."lname" "Name"
from "table"

With Access, you would use:

select table.`fname`+' '+table.`lname` as Name
from table

You can then select {command.name} from the dropdown to populate the list. Do not link the command to any of your other tables, and do not reference the command field in your main report.

-LB