Print Page | Close Window

XI Question

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7430
Printed Date: 05 May 2024 at 2:43am


Topic: XI Question
Posted By: jestremera
Subject: XI Question
Date 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.


Replies:
Posted By: DBlank
Date 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.


Print Page | Close Window