Eclipse Community Forums: BIRT » Pagination... How?

Help

Home

Home » Archived » BIRT » Pagination... How?

Show: Today's Messages :: Show Polls :: Message Navigator

Pagination... How? [message #183173]

Mon, 07 August 2006 17:16

Sachin Dharmapurikar

Messages: 6
Registered: July 2009

Junior Member

Hello everybody,

I donloaded Birt-2.1.0 all-in-one designer build. I saw some cool demos online
and thought to give a try. I have setup the runtime and everything else on
my machine. My database table has 1.1 GB of data. I just fetch partial data
and try to display on the report.

I am using "WebViewerExample"... when I view -
http://localhost:8080/WebViewerExample/frameset?__report=Pag ination.rptdesign

where "Pagination.rptdesign" is my report name, it displays as single page.
I am expecting it should paginate the report. After trying a lot I couldn't
get a paginated report.

Is WebViewerExample is same as "Ajax Viewer"?... This is one of critical
feature to my product.

Any help will be appriciated.

:)

Sachin

Report message to a moderator

Re: Pagination... How? [message #183255 is a reply to message #183173]

Tue, 08 August 2006 04:58

Sachin Dharmapurikar

Messages: 6
Registered: July 2009

Junior Member

Hello Everybody,

Finally I could manage to display paginated report. I wasn't knowing to assign
the Master page to source items.

Now another problem is there-

1. When I try to run a query on 1.1 GB of data in table... it simply died
by giving exception "Out of Memory".
2. Then I tried to fetch 10000 rows by using "LIMIT" clause in sQL and now
the report is showing up. It is taking very long time to display this report.
Already few people reported this bug in last two days... any workaround solution
for this?

-Sachin

> Hello everybody,
>
> I donloaded Birt-2.1.0 all-in-one designer build. I saw some cool
> demos online and thought to give a try. I have setup the runtime and
> everything else on my machine. My database table has 1.1 GB of data. I
> just fetch partial data and try to display on the report.
>
> I am using "WebViewerExample"... when I view -
> http://localhost:8080/WebViewerExample/frameset?__report=Pag ination.rp
> tdesign
> where "Pagination.rptdesign" is my report name, it displays as single
> page. I am expecting it should paginate the report. After trying a lot
> I couldn't get a paginated report.
>
> Is WebViewerExample is same as "Ajax Viewer"?... This is one of
> critical feature to my product.
>
> Any help will be appriciated.
>
> :)
>
> Sachin
>

Report message to a moderator

Re: Pagination... How? [message #183311 is a reply to message #183255]

Tue, 08 August 2006 09:27

Eclipse User

Originally posted by: raison.fermat.eu

Is the data on one single page or paginated on several pages ?
If it's on one page, it's the client's browser which can have problems.
The only solution is to add page breaks to limit the size of each page to avoid browser error.

If the Out of Memory appears in a dialog box which looks like the parameter box, it's your application server which didn't have enough memory.
In that case re-configure your application server.

For tomcat, at launchtime add to java expression -Xms128m -Xmx512m something like that.

Good luck.

Sachin Dharmapurikar wrote:
> Hello Everybody,
>
> Finally I could manage to display paginated report. I wasn't knowing to
> assign the Master page to source items.
>
> Now another problem is there-
>
> 1. When I try to run a query on 1.1 GB of data in table... it simply
> died by giving exception "Out of Memory".
> 2. Then I tried to fetch 10000 rows by using "LIMIT" clause in sQL and
> now the report is showing up. It is taking very long time to display
> this report. Already few people reported this bug in last two days...
> any workaround solution for this?
>
> -Sachin
>
>> Hello everybody,
>>
>> I donloaded Birt-2.1.0 all-in-one designer build. I saw some cool
>> demos online and thought to give a try. I have setup the runtime and
>> everything else on my machine. My database table has 1.1 GB of data. I
>> just fetch partial data and try to display on the report.
>>
>> I am using "WebViewerExample"... when I view -
>> http://localhost:8080/WebViewerExample/frameset?__report=Pag ination.rp
>> tdesign
>> where "Pagination.rptdesign" is my report name, it displays as single
>> page. I am expecting it should paginate the report. After trying a lot
>> I couldn't get a paginated report.
>>
>> Is WebViewerExample is same as "Ajax Viewer"?... This is one of
>> critical feature to my product.
>>
>> Any help will be appriciated.
>>
>> :)
>>
>> Sachin
>>
>
>

Report message to a moderator

Re: Pagination... How? [message #183319 is a reply to message #183311]

Tue, 08 August 2006 09:58

Sachin Dharmapurikar

Messages: 6
Registered: July 2009

Junior Member

Hello Raison,

Thanks for the prompt reply.

1. My report is on mulitple pages and the error is displayed in box which
is similar to Parameter prompt. I changed the setting in catalina.bat for
tomcat and so far for 10000 rows it's not giving any error. Thanks :)

2. My next problem is still as it is. It is taking long (...make it very
long) time to display the resultset when actually it shouldn't take that
much. I have just enquired for 5000 rows so far. For 10000 rows it grows
almost lineraly.

I could see that there are two bugs filed for the same in eclipse bugzilla
but no solution.

Any suggestion will be appriciated.

Thanks,
Sachin

> Is the data on one single page or paginated on several pages ?
> If it's on one page, it's the client's browser which can have
> problems.
> The only solution is to add page breaks to limit the size of each page
> to avoid browser error.
> If the Out of Memory appears in a dialog box which looks like the
> parameter box, it's your application server which didn't have enough
> memory.
>
> In that case re-configure your application server.
>
> For tomcat, at launchtime add to java expression -Xms128m -Xmx512m
> something like that.
>
> Good luck.
>
> Sachin Dharmapurikar wrote:
>
>> Hello Everybody,
>>
>> Finally I could manage to display paginated report. I wasn't knowing
>> to assign the Master page to source items.
>>
>> Now another problem is there-
>>
>> 1. When I try to run a query on 1.1 GB of data in table... it simply
>> died by giving exception "Out of Memory".
>> 2. Then I tried to fetch 10000 rows by using "LIMIT" clause in sQL
>> and
>> now the report is showing up. It is taking very long time to display
>> this report. Already few people reported this bug in last two days...
>> any workaround solution for this?
>> -Sachin
>>
>>> Hello everybody,
>>>
>>> I donloaded Birt-2.1.0 all-in-one designer build. I saw some cool
>>> demos online and thought to give a try. I have setup the runtime and
>>> everything else on my machine. My database table has 1.1 GB of data.
>>> I just fetch partial data and try to display on the report.
>>>
>>> I am using "WebViewerExample"... when I view -
>>> http://localhost:8080/WebViewerExample/frameset?__report=Pag ination.
>>> rp
>>> tdesign
>>> where "Pagination.rptdesign" is my report name, it displays as
>>> single
>>> page. I am expecting it should paginate the report. After trying a
>>> lot
>>> I couldn't get a paginated report.
>>> Is WebViewerExample is same as "Ajax Viewer"?... This is one of
>>> critical feature to my product.
>>>
>>> Any help will be appriciated.
>>>
>>> :)
>>>
>>> Sachin
>>>

Report message to a moderator

Previous Topic:	Exception occured during view chart in tomcat
Next Topic:	Zooming the Chart image

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 16 12:45:17 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter