cross tab not displaying all the rows.

[njahnavi]

I am using crystal report version XI release 2.

I have a cross tab report which is like this

columns
Calendar.claendardates
Calendar.calendardates

Rows
Trailers.TrailerName

Summarized Fields
Max of Total Inv (tells the no.of traiers avaliable that calendardate)
Sum of TotalTrailerCount (tells the no.of trailers needed that particular day)

THe report is working fine.
IT is showing all the trailer types we have in Master.TrailerName.
However if i put some condition in TotalTrailerCount which makes the some of the rows not ot visible.

If i remeove the conditon then i can see those truck rows.

the issue is hwo to make the cross tab to show the empty rows???

I hope i have given enough info if not please ask me if you need more information.

Thanks in advance

 

[lbass]

If you can use a command as your datasource, write a query like this:

select Calendar.calendardates, Trailers.TrailerName, Trailers.TrailerDate
From Calendar left outer join Trailers on
Calendar.calendardates = Trailers.TrailerDate and
Trailers.TrailerName = 'ABC'

...where you are adding the criteria as part of the from clause instead of the where clause--this will maintain the left outer join even with selection criteria on the right hand table.

-LB

 

[njahnavi]

This is a subreport and i will be passing the conditions from the main report.

Since the report is called by vb.net we have to use the vb.net datasource .