Generate reports via results of a filter

[J-Riedel]

I am trying to generate some reports and I have 2 issues:

1. I am trying to generate 2 different reports based of of a filter, but I only want the false side of the filter to run if there are no results in the true side of the filter.

Here is my table.  I am doing a filter based on the Results column.  The filter for "T" is Exceptions and "F" in No Exceptions.

I can get the true side to work correctly, but I am having issues with the false side.  I do not want the false side to generate a report if there are records in the true side.  How can I get this to not run?

2. When the false side does run (only when there are no records on the true side), how can I get the report to generate without a data table?  I only want the report text to flow through on the report.  I currently have the workflow setup with a data table, but if I remove it, then the report text attaches to each record from my filter, so the report text shows multiple times.  Is there a way to get a blank table to populate?

Workflow is attached.

Thanks!

[atcodedog05]

Hi @J-Riedel 

Can you share a packaged workflow. I need input files to run the workflow and look into it.

[J-Riedel]

I think this will work.  Let me know if it is not in the correct format.

Thanks!

[atcodedog05 · Accepted solution]

Hi @J-Riedel 

Logic would be something like this get True count. If True count=0 then run false.

You can check by removing the expection row.

Hope this helps : )

[J-Riedel]

Looks to be working as I did test it by removing the record the was labeled as an exception.

Part 2 of my question was related to the table on the false side.  Is there anyway to not have the table populate with all the data?  Either by doing a blank table, or ignoring all together?  I really only want the Report Text to populate this report as I don't need all of the records.  I only need to see the records when there is an exception.

thanks!

[atcodedog05]

Hi @J-Riedel 

Here is what you can do to create a blank table. I am adding a multi-field formula tool and convert table to blank.

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @J-Riedel 

Additionally, you can do it this way too.

Workflow:

Hope this helps : )

[J-Riedel]

I actually used a combination of both.  I took your first example and added the the sample tool from the second example after the multi field formula to only show one row in the table.  I like the results that show in this report when I use both ideas.

Thank you so much for the help, I appreciate it!!

JR

[atcodedog05]

Happy to help : ) @J-Riedel 

Cheers and have a nice day!