Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keeping data together

Status
Not open for further replies.

tjcusick

Programmer
Dec 26, 2006
134
US
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

 
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top