Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Constrain top X # of sorted records in sub-summary


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

Recommended Posts

Posted

Hello everyone,

Is it possible to constrain x number of ("top x") records based on reordered summary field?

Fields:

-Name

-Item

-ItemCount = Summary (count of Item)

SubSummary: Name

SubSummary: Item (reordered based on Summary of ItemCount)

End Result:

Jack(Name)

------Table 5(Item ItemTotal)

------Chair 2

------Stool 1

------Pen 1

------NoteBook 1

------Eraser 1

Mary

------Table 8

------Chair 3

------Stool 1

------Pen 1

I would like to be able to see only eg. top 3 Items for each Name.

Many thanks!

ConstrainPrint.zip

Posted

Yes thats pretty straight forward, read here:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

and be aware that omit of multiple record has been improved since the article was made.

Hope this is sufficient clue??

--sd

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