Columnar report

[KatieO]

Rows are Individuals, Columns are Months of the year. In the database, users create text entries like Phone call 4/02, Letter 4/15, Meeting 5/3.
I can get the entries in the proper columns, but each text entry creates a new detail line.
I want to group or summarize the entries so that one person's entries just takes up one Row.

Help me before I make them export to excel!

 

[dgillz]

Summarize as desired and you will have multiple rows of detail AND a summary row. Drag any other detail you want into your summary row and supress the detail section and you will have one row per person. Software Support for Macola, Crystal Reports and Goldmine

 

[Ngolem]

This can probably done by storing the data in one or more arrays and printing it is the group footer.

Show me more details of the layout you want and the data fields involved and I'll help out

Jim

 

[KatieO]

This is the formula that puts the Activites into the Column e.g. January. The Product Codes denote the type of contact, like Phone Call, Email, Meeting

IF Year({Activity.EFFECTIVE_DATE}) = 2002 and Month({Activity.EFFECTIVE_DATE}) = 1 then
ToText({Activity.EFFECTIVE_DATE})+" "+{Activity.PRODUCT_CODE}

Each Activity has an Activity.ID that links it to a person