Solved

Crystal Reports Only Show Last Record

Posted on 2014-11-26
4
477 Views
Last Modified: 2014-11-28
Hello,
I have a simple report that shows me all my vendors. I group them by vendor id and name. We rate these vendors as unacceptable, satisfactory, good and excellent. When I run the report I get all records for each vendor and the date the rating was entered. I would only like to see the most recent rating. Is there a simple way to do this?

Thank you
0
Comment
Question by:daskas27
4 Comments
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 40466656
Group the report by Vendor and sort the records by rating date (ascending). Suppress the Detail section and GH1. Move the information you want to see to GF1 (Group Footer 1).  
The Group Footer shows information for the last record in the group...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40466949
Agree with Ido.  You could sort in the other direction and put it all in the group header.  Both will run about the same way.

mlmcc
0
 
LVL 35

Expert Comment

by:James0628
ID: 40468724
If you don't need to see the other details, then that's the simplest solution.  FWIW, if you do need to see the other details, then there are other ways that you could handle it.  And if you were dealing with a lot of data, you could use a query to only pull the most recent entry (so that the report wasn't reading everything and suppressing the older records), but if you're looking at a list of vendor ratings, that's probably not an issue.

 James
0
 

Author Closing Comment

by:daskas27
ID: 40470269
Perfect!  Thank you.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question