Hi,
could any one tell me please, how to find out the number of rows on a page?
I need it for some like:
if rows-available < 6
do some
tia
ronHow about using running totals field which u can find in the "Field explorer"?:wave:|||thank u CrystalBabysteps but I can't figure out how many rows left with "field explorer" (or I don't know how to do)
if I run a report and after some records I like to know if 6 rows still left, if not make page breaks
ron|||what iam attempting to tell you is, make a running totals field and place it in the required section say Details. Then go open the report->section expert (assuming ur using CR9 the menu may be lil diff in other vers). There u will find a check box "New page after" with a small button having caption x-2. click it and write in the space provided
if {#RTotal0}>6 then true else false;
Note {#RTotal0} is name you might have given to the Running total
press Alt+C to see there are any errors.else save it and exit.
I believe this should solve ur problem
How to make Running Totals field?
See to the left of the screen you should find "Field Explorer". If u dont see it go to View->Field Explorer. In the FE u should find Running Totals Fields, Rt click it and select New... select the field which would determine the rows in a page. Give a name to Running Total Name, do the other selections as required, then OK and exit
No comments:
Post a Comment