choosing the amount of rows to display [RESOLVED]

[EyeTalion]

In crystal how do you set a limit on the amount of rows to display? On the Format Editor under the Common Tab I selected the "Can Grow" checkbox and put in 25 lines, but thats not working...

[brucevde]

Rows of textdata or the # of database records per page?

[EyeTalion]

rows of data

[brucevde]

Works fine for me. Can you give more info...

[EyeTalion]

Just looking to display the first 25 records...

[brucevde]

Okay so which is it? the first 25 records or 25 lines of data.

The CanGrow property is for a single field, like a Memo/Text field. Setting Maximum lines to 25 should work.

If you only want to display 25 records per page, add the following to the "New Page After" formula in the section editor - most likely for the Details section.

RecordNumber Mod 25 = 0

[EyeTalion]

I'm looking to just show the first 25 records and that's it. Not 25 records per page.

[brucevde]

If the report datasource is a query, use the Top clause in the select statement.

Otherwise you could Suppress the Details section with this formula

RecordNumber > 25

However report Formulas, Summaries etc will still include data from all records.

[mabbas110]

You can put a running total on the report , that only does counting of rows , means count any of the field and then just save it by any name like example recno

in the record selection wirte the formula

recno<=25.

[EyeTalion]

I used the Group Sort Expert and was able to display the Top 25 records that I needed....