Viewing the last x number of records in a report

[kim....@sokiltrucking.com]

I have a report that must fit into a particular space.  How do I limit the number of records in a report to the last 'x' amount?

I.E. - show only the last 6 records 

Kim

[Support]

Select the report object in design mode, then click on the Results per set icon on the tool bar. If you want the last ones, sort them in reverse order.

[kim....@sokiltrucking.com]

This works great when the report is the only item on the screen.

When a report displays as child records (.e. I have a parent record and I drop on a report of all the children) - the Results per set icon does not show up on the tool bar.

[Support]

Correct. Pagination of child records is not currently supported (and doing so has deep technical issues). However, limiting the number of child records retrieved without pagination is technically possible, but may be confusing as the user is not seeing all records but only an arbitrary subset. Potentially this could be worked around by displaying a message in the pagination region saying (max 100 shown) in a future release.

[Support]

This could also be handled today in the current product by creating a VIEW that only returns what is needed and using that as the basis of the report in the child record. This is how edge cases (as opposed to core use cases) are handled within ParaSQL. For example, if you needed to do a UNION or INTERSECT or a complex dynamic calculation across multiple tables that is often repeated, a VIEW is the best approach as the "code" is reusable. Currently VIEWs are manually created and managed (typically via Tools > SQL Console) but a future version of ParaSQL will have some integrated VIEW management features to make this easier.