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!

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

Count/loop/groupe/formula ?

Status
Not open for further replies.

gazol

Technical User
Jan 29, 2004
31
SE
Hello.

I have trouble finding the right way to make crystal report count how many rows it prints out. I need to make a formula or something that encrease and counts how many rows it prints and then make a groupe on the first 100 then the 101 to 500 and then the 501 to 1000.

Anyone that know how to solv this easy. I know to make a count of my fields but i think i need a increasing formula/loop function and a check formula for the groupe ?

Please help me ! :)

/ Gazol
 
I have tryed to make a simple formula but it doesent work, what´s wrong, why doesent it print 1, 2, 3, 4 ..

WhilePrintingRecords;
numbervar i:=0;
while i > 0 do
(
i = i + 1
);
i
 
For Crystal 8.5, if you just want a regular break, use the record count. Have an extra detail section, with the suppression formula
Remainder(recordnumber, 500) > 0

If you want the first 100, then 101 to 500, then the next 500 and so on, you could do this with two extra detail sections, one of them saying
recordnumber <> 100

You get extra sections by right-clicking and saying [Insert Section Below]. You get at the suppression formulas by right-clicking and choosing [Format Section]

Madawc Williams
East Anglia, Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top