Jump to content

Summarizing in Portals


bbielec

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

Recommended Posts

  • Newbies

I have created an invoice file (parent) that pulls the orders (children) associated with each invoice into it via a portal. Is there a way to summarize the fields in the portal and perform a count on them? (i.e. if there are 15 children and 3 of them are named Sam, show the name Sam only once and the count as 3).

Link to comment
Share on other sites

Off the top of my head (and a lot is coming off the top of my head -- which is why commercials for Rogaine are truly annoying):

Create a relationship and a layout in the Child file that finds the same records, sorts 'em, and then summarizes. (Can you say "SubSummary part"? I knew you could.) There are some details missing here, but I get the feeling you can figure it out.

HTH,

Dan

Link to comment
Share on other sites

A portal shows RECORDS. Unless you can do this with your records in the related databas, you cannot do this with a portal.

What is your intent here?

It seems to me that a portal from an invoice into an orders database would never need to have to compress multiple orders into one.

It is possible that your setup may not be optimal for your needs and that a more effecive database structure would solve your problem.

Link to comment
Share on other sites

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