logo
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: 372
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 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 07, 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: 372
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 post(s)
I have just seen that the SELECT TOP xxx works also for MS Access...
vicky  
#3 Posted : Monday, April 04, 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 04, 2016 9:57:03 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 372
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 post(s)
Please check: http://forum.sealreport....=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 08, 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 08, 2016 8:13:08 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 372
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 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: 372
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 post(s)
Note the the new 3.1 versions supports now server side pagination....
Users browsing this topic
Guest
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.

Powered by YAF 2.0.0 | YAF © 2003-2017, Yet Another Forum.NET
This page was generated in 0.088 seconds.