I have a report with one subreport. The subreport is passed a variable, @staffid, to match against a table of employees. If there is no matching staffid, I need the parameter value (@staffid) to display in the subreport. I need to check to see if DisplayName exists for the subreport, and if not, show @staffid in textbox that would ordinarily show DisplayName if there were a match.
Below is a screenshot of the report output right now, but I need to fill in the empty user space with the value passed from the main report if there is no match.
I'm looking for an expression to use in the textbox that basically says, =IIF(ISNULL(Field.DisplayName.Value)),@staffid,Field.DisplayName.Value), but I can't find a combination that works.
