Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Dataset Row Limit
Dataset Row Limit [message #720572] Tue, 30 August 2011 20:36 Go to next message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
How do i proceed to limit dataset rows ?

Best Regards

Report message to a moderator

Re: Dataset Row Limit [message #720608 is a reply to message #720572] Tue, 30 August 2011 23:04 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Open the data set in the data set editor and choose settings. Un-check
the "Fetch all rows from data source" check box and enter the limit in
the "Max number of rows to fetch from data source" text box.

Jason

On 8/30/2011 4:36 PM, Fernando wrote:
> How do i proceed to limit dataset rows ?
> Best Regards

Report message to a moderator

Re: Dataset Row Limit [message #720883 is a reply to message #720608] Wed, 31 August 2011 12:37 Go to previous messageGo to next message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
Tried to use this feature, only works in preview. When run the report the dataset returns all rows.
I tried using this script, but not did run.


reportContext.getReportRunnable().designHandle.getDesignHandle().findDataSet(xxxxx).setRowFetchLimit(xxxxx);

Fernando

[Updated on: Wed, 31 August 2011 12:37]

Report message to a moderator

Re: Dataset Row Limit [message #720938 is a reply to message #720883] Wed, 31 August 2011 14:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
What version of BIRT are you using?
I tried it in 2.6.2 and it works fine. Do you have this setting on your
data set?
<property name="rowFetchLimit">10</property>

Jason

On 8/31/2011 8:37 AM, Fernando wrote:
> Tried to use this feature, only works in preview. When run the report
> the dataset returns all rows.
> I tried using this script, but not did run.
>
> Fernando
>
> reportContext.getReportRunnable().designHandle.getDesignHandle().findDataSet(xxxxx).setRowFetchLimit(xxxxx);
>

Report message to a moderator

Re: Dataset Row Limit [message #721025 is a reply to message #720938] Wed, 31 August 2011 18:09 Go to previous messageGo to next message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
I am using BIRT 2.6.2.

In the table works fine, but in the chart does not, only limits the rows if table(component) is used in report , using only chart in report does not work.

Fernando

Report message to a moderator

Re: Dataset Row Limit [message #721032 is a reply to message #721025] Wed, 31 August 2011 18:15 Go to previous messageGo to next message
sam va is currently offline sam vaFriend
Messages: 121
Registered: July 2011
Senior Member
What exactly you want to do after the limit is reached? Do you want to stop execution of the report? Also what DB are you using?

Report message to a moderator

Re: Dataset Row Limit [message #721037 is a reply to message #721032] Wed, 31 August 2011 18:45 Go to previous messageGo to next message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
I need to display the selected data in a chart, however, something unusual happens when I try use first the data in a table followed by a chart, it works perfectly. The problem occurs when I try to use data only on the chart or the chart followed by a table.

I am using an Oracle DB.

Note:In the Sample Database Models Classic works fine.

Fernando
  • Attachment: image0.bmp
    (Size: 1.07MB, Downloaded 534 times)
  • Attachment: Image_1.bmp
    (Size: 1.17MB, Downloaded 491 times)

Report message to a moderator

Re: Dataset Row Limit [message #721038 is a reply to message #721037] Wed, 31 August 2011 18:48 Go to previous messageGo to next message
sam va is currently offline sam vaFriend
Messages: 121
Registered: July 2011
Senior Member
If you are using Oracle, you can try the following

Select * from
( Original query) t1 where rownum < 26

Here 25 is the desired limit. So the result is the first 25 rows. You can pass this as a parameter as well

Thanks

Report message to a moderator

Re: Dataset Row Limit [message #721054 is a reply to message #721038] Wed, 31 August 2011 19:36 Go to previous messageGo to next message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
Thanks vavesw.

But I am trying to not use specific resource oracle.
I can use ROWNUM in latter case.
(Orders of the leader).

Thanks.

Report message to a moderator

Re: Dataset Row Limit [message #721119 is a reply to message #721025] Wed, 31 August 2011 22:51 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Can you try the attached report?

Jason

On 8/31/2011 2:09 PM, Fernando wrote:
> I am using BIRT 2.6.2.
>
> In the table works fine, but in the chart does not, only limits the rows
> if table(component) is used in report , using only chart in report does
> not work.
>
> Fernando
  • Attachment: rowlimit.zip
    (Size: 4.99KB, Downloaded 274 times)

Report message to a moderator

Re: Dataset Row Limit [message #721301 is a reply to message #721119] Thu, 01 September 2011 11:58 Go to previous messageGo to next message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
Please find attached two reports, the chart_table report does not works, the table_chart report works fine.
The only difference between the two reports is the order of the components.

Fernando.

Report message to a moderator

Re: Dataset Row Limit [message #721384 is a reply to message #721301] Thu, 01 September 2011 15:59 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
I wonder if this is a driver issue. Did you try my attached report? Can you try adding to the xml. Try the dataSetRowLimit setting:

<property name="rowFetchLimit">5</property>
<property name="dataSetRowLimit">5</property>

Jason

Report message to a moderator

Re: Dataset Row Limit [message #721442 is a reply to message #721384] Thu, 01 September 2011 19:08 Go to previous messageGo to next message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
Your report works fine.
Adding xml code did not fix my report.

Fernando

Report message to a moderator

Re: Dataset Row Limit [message #721688 is a reply to message #721442] Fri, 02 September 2011 15:05 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
I wonder if this in the oracle driver. Can you open a bugzilla entry
for this?

Jason

On 9/1/2011 3:08 PM, Fernando wrote:
> Your report works fine. Adding xml code did not fix my report.
>
> Fernando

Report message to a moderator

Re: Dataset Row Limit [message #722329 is a reply to message #721688] Mon, 05 September 2011 11:58 Go to previous message
Fernando is currently offline Fernando Friend
Messages: 27
Registered: July 2011
Junior Member
Ok. I will open a bugzilla entry for this.

Thanks Jason.

Fernando

[Updated on: Mon, 05 September 2011 11:59]

Report message to a moderator

Previous Topic:event handle class problem
Next Topic:connetion profile proplem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 01:00:50 GMT 2024

Powered by FUDForum. Page generated in 0.04488 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly