Replace field number with literal value 1

[sgd3476]

In my report I have a client account number, but am unable to pull in the name from the db. How can I replace the client number with name?

 

[lyanch]

Use a subreport from the customer table linked to the customer Id in the main report. Slow, but it works.

Lisa

 

[sgd3476]

I'm sorry, I was not clear. The database does not contain a field for the client name, just the number.

 

[lyanch]

Then you have to create a formula something like:

if {table.custId} = 1 then "Company One"
else if {table.custId} = 2 then "Company Two"
else if ...
else "Unknown"


Lisa

 

[synapsevampire]

Sounds like a good Case candidate:

CASE Table.AcctNum
WHEN 1 THEN "Fishlips Inc."
WHEN 2 THEN "Some other firm"
...
ELSE "Unknown"
END