mulitple date formulas in details section

[catchingup]

I am creating report in CR11 - I need to to show a listing of various meeting dates.

I am having an issue getting them to appear on the same rows - does anyone know how I can get this to work.

What I am looking for is the following:

GROUP 1: Business Unit
Group 2: Employee
Detail: MtgADate(s) MtgBDate(s)

so that a few rows would look like this:



HRDepartment MTG_A MTG_B
John Doe 4/4/06 6/7/07
6/4/07 9/10/07

Mary Jane 1/7/07 4/1/07
3/7/08


Instead of getting this, what I am getting puts each meeting date on a separate line.

These are derived off of a {MeetingDate} field with an separate description field determining which type of meeting the date applies to.

Any help is appreciated!!

 

[Madawc]

You can collect details from a group and show them all in the group footer. Try adapting something I wrote to collect postcodes:

// Accumulate using a formula field (suppressed) in the detail line.  Allow for nulls and blanks.
whileprintingrecords;
if not isnull({Recc.Postcode}) and {Recc.Postcode} <> " "
then stringvar pst := pst + {Recc.Postcode} +", "
else if length(pst) = 0 
then stringvar pst := pst + "Excluding blanks; "
else stringvar pst := pst

// Show in using a formula field in the group footer.
whileprintingrecords;
stringvar pst;
left(pst,len(pst)-2)

//  Clear using a formula field using in the group header.
whileprintingrecords;
stringvar pst := "";

Note that clearing in the footer avoids problems with group headers repeating on a new page, which does clear everything for the group. Provided the 'clear' is placed in the section AFTER the display, it will do them in that order.

You could adapt this for dates, datevar. But the simplest method might be doing a detail-line formula field that converts a date into text, e.g.

ToText({your.date}, "dd/MM/yy")

.

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