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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need help with formatting

Status
Not open for further replies.

sameer11

Programmer
Jun 17, 2003
89
US
Hi,

I am doing 3-5 grouping in my reports and I can't check the keep group together in the Group(if I do that I get empty space at the end of the page ) and I don't depending on the data report pages look odd sometimes only the heading keep hanging out there alone. Can anyone help me with any advice and I hope you get what Iam trying to say...

Thanks,
Sameer
 
Sure, you're saying that you want the grouping to start on a new page if the group header is the only thing showing.

Perhaps if you turn on the Keep Together on the group header, but not on the details and group footer you'll get what you want.

-k
 
You would have to describe your report a little better but this is a response I gave to another on a similar problem

******************************

In the Group header make it big enough so that it can also have the first data record for the group

so you have something like this


------------------------------
Group header information
Group header
{Table.field} {Table.field2}
------------------------------
{Table.field} {Table.field2} Detail section
------------------------------

So in essence the first record of a group is always printed in the Group header

Put the following formula in the Group Header

@SuppressFirstRecord

whilePrintingRecords;
numberVar SFlag := 1;

In the conditional suppress for the detail section put the following formula

whilePrintingRecords;
numberVar SFlag ;

if SFlag = 1 then
(
SFlag := 0;
True;
)
else
False;

this will suppress the first record of a group in the detail section....MAKE SURE YOU DON"T REPEAT GROUP HEADERS

this is quite an elegant solution...which leaves a minimum of white space when the Header/1st record are dragged over to a new page.

*******************************************

Now in your case the task might be a bit tricky since you have several headers to worry about.

You might suppress the first ones and put all the information (including the info you would have normally put in the other headers) in the last Group header. Then the problem becomes similar to what I described above.

Hope this helps


Jim Broadbent
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top