Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duisplay of non existing records

Status
Not open for further replies.

SuperTime

Programmer
Dec 21, 2004
183
US
********************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


Please advice.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top