Drawing seperator to display Subtotals

Hi all,

Can anyone explain me to fix this issue?
In my report, I am displaying subtotals for group by report.
Each subtotal is displayed in every page for the records in the db.
And after the list of records, I am trying to draw a line and below that line the subtotals are displayed just a separator for the records and the subtotals.

My issue is when there is a display of subtotal on top of the next page, the line which i am using in the footer is displayed which actually is seen below the column header of the next page and below the line of the column header.
So how to control that line drawn on the next page when the page becomes full?
Can anyone help ?

Anything to do with a page break?

Help me geeks ........

Find more posts tagged with

Comments

mwilliams

Hi Nimmy,

So, you're wanting to not show the separator line if the subtotal is the first line on the page? Is this correct?

Nimmy

Yes Micheal,

You are absolutely right and got my point.

I cudnt send the gif attachments through manage attachments down here.

Anyway having undertood can you please help me to fix this?

Thanks mate !!

Nimmy

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Nimmy, 
 
So, you're wanting to not show the separator line if the subtotal is the first line on the page? Is this correct?</blockquote>
 
Hey, 
 
Having understood my issue can you please reply me ?????? 
 
Just waiting Williams. 
 
Thanks

mwilliams

Nimmy,

You might be able to create a variable that is incremented on the onCreate event of each row. In the onPageBreak event, you would reset the variable to 0. In the script for your group footer, you could then check this value in the onCreate. If it is 0, you would not put a border line up. If not, you'd include the line. I have not tried this, but theoretically, it should work. Let me know if you have questions or issues.

Nimmy

Hi Micheal,

Just trying with your logic.

But came out with another issue.

I am trying to reset the page number after each group.I am successful with this.
But at the end of the group, footer is displayed at the middle of the page where the record ends but not as the report footer as I have written in the group footer the condition and checks to display the group footer.
How to hide the group footer is I am at the end of the group and display the page footer with the group page number in it?
Can u please help me to float the page number between master page and the group code?

Any suggestions would help a lot ..

- Nirmala

mwilliams

Nirmala, 
 
The idea in this devShare post may help you push the group footer to the bottom of the page. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/989-extend-table-to-fit-page/#description'>Extend Table to Fit Page - Designs & Code - BIRT Exchange</a>

Nimmy

tried that too Williams I am using Eclipse version 3.3.2 - its very limited with its features.
While trying your suggestion another issue like the group footer is displayed where the data is available at the last page of the group. Like it the data stops at the right top the footer is displayed at the top it at the middle footer is displayed middle only. Cannot switch between group footer and page footer at the execution time. It is possible to hide the group footer and display the page footer at design time. but not working at the run time. Also the variables used in the group footer can be inherited in the page footer at design time but not at the run time.
But after displaying the group footer, beautifully the footer is reset for the next group. That much is successful but the occurrence at the bottom of the page for the last page of the group is not possible.
How to use CLASS event handlers which I saw in the Layout?
Can you have anything to say about DATA CUBES? what is it?

Thanks & Regards
Nirmala

Nimmy

I shall explain what I have done so far.
In the initialize I have set these
Pagecount=1;
total=1;
In the master page count,I have written these
"Page " + pageCount + "of" + total; ... master page code
In the detail code I have written
if (pageCount==1){
pageCount++;
total = Math.ceil(row["Aggregation"]/10);
prev = row["JUVENILE_ID"];
}
else if (row["JUVENILE_ID"] == prev){
pageCount++;
}
else {
prev = row["JUVENILE_ID"];
pageCount=1;
total = Math.ceil(row["Aggregation"]/10);
}

- nirmala

Nimmy

works fine when design time execution. but not possible for the run time data. 
With the design time say if I have 2 groups and 2 pages for first and one page for second group. It is displayed as Page1 of 2 then page 2 of 2 and at last page 1 for the second group(footer resets according to the group) 
But at run time all pages have page 1 of 1 in every page which is given in the initialize method and thereafter it is not incremented at all for these codes written 
Please help me Micheal. Very critical !! 
 
-NIRMALA 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Nirmala, 
 
The idea in this devShare post may help you push the group footer to the bottom of the page. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/989-extend-table-to-fit-page/#description'>Extend Table to Fit Page - Designs & Code - BIRT Exchange</a></blockquote>

mwilliams

NIRMALA,

A dataCube is a source for a crosstab. It essentially creates a matrix of data corresponding to row and column groupings out of whatever dataSet's data you use.

As for the problem with the problem with the page count on the group footer from the example. What issue are you having? I'm not sure I'm quite understanding. It works in the designer, but not when you actually deploy the report? Or something else? Let me know.

Nimmy

Yeah, the code works fine in the designer and the group footer value is been inherited in the master page footer but not when deploying the report. 
 
When deploying, the page footer takes the value which is assigned in the initialize method only once and not been incremented. 
 
how to increment the values which is been used in the initialize method also take the calculations done in the group footer. 
 
hope u understand better now? 
 
thanks 
nirmala 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">NIRMALA, 
 
A dataCube is a source for a crosstab. It essentially creates a matrix of data corresponding to row and column groupings out of whatever dataSet's data you use. 
 
As for the problem with the problem with the page count on the group footer from the example. What issue are you having? I'm not sure I'm quite understanding. It works in the designer, but not when you actually deploy the report? Or something else? Let me know.</blockquote>

mwilliams

nirmala,

Can you recreate your issue with the sample database so I can take a look at it actually running. Let me know your BIRT version so I can run it in the designer and see it working and also to make sure I have the correct version of the web viewer to open the report. Thanks!

Nimmy

Hi Mike,
I am using Eclipse Europa version 3.3.2
Sampledb ---Classicmodels
Table---Employees table
Columns----EmployeeNumber,Officecode
Group By----Officecode,EmployeeNumber
Order By----Officecode

We are trying to reset the page numbers for group-wise reports.The attached design file works fine in the design time but not in run time.

In the run time the page number count in the initialize method is not iterating the values.So the problem page number got static values.

Still its a critical open issue.Please Reply.Waiting for needy reply.

Regards,
Nirmala.