Pay attention to table joins!

Content

Be sure to check how your tables are set up and that you are using the right kind of join when creating your report. (Edit report > Home Tab > Tables) By default, whenever you add a column or filter, the report will automatically use an inner join. This means that the record must exist in BOTH tables for the table’s record to be included in the results. Additionally, joins alter the size of the data set – inner joins return smaller data sets than outer joins so they impact performance of the report. You can manage the size of