Jump to content
Server Maintenance This Week. ×

Customize report base on one-to-many relationship


Garu

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

Recommended Posts

Hi to all,

I have adopted and amended FM11 built-in Event Management solution and I need help to accomplish a report where selected records in Events::EventName as headers and rows as the related records from EventsGuests table.

I'm not sure if I explained it well so I have attached the desired output Custom Report.pdf to illustrate further.

Thanks...

Link to comment
Share on other sites

You probably need a summary report. Generate it from the EventGuests table. The parent event details will be in a sub-summary part. The event guests will be in the body part.

Read up on summary reports to see how to create one.

Link to comment
Share on other sites

Thanks Vaughan for the suggestion... Have you actually look at my attachment? I can't seem to format the headers the way I present it in my attachment as the summary is limited to either trailing or leading.

Link to comment
Share on other sites

This topic is 4735 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
×
×
  • Create New...

Important Information

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