logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
epf  
#1 Posted : Tuesday, January 14, 2014 6:38:54 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
It is always interesting to be able to limit the number of records that will be received and processed by the report engine.
At least at design time, if you have a huge table, you want to design your report with a small amount of rows for performances reason.

If you are using SQLServer, use the TOP option of the SELECT clause:
Code:
select top 100 from aTable
will return only the first 100 rows.

Select your model in the TreeView, then edit the Select Clause property and add the
Code:
TOP 100
after the SELECT


If you are using Oracle, use the rownum restriction in your WHERE clause:
Select your model in the TreeView and add
Code:
rownum < 100
in the Restrictions box.

Edited by user Friday, February 7, 2014 7:15:42 PM(UTC)  | Reason: Not specified

epf  
#2 Posted : Wednesday, March 12, 2014 4:45:01 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
I have just seen that the SELECT TOP xxx works also for MS Access...
vicky  
#3 Posted : Monday, April 4, 2016 9:15:06 AM(UTC)
vicky

Rank: Newbie

Groups: Registered
Joined: 4/4/2016(UTC)
Posts: 5
India
Location: Pune

How can we add server side pagination to reports?

also can you please let me know how we can limit the number of records while using SEALMASTERTABLE?
like it fires whole query -> brings result -> applies client side filters on the result.
so each time it fires the whole query on the database.
is there any alternate solution to it?
epf  
#4 Posted : Monday, April 4, 2016 9:57:03 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Please check: https://sealreport.org/f...=posts&t=151#post333
Server side pagination is not implemented in the current version.
On the other side, there is no sense to generate an html file with 5000 records for an end-user...
vicky  
#5 Posted : Friday, April 8, 2016 6:41:17 AM(UTC)
vicky

Rank: Newbie

Groups: Registered
Joined: 4/4/2016(UTC)
Posts: 5
India
Location: Pune

Hi Admin,

We would like to sponsor it,

can you please provide the details for it.
epf  
#6 Posted : Friday, April 8, 2016 8:13:08 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Good idea, I will contact you directly by email...
epf  
#7 Posted : Wednesday, April 12, 2017 1:38:19 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Note the the new 3.1 versions supports now server side pagination....
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.