Skipping or inserting a field before a record

[sbirkenkamp]

I am working in CR 8.5

Here is what is in my report

Rh- suppressed
PH-
Gh1- Grouped by database field
gh2- Grouped by formula that contains information regarding a person's giving history
Details- formula {constitutent name}+(suffix)/ formatted in 3 columns
gf2- suppressed (contains summary field for number of names in each G2
gf1- suppressed
Pf-
Rf-suppressed

What I need to do is if G2 count = 1 then insert a blank record before skip to the next so that printing beginis in column two.

Example
current:

Column 1 2 3
Name

Want:
Column 1 2 3
Name

Since the only information in the details section is a formula field could this be of help to me??? any ideas would be great!

 

[lynchg]

I'm not quite understanding what you need. If you are looking to adjust how things are printed in the detail section based on a value in the group footer, I don't think you can do that. The detail section "prints" before the group footer is evaluated.

 

[Madawc]

You can use a summary total at any point within a group, because it is calculated before the group is printed. A running total is only accumulated during the printing.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the name. The disadvantage is that they are working out at the same time as the Crystal report formats the line. You cannot test for their values until after the details have been printed. You can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.

Summary totals are cruder, but are based directly on the data. This means that they can be shown in the header. They can also be used to sort groups, or to suppress them. Suppress a group if it has less than three members, say. They default to 'Grand Total', but also can be for a group.

Variables are user-defined fields. One useful variant are shared variables to pass data from a subreport back to the main report. You can also use variables to show page totals. For normal counting I find running totals or summary totals much easier.

Directly Calculated Totals within a Formula Field can be coded directly, with commands like Sum ({ADV01.Advance}, {ADV01.AccType}). The same result can be achieved by picking up an existing Variable, and will keep the code even if the Variable itself is later deleted. Formula fields can also include Running Totals and other Formula Fields, with some limits depending on when the values are calculated.

It is also possible to get get totals using a Formula Field, which can contain a Variable or a Directly Calculated Total.

To get yourself familiar with the idea, try doing a test report with a summary total and a running total for the same field, placed on the detail line. You'll find that the running total increases as each line is printed, whereas the summary total has the final value all along.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

I think you could handle this by inserting a group#3 on your detail formula. You can place the group name in the position that corresponds to column 2. Then in the section expert, select the new GH#3->suppress->x+2 and enter:

distinctcount({@detailformula},{@detailformula}) > 1

Format the detail section->suppress->x+2 with:

distinctcount({@detailformula},{@detailformula}) = 1

-LB