Skip to Content
Former Member
Nov 19, 2008 at 07:46 PM

How can I display the first and last name using a paramater as employee ID?



I have a parameter that is called {? Employee ID}. What I want to do is display the first and last name based on the employee ID value entered in {? Employee ID} in the page header of the report. Right now, when I put the following formula in the page header only some pages get the right result while other pages dont....

if table.employeeid = {? Employee ID} then

table.firstname" "table.lastname

It appears as though if the first record in the details section on the beginning of each page happens to be the employee under {? Employee ID} then it prints it correctly, if it isn't I get a null value in the page header.

Anyone have any ideas?