Jump to content

Formatting Reports via Scripts


This topic is 7781 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7781 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.