Formula: highest number
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=9869
Printed Date: 04 May 2025 at 11:23pm
Topic: Formula: highest number
Posted By: jo150
Subject: Formula: highest number
Date Posted: 30 Apr 2010 at 1:51am
|
Hi
This is probably really easy but I am quite new to Crystal.
I 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 can use the select expert to show note 1 or note 2 but what I would actually like the report to do is just to show me the last note for each reference which will obviously be a different note number for each reference depending on how many have been added. How do I do this?
Reference Summary Note No Note Detail
12345 Account locked 1 Tried to call customer no reply
2 Tried again - no reply
I hope this makes sense this is my first time using a forum.
 Thanks
|
Replies:
Posted By: kevlray
Date Posted: 30 Apr 2010 at 4:49am
|
Group by reference number, Hide GH and detail. Put fields in GF.
I hope this helps.
|
Posted By: jo150
Date Posted: 05 May 2010 at 12:58am
|
That's brilliant. Thanks very much
 |
Posted By: jo150
Date Posted: 06 May 2010 at 12:51am
|
Hi again, hopefully someone will answer this without me posting a new topic :-) Grouping the information as posted above works fine but I have just realised that the report now excludes any reference that does not yet have a call note added. How can I make sure any nulls are included in my data?
Thanks
|