data will not go to top of detail line

[sap1958]

I have a crystal report(2008) that includes a groupHeader called Corporate. it has two columns in the page header called General and Presidential. I show the corporate name on the group header line. If a constituent falls in the general area or Presidential area they appear on the detail line. The problem is some of the constituents do not go to the top of the detail line. The data looks like this

General Presidential
XYZ Company John Smith
Sam Smith
Ed Brown

XYZ is on the group header line. John Smith Sam Smith and Ed Brown are on the detail line. John and Sam are under General and Ed Brown is under Presidential. Notice that Ed Brown has space and did not go to the top just under the name Presidential. Why is it that the constituent does not go to the top of the detail line. I used formulas to segment the names for General and Presidential

 

[lbass]

Each result is coming from a different record, and therefore appears on a different line. You could place the groupname in the company group footer, and then add this formula to the group header:

whileprintingrecords;
stringvar gen;
stringvar pres;
if not inrepeatedgroupheader then (
gen := "";
pres := ""
);

Then in the detail section add this formula and suppress it:

whileprintingrecords;
stringvar gen;
stringvar pres;
if {table.area} = "General" then
gen := gen + {table.name} + chr(13);
if {table.area} = "Presidential" then
pres := pres + {table.name} + chr(13);

In the group footer, add two formulas:

//{@displgen}:
whileprintingrecords;
stringvar gen;

//{@displpres}:
whileprintingrecords;
stringvar pres;

Format each formula to "Can Grow." Then suppress the group header and the detail section.

-LB