I want to print a line at the detail band onlyif it’s on the last row of the page; otherwise, itshould not print at all.
To achieve this, you will need to return the rownumber of the result set in the result set. Or alternatively, after the datawindow is retrieved, populate an empty column with the row number.
Then you can make use of the function last in the datawindow. For the line visible property, you can check the value in the rownumber column against the value returned from
last( rownumber for page ). For example:
if( rownumber = last( rownumber for page ), 1, 0 )