Can I associate something not in a database field?

[cardimom]

Hi,

Can I add something to my report that is not in the database. I have a computer system number and a user id and I want to add the users full name. I know that I will have to type the users names in. Can I associate the users name with the users id or some other database field so that it will stay with it when refreshed?

Thanks
Cardimom

 

[Ngolem]

You can create parameters that require user input and then place the created fields on the report anywhere you want.

 

[toekneel]

You can also create a formula- an If...then...else would work. Something like this:

StringVar UserName:= UserID;
If UserName="A1" then "Fred" else
If UserName="A2" then "Henry" else
If UserName="A3" then "Mary"

 

[chelseatech]

Another approach is to use a User Function Library. In there you can do anything you can in VB include Windows API calls, retrieve from the Registry, open a txt file, etc.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm