Jump to content
Sign in to follow this  
Leb i Sol

Constrain top X # of sorted records in sub-summary

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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