One of the common tasks a report writer can be asked to do is sort or limit information based on certain dates or date ranges. They could use SQL functions like:
matusetrans.actualdate >= dateadd(day, -7, convert(varchar, getdate(), 101))
workorder.reportdate >= getdate() - 7
po.followupdate - getdate() >= 0
matusetrans.actualdate …One of my favorite Maximo/BIRT sites is Bruno Portaluri's. He's an IBM IT Architect and has some of the best details related to Maximo customization and development. One his posts that is resonating with me right now is how to analyze report performance. A lot of time and effort …
For several months now we have been without our PS3. Not tragic news for some, but for me and the boys it's been a bit of a disappointment. Well I found out last week that a technical write-up I did was selected as the post of the month (link to …
One of the most unique features of BIRT is its ability to use other programming languages to do complex tasks within the report file. Take a look at the forums on BIRT-Exchange.com and you will see examples of people using PHP, java, javascript and more. This post will show …
Moving from other reporting packages to BIRT, you will always find that one feature you had in your previous reporting tool that you can’t find right away in BIRT. As I’ve continued to adopt more of my company’s internal reports to BIRT, I found date formatting is …