Jump to content

Reports with Portals?


chrisdortignac
 Share

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

Recommended Posts

  • Newbies

Hi,

I'm a newbie and I'm not sure if I'm in the right topic.

I am working with a db for tracking all of the information associated with hymns. I have a Serial #, Title, Composer, Author, Copyright, ect...

What I want to do is create a report which will show me the following:

Author............ X,XX,XXX, (Associated serial#'s)

Composer.... X,X,X,XX, "

I am supposing these are in a portal, but I cannot get a portal to show them to me this way, only in a vertical list.

There are some cases where the Author and Composer are the same. In those cases, I only want one record to show. I Figured out how to do this, but I can't seem to figure out how to create a record, or better yet, just an entry on the report, that may or may not, have the same Serial#'s If Author notequal.gif Composer. I'd rather not have duplicate records of each song just for the sake of showing a proper report.

Currently, I got as far as getting FMP to show me the associated records, but it shows me the Author/Composer multiple times, (once for every record they are entered in), and I really only need their name once.

Is this confusing? If anyone knows what I'm asking, I would appreciate the help!

Link to comment
Share on other sites

"it shows me the Author/Composer multiple times, (once for every record they are entered in), and I really only need their name once"

You need to create a summary report, using the "Author" field as the break field.

Link to comment
Share on other sites

This topic is 6591 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.