Reporting

Yes, I am still working on BIRT report as fire fighter for one of my projects. Now was into another tricky issue. The BIRT report I am helping on looks all good except when try to export it to PDF. Some particular page the content cross the footer, such as below: Tried different options, such as setting page break, modified padding of the row. But none of them solved this issue. Tried asked MR. Google, but didn’t find any useful solution on it. The client can accept to move the paging number to the top, but it will require to update the master page template, and I thought it is not a good solution as well. I can understand this should be caused by pdf export function on calculating the page content might be different with how BIRT report, but cannot figure out which setting might cause the problem. ...

If you read my previous blog, you might know I am recently working as fire fighter on Maximo BIRT reports. One of requirement on a complicated report is required to retrieve number inside parentheses from long description, for example, need to get (2) from the following long description content: (2) this is long description text, might content rich text format The solution in my mind when I heard this requirement is to use regular expression. Since in current project the Maximo database is DB2, asked Mr. Google to found DB2 did support regular expression in the query. After looked up regular expression functions on DB2 document, REGEXP_INSTR function is what I need. For example, if you run the following query: ...