It's all about the answers!

Ask a question

JRS report builder - show Planned Work & Actual Work in hours?

Vicky Pagnaer (63230) | asked Oct 12 '17, 8:07 a.m.

 I found this post:

And I was wondering if there is any way in Report Builder to show the Planned Work & Actual Work values in hours instead of in seconds? 

I want to use the reports as widgets in dashboards, so while I could personally live with an Excel export as well, our userbase wouldn't consider that an acceptable trade-off :-)

Accepted answer

permanent link
Fariz Saracevic (919613) | answered Oct 12 '17, 8:20 a.m.

Yes, you can exprss values in hours instead of in seconds.

Check out and search for Show in hours a value that is expressed in seconds in the data warehouse. NOTE that you need JRS 6.0.4.

Vicky Pagnaer selected this answer as the correct answer

One other answer

permanent link
Jackie Albert (1.6k14946) | answered Oct 12 '17, 9:35 a.m.

One caveat that isn't obvious in the New & Noteworthy is that if you have "Allow only report managers to edit queries" turned on for your data source, you must have Report Manager permissions in Report Builder in order to use the Custom Expression features.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.