Report - How to have data table match report format?

Travis Michigan
Mega Sage

I have a report that we wanted to display with the hours and minutes only.  Not show the time, and round off on the seconds.  Which the report shows correctly, but when we check the box for Display Data Table, it doesn't take on the same format.  So the report that is sent out to management has seconds (which they don't care about) and also shows days (which they would rather see hours for this particular data). 

 

Is there a way to get the data table to match the format of this report?  (without changing the data in other locations)

TravisMichigan_1-1709133079107.png

 

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @Travis Michigan ,

 

Have you looked into the "Set value formatting" under the "configure" in the report designer? Here you can set the maximum duration unit till hours instead of days.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Yeah that changed the graph display values, but not the report data below.