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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reporting Data that is not there 1

Status
Not open for further replies.
JC442

JC442

MIS
Apr 19, 2004
34
US
The Report is grouped by Sales Territory and shows the number of Sales events in each territory. What is the best way to include Territories that do not have any events?
 
Sort by date Sort by votes
You could use a formula for the sales event which is like

if isnull({sales.event}) or {sales.event} = "" then "" else
{sales.event}.

Also if your using 2 tables i.e 1 for sales territory and 1 for sales events then you could use a left outer join on the field.

HTH
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
144
anandm19
anandm19
socalvelo
  • Locked
  • Question
Mouse Clicks not Working in Sections Area
Replies
2
Views
220
socalvelo
socalvelo
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
139
hilfy
hilfy
CodeWell
  • Locked
  • Question
Crystal Reports RPTR Format Not Available
Replies
2
Views
163
CodeWell
CodeWell
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
152
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top