I have a report (of employees' days off sick) which has three calculated controls in the report header - two "DLookup"s and and "IIF". These controls work perfectly well on-screen, but when I print the report, all three result in #Error.

The problem is not specific to the employee record, nor is it specific to the PC that I use (our PCs all run Win2000 Professional)

The rest of the data in the report - name, day, date, shift - prints fine.

I can't just ask the user to screen dump, as some versions of this report are several pages long.
Also: I can't use the "Publish with Word" function as the report contains several tick boxes which don't appear when you do this (unless someone knows a way round this)

Very grateful for assistance as always.

Pat.

Make sure that the controls don't rely on data from a form that was open when the report opened, but closed when printed. That can cause the problem.

I've used a custom dialog box to choose which employee to "report" on. When I click OK the report runs on-screen but the dialog box stays on-screen too. I was clicking Cancel to see the report properly and then printing. But if I print BEFORE I cancel, the report is perfect.

Does this mean that when I click Print, the report parameters are actually re-queried? I thought it just printed what's on-screen.

Anyway - thanks! This is great!

Pat.