Hello,
I am having an issue with the display of a crosstab query in a report.
My query is based on a date renge entered by a manager Where date between[pbegindate], [penddate]. It groups by worker and branch (row headings) and displays the date(s) across the top as a column heading. The value is a Min function that returns a text value or a null - ex. Holiday, Worked, Not Reported, Sick Day, Training with Ralph....
The problem is that the Report is forcing the display of spaces like in the attachment..
Does anyone know how to correct this and show a straight line of values for each worker?
Much Thanks,
KSaab
I am having an issue with the display of a crosstab query in a report.
My query is based on a date renge entered by a manager Where date between[pbegindate], [penddate]. It groups by worker and branch (row headings) and displays the date(s) across the top as a column heading. The value is a Min function that returns a text value or a null - ex. Holiday, Worked, Not Reported, Sick Day, Training with Ralph....
The problem is that the Report is forcing the display of spaces like in the attachment..
Does anyone know how to correct this and show a straight line of values for each worker?
Much Thanks,
KSaab
