Jump to content
Changes to the Jaspersoft community edition download ×

View Top N Record


ktrinad

Recommended Posts

By: willyw - willyw

View Top N Record

2003-08-15 02:57

How to build design in iReport where can sort/get Top N (lets say N=10) records in the database?

 

 

 

 

By: Giulio Toffoli - gt78

RE: View Top N Record

2003-08-19 15:13

You can not without codig. A way could be code a new IRConnection that request only the first 10 rows to the database (that should be a JDBC option).

 

Giulio

 

 

 

 

By: Peter Henderson - phenderson

RE: View Top N Record

2003-08-20 01:15

Your Database Server may support it.

 

MySQL and Postgres

SELECT * FROM table LIMIT 10

 

MS SQL

SELECT * FROM table TOP 10

 

 

 

 

Peter Henderson

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...