C
C-Rod
I have a report that allows the user to pick the person they want to
run the report for. If they want to run the report for everyone they
leave the drop down blank.
Underlying report query has the criteria: [Forms]![frmCRP]![cboPA] or
like [Forms]![frmCRP]![cboPA] is null
The report works perfect.
My problem is the chart I have at the top of the report.
The cross tab query seems to work fine. (whether or not I pick a
person it either shows everyone or the right person in the dataset)
but the chart itself is blank when the parameter is null.
Any ideas?????
run the report for. If they want to run the report for everyone they
leave the drop down blank.
Underlying report query has the criteria: [Forms]![frmCRP]![cboPA] or
like [Forms]![frmCRP]![cboPA] is null
The report works perfect.
My problem is the chart I have at the top of the report.
The cross tab query seems to work fine. (whether or not I pick a
person it either shows everyone or the right person in the dataset)
but the chart itself is blank when the parameter is null.
Any ideas?????