|
Re: Dataset Row Limit [message #720608 is a reply to message #720572] |
Tue, 30 August 2011 23:04 |
|
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 12:37 |
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 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 |
|
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 #721119 is a reply to message #721025] |
Wed, 31 August 2011 22:51 |
|
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 285 times)
|
|
|
|
Re: Dataset Row Limit [message #721384 is a reply to message #721301] |
Thu, 01 September 2011 15:59 |
|
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 #721688 is a reply to message #721442] |
Fri, 02 September 2011 15:05 |
|
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
|
|
|
|
Powered by
FUDForum. Page generated in 0.04982 seconds