Pagination Issue

Hi all ,

Am using BIRT for maximo , i'm having 3 dataset and i created one joint dataset with these 3 dataset.

First dataset is used to get the Parent record
Second dataset is used to get the Child record
Third dataset is used to get child task record .

The Format i'm expecting is ,

Parent 1
Child 1
Task 1
Task 2
Child 2
Task 1
Task 2

Parent 2
Child 21
Task 21
Task 22
Child 22
Task 21
Task 22

I'm here to get help for applying pagination in this report . I need to break page for every new parent . I have created a single table and created the layout and applied page break for the whole table with number of record equal to "1" but its breaking for each and every records .. How to obtain this ? Can any one help me in this ... Thanks in advance ...

Find more posts tagged with

Comments

mwilliams

Hi sams,

It sounds like you're setting the page break on the detail row instead of the outer parent group. When you group your table by the parent field, in the group editor, you should be able to select to page break after the group always excluding last. That should do it if I'm understanding correctly.

sams

Hi guru ,

Thanks for your reply . Here i tried grouping parent for the table . Eventhough its breaking for each and every records ..

Consider I'm having 3 dataset and a created join dataset . In layout a created a single table and dropping values to be displayed there like ,,

Page 1

Parent 1
Child 1
task 1
Child 2
task 21
......

Page 2

Parent 2
Child 1
task 1
Child 2
task 21
......

Can you help me to apply page break in this ..

mwilliams

If you're using a joint dataSet that has all of your data in it, you should be able to group by parent, then by child. You'd have a group header for your parent info, one for your child info, and the detail row for the task info. You'd select the outer group, go to the group editor and set up the page break after there. If you can recreate your setup with the sample database and post the report in here, I can show you.

SamsGanesh

Thanks , Williams. I am attaching the rtp file here. it is in birt 2.1.2.
In case you could not run this , you can help me doing the group settings done and upload the rpt here. So that I can test and confirm here.

These are two data values from joined data source :

DataSet1::dataSet::wonum
DataSet1::Data Set::Subset::wonum

First i need to group using father WO which is in DataSet1::dataSet::wonum

Second i need to group using the child of the related father wo which is in
DataSet1::Data Set::Subset::wonum

GOAL : For each Father Wo# , We need a page break. Meaning one father WO# per page with related child record [DataSet1::Data Set::Subset::wonum]

sams

These are two data values from joined data source :

DataSet1::dataSet::wonum
DataSet1::Data Set::Subset::wonum

First i need to group using father WO which is in DataSet1::dataSet::wonum

Second i need to group using the child of the related father wo which is in
DataSet1::Data Set::Subset::wonum

GOAL : For each Father Wo , We need a page break

mwilliams

Check out the attached report design. You had "always" set for before and after for both groups. You only needed it for the most outer group for the after.

sams

Hi Williams ,

I ran the rpt what you gave me with modifications , it does not pagebreak under parent group. some problem which I could not figure it out.

I attached a small zip file with readme and quick steps to run this rpt in your end.

Now you can run this rpt file from your end

Thanks

mwilliams

On first try, I was not able to get it to work. I think it may have to do with the classes folder. Do I need to copy the actual classes directory to the WEB-INF folder? OR just the files within the "classes" directory? Let me know.

sams

Hi williams ,

Thanks for your try . Yes ...you need to copy the whole "classes" directory into WEB-INF folder .

thanks

mwilliams

As I said in my email, it looks like you may just need to move the info that you only want to display at the top and the bottom of the group from the detail rows out into the group headers and footers to keep them from repeating.

SamsGanesh

Hi Williams ,

It solved the issue. YOu really helped a lot. Thank you so much.

Thanks
Sams

mwilliams

You're very welcome. Glad I could help! Let us know whenever you have questions!