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!

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

Display summary line if no records are selected?

Status
Not open for further replies.
todder

todder

Programmer
Jul 16, 2001
29
US
I am reporting on an Oracle 8i DB with Crystal reports 8.5. The report requires a line summarizing each days sales. Some days have no sales in the table. How can I display a line showing the date and and zero sales for the day if there are no records with that particular date included in the table?

Thanks for any help you might offer.

 
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Stored Procedure with no Parameters
Replies
1
Views
581
hilfy
hilfy
hg05
  • Locked
  • Question
Crystal report chart display
Replies
0
Views
358
hg05
hg05
petejigsaw
  • Locked
  • Question
Suppress group if it contains both specified detail records
Replies
3
Views
304
lbass
lbass
PremHealth1
  • Locked
  • Question
How do I drill into a report footer summary value to display all detail data?
Replies
5
Views
328
lbass
lbass
socalvelo
  • Locked
  • Question
Mouse Clicks not Working in Sections Area
Replies
2
Views
557
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top