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

Posted on August 11, 2017 at 5:40am

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

Web Service Data Source
pisanimatteo.25's picture
pisanimatteo.25
18
Joined: Aug 10 2017 - 12:32am
Last seen: 5 years 6 months ago

3 Answers:

Posted on August 11, 2017 at 5:54am

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
nicolas.veilleux
420
Joined: Jul 13 2017 - 5:22am
Last seen: 5 years 6 months ago
Posted on August 11, 2017 at 6:19am

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

pisanimatteo.25's picture
pisanimatteo.25
18
Joined: Aug 10 2017 - 12:32am
Last seen: 5 years 6 months ago
Posted on August 11, 2017 at 6:23am

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
pisanimatteo.25
18
Joined: Aug 10 2017 - 12:32am
Last seen: 5 years 6 months ago
Feedback