Eclipse Community Forums
Forum Search:

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

Best Regards
Re: Dataset Row Limit [message #720608 is a reply to message #720572] Tue, 30 August 2011 19:04 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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


Jason Weathersby

BIRT Exchange
Re: Dataset Row Limit [message #720883 is a reply to message #720608] Wed, 31 August 2011 08:37 Go to previous messageGo to next message
Fernando  is currently offline Fernando
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 08:37]

Report message to a moderator

Re: Dataset Row Limit [message #720938 is a reply to message #720883] Wed, 31 August 2011 10:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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);
>


Jason Weathersby

BIRT Exchange
Re: Dataset Row Limit [message #721025 is a reply to message #720938] Wed, 31 August 2011 14:09 Go to previous messageGo to next message
Fernando  is currently offline Fernando
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
Re: Dataset Row Limit [message #721032 is a reply to message #721025] Wed, 31 August 2011 14:15 Go to previous messageGo to next message
sam va is currently offline sam va
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?
Re: Dataset Row Limit [message #721037 is a reply to message #721032] Wed, 31 August 2011 14:45 Go to previous messageGo to next message
Fernando  is currently offline Fernando
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 102 times)
  • Attachment: Image_1.bmp
    (Size: 1.17MB, Downloaded 99 times)
Re: Dataset Row Limit [message #721038 is a reply to message #721037] Wed, 31 August 2011 14:48 Go to previous messageGo to next message
sam va is currently offline sam va
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
Re: Dataset Row Limit [message #721054 is a reply to message #721038] Wed, 31 August 2011 15:36 Go to previous messageGo to next message
Fernando  is currently offline Fernando
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.
Re: Dataset Row Limit [message #721119 is a reply to message #721025] Wed, 31 August 2011 18:51 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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 101 times)


Jason Weathersby

BIRT Exchange
Re: Dataset Row Limit [message #721301 is a reply to message #721119] Thu, 01 September 2011 07:58 Go to previous messageGo to next message
Fernando  is currently offline Fernando
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.
Re: Dataset Row Limit [message #721384 is a reply to message #721301] Thu, 01 September 2011 11:59 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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


Jason Weathersby

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

Fernando
Re: Dataset Row Limit [message #721688 is a reply to message #721442] Fri, 02 September 2011 11:05 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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


Jason Weathersby

BIRT Exchange
Re: Dataset Row Limit [message #722329 is a reply to message #721688] Mon, 05 September 2011 07:58 Go to previous message
Fernando  is currently offline Fernando
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 07:59]

Report message to a moderator

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


Current Time: Thu Apr 24 14:41:35 EDT 2014

Powered by FUDForum. Page generated in 0.02183 seconds