Formatting Reports via Scripts

[swainlib]

I would like to generate a report that would show a company name and all the employees of that company. Basically, I want it to search through the Company field, print it only if it is the first occurrence, and print the Employee Name associated with that company. I would want it to look like this:

Company A: Company B:

Employee 1 Employee 4

Employee 2 Employee 5

Employee 3

I can sort it by the Company field but it does not clump all the employees of one company together and it also shows the company name each time.

Does anyone have a solution to this problem?

[filecrazy]

Create the layout.

Under Layout Setup, select "Print in x columns" - specify number of columns.

Create a "Sub-summary when sorted by:" part in Layout mode. Be sure to sort by company.

When creating the Sub-summary part, select "page break before each occurrence".

Add the Employee field to the body.

That should do it. Remember to sort by Company when running the report.

Good luck.