pisanimatteo.25 Posted August 11, 2017 Share Posted August 11, 2017 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 Link to comment Share on other sites More sharing options...
nicolas.veilleux Posted August 11, 2017 Share Posted August 11, 2017 You must add this limit in sql query to return only 15 rows. Search in ms sql the keywords for that (LIMIT, ROWNUN, ...). Link to comment Share on other sites More sharing options...
pisanimatteo.25 Posted August 11, 2017 Author Share Posted August 11, 2017 Mmmh don't work, my report continue to print more of 15 rows Link to comment Share on other sites More sharing options...
pisanimatteo.25 Posted August 11, 2017 Author Share Posted August 11, 2017 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now