RecordNumber field Q...

Greetz. . My problem is: I'm kinda unfamiliar with both Crystal Reports and VBasic as well .. and yet, my job position requires me to do the following:

I have a report which draws it's data from an SQL Database .. Depending on the data in the database ( table ), the report may have as little as 1 or as many as 30 or more records generated on it. Now, what I need you guys 2 help me with is .. When the special field RecordNumber reaches a certain value ( 20 for example ), I should somehow ( that's where you jump in ) tell the report to pass the remaining data onto the next page.

Now, I've tried 2 do something like If fldrecno.value > 20 then report.newpage ( where fldrecno is a name of the recordnumber field ) but I keep getting the same message Runtime Error 424, Object Required. As I said, I'm a newbie in both CReports and VBasic (6.0) area .. and any help would be more than appritiated.
If the problem cannot be solved using the recordnumber field, maybe a formula might help. Again .. I don't know much about formulas either.In the Crystal report's Design window,right click the left panel of "Details" ,in
Format section --> New page after -->Formula Editor(X+2 button) , write this code and try

RecordNumber>=(PageNumber*20)
I think you can pass a variable instead of 20...:)|||In the Crystal report's Design window,right click the left panel of "Details" ,in
Format section --> New page after -->Formula Editor(X+2 button) , write this code and try

RecordNumber>=(PageNumber*20)
I think you can pass a variable instead of 20...:)

Otherwise write this code

RecordNumber mod 20=0|||Thnx a bunch! It works .. and it works fine ..

RecordNumber by Group?

Hello,

Is it possible to show a record number or count by group? I know the RecordNumber field will show me the number for the whole report but what I would like is the following:

Group A
1
2
3
Group B
1
2
3

Instead of group B being 4,5,6...

I'm trying to figure out how to number the lines per group heading. I hope that makes sense.

Many thanks,

StephenInsert a count() into the footer and count how you want. It gives the choices|||Thank you for the suggestions but I'm looking to get a count (like a row number) at the detail level however and I don't think I can do it that way (that I'm aware of).|||You have to do it manually for each Group. Increment and show the counter in the detail and reset in the Group Header/footer.|||You can create a running total:

select a field to summarize;
type of summaries: count
evaluate: for each record
reset: on change of group (select one you need)
:wave: