BIRT Report Design with Time Difference
Virgil Dodson
E admin
This design uses a calculated field to get the difference between two time fields in minutes and then shows those minute aggregrated within a table group.<br />
<br />
The computed column looks like below where I had to divide by 1000 to get from milleseconds to seconds, and then divide by 60 again to get the number of minutes elapsed.
This example was created with BIRT 2.3.0
<br />
The computed column looks like below where I had to divide by 1000 to get from milleseconds to seconds, and then divide by 60 again to get the number of minutes elapsed.
(row["stop"].getTime() - row["start"].getTime())/1000/60<br />
This example was created with BIRT 2.3.0
Warning
No formatter is installed for the format ipb
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management