How to print an exact numbers of record in a table ?

[pisanimatteo.25]

Good Morning, i have this issue, i have in a table, a dynamic textfield, and i need to print only 15 elements. I tried to change queries of table using "ROWNUM" (ms sql) but nothing change. I hope you understand my question. Thanks all

[nicolas.veilleux]

You must add this limit in sql query to return only 15 rows. Search in ms sql the keywords for that (LIMIT, ROWNUN, ...).

[pisanimatteo.25]

Mmmh don't work, my report continue to print more of 15 rows

[pisanimatteo.25]

Oh sorry now i saw a thing for my report i saw if querie return less of 15 rows i have to print all rows else is more of 15 rows i have to print a string. Now i tried with conditional expression but if there are 17 rows (example) the last 2 rows will print my string. It is pretty complicated... thank you for help