Brain Teaser: Aggregate by Dimension Attribute

Calling all Jet Reports report writers.


I saw this post on Dynamics User Group from a few years ago.
"I need help creating a report in Jet Express [report writing software]. I have the "Age" field in the vendor table and I want to show purchases grouped by age bucket: ex. 10 - 20, 20 - 30 , 30 - 40 and the count of vendors .. need help"

Solution Permutations: 

• Lvl 1 Solution:  Assume using Jet Express & all data originates from Vendor and Vendor Ledger Entry.  May have to 'mangle' the data post execution.
• Lvl 2 Solution:  Assume using Jet Professional & all data originates from Vendor and Vendor Ledger Entry.  Can use Pivot tables or other post aggregation methods, but no mangling data post execution.
• Lvl 3 Solution:  Build solution without using Table Builder and no pivot tables (or similar) for aggregating the data post running the report.
  
  

Don't miss the solution!  Sign up for our bi-monthly mailing list or visit www.OnyxReporting.com/blog to access our archived posts.

Jae Wilson is a Jet Reports Certified Trainer from Data Analytics consultancy Onyx Reporting.