Create Report base on Condition

[J-Riedel]

Hi,

I need to add a validation/test/exception report to one of my processes.  This test is to compare 2 tables and test if there is a new record for the current month in the first table, there needs to be an associated record in the 2nd table. In some months, there might not be a record in either table, therefore, my process is resulting in "No Records". 

I would like to determine if there is a way to to complete this test (which I have already done) and based on the results generate one of 2 reports:

• If there are current month records in the first table, populate the table that will show be the results of the test for the current month records.
• If there are no current month records (table result s in "No Records"), populate a report that would show "No Exceptions"

The issue that I am having is if there are no records, the table and report will no generate.  I have tried to add a blank row, which then in turn works, but will run even when I have current month records, therefore, it is generating both reports and I only want one.

Is there a way to do an filter to choose which report to run?  I have attached my sample workflow for what I am attempting, but am hitting a wall.

Thanks!

[apathetichell · Accepted solution]

use the count records tool - it will give you a zero if there are no records. You can then filter if the record count is zero and run the alternative report or no report.

[J-Riedel]

Where in the process would you add the Count Records tool so that you can still get the data to populate the report for the alternative report?

Thanks!

[J-Riedel]

I was able to determine the placement of the count records tool and got everything to work.  Thank you for the guidance.