Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: XI Question Post Reply Post New Topic
Author Message
jestremera
Newbie
Newbie
Avatar

Joined: 19 Aug 2009
Location: United States
Online Status: Offline
Posts: 1
Quote jestremera Replybullet Topic: XI Question
    Posted: 19 Aug 2009 at 12:25pm
I am new to Crystal Reports; sorry if this sounds like a dumb question. I work in a call center and would like to automate a weekly report showing the amount of calls and related data for each of our clients. The problem is that if we receive no calls from one the clients, they do not appear on the report, and rightly so. There is nothing in the database to show for the client. Is there a way to keep the clientname on the report and show zero's for all of the stats in the report. Thank you in advance for your help.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Aug 2009 at 2:04pm

Depends on your source process.

You can use a left join from one table to another but you have to make sure if you write a select statement that it does not filter out data you want.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.