Print Page | Close Window

Include Blanks/Nulls?

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10011
Printed Date: 16 May 2024 at 7:37pm


Topic: Include Blanks/Nulls?
Posted By: jo150
Subject: Include Blanks/Nulls?
Date Posted: 13 May 2010 at 4:43am
 have report that shows reference no, summary and notes (example below). For each reference there can be any number of notes, numbered as they are added - 1,2,3 etc. 
 
I have grouped by reference number, Hide GH and detail and then put fields in GF in order to only show me the last note No. and Note Detail entered (thanks to kevlray on here for that tip!)
 
However, I have realised that the report excludes any references that do not yet have a call note added.  Is there anyway to make sure these are included in the report? Or if not how would I report on only those with no notes added?
 
 
Reference     Summary             Note No    Note Detail
12345           Account locked     1              Tried to call customer no reply
                                                 2              Tried again - no reply
 
Thanks Confused



Print Page | Close Window