Please enable JavaScript to view this site.

thankQ Help

Navigation: CUSTOM REPORTING > TQ Form Reporting

Report on a Sublist Filter

Scroll Prev Top Next More

If the form you are reporting on has a sublist you can choose to only output the records in the filter.

For example in the Batch form if you only want to report on payments over $50 you can do this as follows:

1.        First go to the sublist and use the filter to exclude the payments you don't want (for information on how to use the filter, use the link below):

 https://thankq.net.au/thankqhelpsystem/thankqhelp/filter-payment-in-batch.html

 BatchFilterOver50

2.        Run Report with Sublists:

 ReportWithSublistsOptions

3.        Make sure you are selecting the correct sublist you want to report on. In this example it will be Payment Detail:

 SelectPaymentDetail

4.        Create the report the same way as specified in TQ Form Reporting.

5.        When you output the report it will only have the records you allowed in the filter, all of the excluded records will not appear:

 ReportFiltered

6.        Note: If you want to get rid of the filter just use the Clear Filter button. You can then run the report again if you actually wanted all of the records reported on:

 ClearedFilter