It's all about the answers!

Ask a question

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


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

 I found this post: https://jazz.net/forum/questions/207656/jrsreport-builder-are-the-estimate-or-time-spent-attributes-reportable


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.
FORUM MODERATOR / JAZZ DEVELOPER

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


Check out https://jazz.net/pub/new-noteworthy/jrs/6.0.4/6.0.4/6.0.4/index.html 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.6k14947) | 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.