Showing Non existing records

[SuperTime]

********************Existing Report***********************
----------------------------------------------------------
Offered Answered
----------------------------------------------------------
Advanced_Partner_Care-4032
02/05/2005
12.15 1 1
13.00 2 1
13.45 1 1

Advanced_Partner_Tech-4033
02/05/2005
07.15 1 1
10.00 0 0
13.45 1 0
02/06/2005
06.00 1 1
11.30 1 1
18.45 1 1
----------------------------------------------------------

**************************My Report***********************

02/05/2005
Advanced_Partner_Care-4032
12.15 1 1
13.00 2 1
13.45 1 1

Advanced_Partner_Tech-4033
07.15 1 1
10.00 0 0
13.45 1 0

02/06/2005
Advanced_Partner_Tech-4033
06.00 1 1
11.30 1 1
18.45 1 1


----------------------------------------------------------

In My report, there is no data in the database for the field

02/06/2005
Advanced_Partner_Care-4032

however I want to display that record for the 6th feb as well in that case alll the values will be zero

Yes, I want to display zeros as the values for that date
so for

Advanced_Partner_Care-4032
02/06/2005
0 0 0

this is what I am trying to achieve

I am using crystal 8.5
database is sybase

Please suggest a solution...

Thanks

 

[Turkbear]

Hi,
Are there joined tables involved?

If so, use a left outer join..If not,then you are asking the report to show you data and dates that do not exist in the datasource.
How can it do that?

 

[usvinyl]

In my experience when this was happening to me I was having too many links. The fewer links the better for my applications. Also make sure that the links are true links not just the ones that Crystal gave you, some of those aren't real links.