Keep together with fist record

[ryangus]

I want to keep a group together, but if there is room for one record on the bottom of the page, I want begin printing on the bottom of the page. Microsoft Access does this quite well. Does anybody know how to do this?

 

[synapsevampire]

Right click the Group and select Change Group.

Select Keep Group Together.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ryangus]

I know about the Keep together function, but I only want to keep the group header together for the first record.

Thanks anyway

 

[Naith]

You can only do that using the Keep Group Together option in Format Section. (Right click the X+2 button, and enter OnFirstRecord).

Be aware that the Keep Together option needs to be turned off in Change Group.

Naith

 

[ryangus]

Naith,

Thanks for your help, but unfortunately it did not fix the problem

For some reason, I still get a group heading on the bottom of the page with records commencing on the following page. Even by simply selecting Keep Together does not truly keep the group together (shouldn't it start a new page?).

Thanks anyway.

Regards,
Ryan

 

[kenhamady]

There is another technique where you put a fake details line in the GH by duplicating the detail fields at the bottom of the GH. These will print the values from the first record of each group. Then suppress the first detail of every group (since they are already printing in the GH of each group). This way the GH can't print without one detail. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[ryangus]

Ken,

How do I suppress the first detail of every group?

Regards,
Ranga

 

[ryangus]

I've managed to suppress only the first record of the whole recordset. Hence, the first instant of the group header shows the first record fine, and the details does not show this record. This works fine.

However, all subsequent instances of the group header show both records.

How do I suppress the first record within each group, rather than the whole recordset?

Regards,
Ranga

 

[synapsevampire]

To suppress the first row of every group in the details use a suppression formula akin to:

{MyTable.MyGroupField} <> previous{{MyTable.MyGroupField})
or
onfirstrecord

This says that if the group is different (hence the 1st), or if it's the first row of the entire recordset, suppress it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

You should probbly reverse them so that you don't hit the NULL:


OnFirstRecord
or
{MyTable.MyGroupField} <> previous{{MyTable.MyGroupField})


Or you can create a group level running total that counts the records in each group, and suppress if the RT = 1. This is sometimes safer when you have multiple group levels.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com