Solved

Reset Record Number in Crystal Reports

Posted on 2009-07-10
1
993 Views
Last Modified: 2012-06-27
I want to show a count of each record in a report but I want to reset it to 1 for each group.  Currently it just continues to count because I am using the "Record Count" field.  Any ideas?

Note that I am using CR 8
0
Comment
Question by:Bob Schneider
1 Comment
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24827990
OKay, lets assumme you have report like so:
GH - Group Header Section
D - Detal Section
GF - Group Footer Section
1. Create a formula like below and place it in the Detail Section -
WhilePrintingRecords;
SharedNumberVar ct;
Ct := Ct + 1;
Ct
2. Create another formula and palce this in the Group Footer;
WhilePrintingrecords;
Shared Numbervar ct;
ct
3. And to reset create another formula to place it in the Group header:
WhilePrintingRecords
Shared Numbervar Ct := 0;
And this should do it. Hope this helps.
P.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

808 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