Eclipse Community Forums: BIRT » Dataset Row Limit

Home

Home » Archived » BIRT » Dataset Row Limit

Dataset Row Limit [message #720572]

Tue, 30 August 2011 16:36

Eclipse User

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

Eclipse User

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

Re: Dataset Row Limit [message #720883 is a reply to message #720608]

Wed, 31 August 2011 08:37

Eclipse User

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] by Moderator

Re: Dataset Row Limit [message #720938 is a reply to message #720883]

Wed, 31 August 2011 10:00

Eclipse User

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);
>

Re: Dataset Row Limit [message #721025 is a reply to message #720938]

Wed, 31 August 2011 14:09

Eclipse User

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

Eclipse User

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

Eclipse User

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 569 times)
Attachment: Image_1.bmp
(Size: 1.17MB, Downloaded 524 times)

Re: Dataset Row Limit [message #721038 is a reply to message #721037]

Wed, 31 August 2011 14:48

Eclipse User

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

Eclipse User

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

Eclipse User

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 307 times)

Re: Dataset Row Limit [message #721301 is a reply to message #721119]

Thu, 01 September 2011 07:58

Eclipse User

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.

Attachment: table_chart.rptdesign
(Size: 57.57KB, Downloaded 573 times)
Attachment: chart_table.rptdesign
(Size: 57.57KB, Downloaded 527 times)

Re: Dataset Row Limit [message #721384 is a reply to message #721301]

Thu, 01 September 2011 11:59

Eclipse User

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

Re: Dataset Row Limit [message #721442 is a reply to message #721384]

Thu, 01 September 2011 15:08

Eclipse User

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

Eclipse User

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

Re: Dataset Row Limit [message #722329 is a reply to message #721688]

Mon, 05 September 2011 07:58

Eclipse User

Ok. I will open a bugzilla entry for this.

Thanks Jason.

Fernando

[Updated on: Mon, 05 September 2011 07:59] by Moderator

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

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 14:36:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter