Keeping data together

[tjcusick]

How do i keep my data together. All i have on the report is a Agency ID Group and a Type Group. I have a total like at the end of each Type Group (there is either a full or limited type) so at most it will only have 2 total lines. Then a total line for the Agency ID and that just totals the Full total and the Limited Total.

So the report looks something like this:

Agency ID - XXXXX00011
Total for Full: 500
Total for Limited: 675
Total for Agency ID - XXXXX00011: 1175

Agency ID - XXXXX00012
Total for Full: 400
Total for Limited: 878
Total for Agency ID - XXXXX00012: 1278

etc...

I want it to not split the four lines even though they are in different after sections.
Actually its:

AgencyIDGroup:Before-BeforeAgencyFrame (Agency ID)
TypeGroup:After-AfterTypeFrame (Total for) lines
AgencyIDGroup:After-AfterAgencyFrame (Total for Agency ID)

I hope this makes some sense...

Thanks for the help.

Tom C

 

[ASG0856]

Are you saying that you want the totals in one frame?

If so, I think you can delete the Agancy ID before frame. As you are grouping by that value, you don't actually have to display it.

Press Shift and drag each of the two totals fields to the overall total field. This should copy them, but leave the originals in place and retain a link back to them.

Set The display options for the two original totals and their frames to not display in windows, print etc. This should give you an output on one line.

 

[tjcusick]

No actually what i mean is at the end of the actual page. before it splits to the next page.

I dont want the info to be split, ie.

start of page 1
Agency ID - XXXXX00011
Total for Full: 500
Total for Limited: 675
Total for Agency ID - XXXXX00011: 1175

Agency ID - XXXXX00012
Total for Full: 400
end of page 1

start of page 2
Total for Limited: 878
Total for Agency ID - XXXXX00012: 1278

 

[ASG0856]

I can't think of an in built method. However you could
1. Sum up the total of the frame depths
2. Go to PageList, and get the height of the flow
3. Adjust the frames till the sum equally (or very nearly) divides into the flow height. The should ensure the rows stay to-gether.

 

[tjcusick]

thanks i will look into that