Hi everybody,
[Crystal Reports 8.5]
I created a summary report which has a Microsoft Access 2003 database as the datasource, and have inserted a crosstab in the Report Footer. In the database, there's a table called tblCallLog and another table called tblProblem, which I've added to the report, where tblProblem is Left Outer Joined to tblCallLog on the Problem field (this is a text field).
I've added the field Technician to the Column of the crosstab and the Problem field from tblProblem to the Row. I've added a count of the Problem field from tblCallLog as the Summary.
When I run the report, I expected that, because I Left Joined tblProblem to tblCallLog, that all the records in tblProblem would display in the crosstab and would show a zero for the count if none of the technicians had logged their call by that problem type. However, this is not the case and it's just excluding those problems altogether.
What am I missing to make this work as I intend, as in the example below where 'Hardware' is zero for all three techs (currently 'Hardware' won't show at all on the crosstab)?
Thanks,
beacon
[Crystal Reports 8.5]
I created a summary report which has a Microsoft Access 2003 database as the datasource, and have inserted a crosstab in the Report Footer. In the database, there's a table called tblCallLog and another table called tblProblem, which I've added to the report, where tblProblem is Left Outer Joined to tblCallLog on the Problem field (this is a text field).
I've added the field Technician to the Column of the crosstab and the Problem field from tblProblem to the Row. I've added a count of the Problem field from tblCallLog as the Summary.
When I run the report, I expected that, because I Left Joined tblProblem to tblCallLog, that all the records in tblProblem would display in the crosstab and would show a zero for the count if none of the technicians had logged their call by that problem type. However, this is not the case and it's just excluding those problems altogether.
What am I missing to make this work as I intend, as in the example below where 'Hardware' is zero for all three techs (currently 'Hardware' won't show at all on the crosstab)?
Code:
Tech1 Tech2 Tech3
Password 2 7 4
Software 1 0 3
Hardware 0 0 0
Thanks,
beacon