Im making progress with reporting conventions! How do I turn that [Country] field into a header for each record?
thanks!
Solved! Go to Solution.
Hey @Carluccio555, you could do something like this...
First step is to create your Table. Group by country and then just untick the [Country] field as that'll be present in the header:
Next, use a Report Text tool to add text to the Table - here I've just selected to place it above and within the body text we can then reference the [Country] field:
From this, we get the following output:
Just a quick note for future reference: Attaching an actual data sample alongside pictures/explanations is always super handy as we have to rebuild screenshots by hand! Hope this helps!
thanks and what is the best way to also add a timestamp to the report text for the time when the workflow was run?
Hey @Carluccio555, before the report text, just add a Formula tool and use it to make a new column. Use the DateTimeToday() function, which returns today’s date/time (set the data type of the field to date if you only want the date part, or wrap it in ToDate()), and then you can reference this newly created date field in the report text tool.