Render a report with no record

Hi,

I have a workflow that runs bi-monthly to show pending requests at that moment, which means there will be time when nothing is pending. When that happens, I still want to have the report with only column titles. But my current workflow won't render any output when record =0. Is there a way to get the output to show there's no pending?

Thanks.

Output

Accepted answers

Joe_McCoy

I have something similar in some work I am doing and here's how I got it to work. If the formula tool is only creating a timestamp, I would move it back to the filter and then append it to the true side of the filter. Then you always have at least one field and row to pass to the table. At least that worked for me.

Joe

All comments

apathetichell

Your problem is that the true side of your filter has all of the content. The true side won't run if nothing is true. it's not just about having zero records - it's about passing the filter.

Perhaps you can throw something into the false side like using a multi-field to create a record of the [_currentfieldname_] and then rendering that?

KarenYL

Thanks for pointing out my workflow problem, apathetichell,. My false side has approved/denied records. I don't know how to do what you suggested, though.

Joe_McCoy

Joe

KarenYL

Thank you, Joe!

I took your idea, added Date Time Now input tool and append it to true side of my first filter. It worked! I got a report with just column name but no record under, exactly what I'm looking for. Thanks!

Thank you, apathetichell, too for your input!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167