Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Beginning and ending records

Status
Not open for further replies.
keo216

keo216

Technical User
Nov 26, 2002
102
US
I'm using CR 8.0

I have a report that has a date field and a number field in it. I want to pull out the first record shown and the last record shown for each. I will be using these values for further calculations.

How do I do this?

kowen@rrwa.net
 
Sort by date Sort by votes
What data source? Are you free to create Views ("Queries" in MS Access)? If so, create a VIEW that groups on date and returns the max and min number. Then use that View in your report. You could join the View to the rest of the tables if you need more detail.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petejigsaw
  • Locked
  • Question
Suppress group if it contains both specified detail records
Replies
3
Views
109
lbass
lbass
Betty Boop
  • Locked
  • Question
Report Shows Fewer Records After Grouping
Replies
5
Views
109
lbass
lbass
nicmcd77
  • Locked
  • Question
Legend resizing and overlapping onto chart
Replies
2
Views
114
nicmcd77
nicmcd77
sofseattle
  • Locked
  • Question
How to create value/page break for distinct number of records
Replies
9
Views
114
sofseattle
sofseattle
crystaldev1
  • Locked
  • Question
Sorting a field by combining main and subreport
Replies
3
Views
86
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top