Different techniques for creating a list of unique values using Jet Reports.
Ever wanted to use Jet Reports to create a unique list of filtered values in Excel? Ever wanted several fields from the same record to be in your report but didn't know the fastest way to do that? Learn the fundamental Jet Reports techniques!
For example, you have a data set that repeats values. (e.g. account numbers, document numbers, item numbers, days, regions, countries, cities, etc.) You need to report on that data set but you don't want the key value, (e.g. document number), repeated.
We'll show you how to create a list of unique values from that data set. From there you can continue to build out your report. Sales by sales rep during a period? Purchases posted to the GL by vendors in certain countries?
And, what about when you need information from more than one field for a transaction?
This video demonstrates some of the fundamental techniques in creating a Jet Report.