Limiting number of records/bars in a chart

PHPMaker General Discussion (PHPMaker)
1

Hello there:

I am doing a crosstab report with a chart. There are about 100 records, but I want to display only 5 of them in the chart.

The data is simple:

X Y
A 132
B 112
C 90
D 83
E 81
.
.
.
.
upto 100 records

I am doing a bar 2D chart with Y data against X.

Is there a way that I can tell phpMaker to show records from A to E on x-axis.

2

Charts use the same data as the report. You may try to create another report with those 5 records and add chart for it. Then use a dashboard report to show the crosstab report (without chart) and the new chart.

3

Thanks for the reply, arbei.

A related question that can help me solve my issue.

If my report is based on a view that returns 100 rows, can I do something so that the report uses only say first 5 or 10 rows?

4

You should create another view that returns the first 5 or 10 records, and use the view as the source of the report.