How show 10 first record ?

Applications Grid / Reports
#1

Hello, i need show only 10 first record in a report and graph grid summarized.

How can i do it?, It is possible?

#2

Re: How show 10 first record ?

Grid, Settings, Lines per Page: 10

Or you can change the SQL to use LIMIT

Regards,
Scott.

#3

Re: How show 10 first record ?

Hello Scott, i tried but it no is possible. my report is SUMARIZED, I chane my SQL to LIMIT 1,10 no is possible.
lines per page works only in report with details.

#4

Re: How show 10 first record ?

This is my problem:
I have grouped my report by Year, Month, neighborhood
SELECT
Year,
Month,
neighborhood,
Quanty
FROM
3101_vw_anno_mes_barrio
WHERE Year > 2005
ORDER by Year desc, MOnth, Quanty desc

I need by every Month to show 10 first records with more Quanty sorted of Mayor to Minor

#5

Re: How show 10 first record ?

Good question … thinking out loud: not sure if you could place a counter in your app and increment/check it in onRecord and kick out … might be too much of a hack :wink:

Regards,
Scott.