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

0

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

pisanimatteo.25's picture
Joined: Aug 10 2017 - 12:32am
Last seen: 1 week 10 hours ago

3 Answers:

0

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

nicolas.veilleux's picture
Joined: Jul 13 2017 - 5:22am
Last seen: 12 hours 33 min ago
0

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

pisanimatteo.25's picture
Joined: Aug 10 2017 - 12:32am
Last seen: 1 week 10 hours ago
0

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

pisanimatteo.25's picture
Joined: Aug 10 2017 - 12:32am
Last seen: 1 week 10 hours ago
Feedback
randomness