Report limit to 5 last records

PHPMaker General Discussion (PHPMaker)
1

Hi!
I’m trying to customize my landing page.

  1. I would like users to start by searching instead of seing the all table
  2. they would see the last 5 records added also on the landing page
  3. would have some other report/table with some necessary info (have to think more about this to see if it’s really necessary)

I have two options:

  • Customize my advanced search page and add a column for showing the last 5 records also (before making the search)
  • Create a dashboard report

What I did:

  • I’ve created a report for the main table to use on a dashboard report

Problems:

  • I can’t seem to find how to limit the records in the report to only 5
  • I don’t think it’s possible to “call” the search in a column except by creating a new template
  • Which leaves me with the option to custom the template for the advanced search page, but how would I call those 5 records?

is there a better option for all this?

2
  1. I would like users to start by searching instead of seing the all table

You may enable “Requires search criteria”, see the topic Table Setup in the help file.

  1. they would see the last 5 records added also on the landing page

Assume you meant tables (not reports which usually use number of groups per page if you have grouping fields), you may set the page size as 5.

3

I still would like for the table to be “normal” without always requiring search criteria nor to be limited to 5 records, except for the “listing” on the custom template or dashboard…

Maybe I should read better about grouping in reports…?

4

That would limit the list view to always 5 rows, right? And I’m trying to find a way to show 5 rows somewhere else and keep the list view intact with all records (and page navigation)…

5

You may create a view from the table for use with the dashboard.

6

Ok, thought there was another way but thank you for your help :slight_smile: