Excel Headers

[insomned]

Hello,

I would like to use the Report Header tool to post to Excel header the latest file dates from the Directory tool. How can I make this dynamic (ie input the column from which to take the file names) to Report Header?

Thanks a lot!

[AngelosPachis]

Hi @insomned ,

I don't believe there's a way to feed the value of a column from your workflow to the Report Header tool. However, as an alternative you can try to use a Report Text tool instead, which will allow you to use values from your workflow.

In my example below, I'm reading all files from a directory, sorting them on descending chronological order of last access date/time, keep the most recent record and feeding that into the report text tool.

You can then use a Layout tool to place it at the top of your report, close to the header.

Hope that helps,

Angelos

[insomned]

Hi @AngelosPachis , how could I join this with my Excel report then?

Thank you! 

[AngelosPachis]

Hi @insomned ,

If you want to find out more about how to join different reporting snippets together, you can right-click on the Layout tool and select "Open Example".

This will take you to a sample workflow that demonstrates how the tool is used

If you want this to be more specific to your case, maybe you can share a mock workflow with a similar report and I can try to help you further.