| Pagination... How? [message #183173] |
Mon, 07 August 2006 13:16  |
Eclipse User |
|
|
|
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
|
|
|
|
|
| Re: Pagination... How? [message #183319 is a reply to message #183311] |
Tue, 08 August 2006 05:58  |
| Eclipse User |
|
|
|
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
>>>
|
|
|
Powered by
FUDForum. Page generated in 0.04743 seconds
Home