This page was originally an article on the site to hold a list of common and unique SQL statements. This page is a more permanent spot to reference SQL statements related queries, searches, or reports in IBM Maximo. There are two types of statements listed:
On IBM developerWorks site, a forum question was asked about how to wrap a text field in BIRT that does not contain any spaces.
I would like to know how to wrap data for a field in BIRT report , the wrapping has been set to AUTO . I tried to use …
One of the best ways to clarify information on a BIRT report is to group the information on a key field. This field could the status of the record, who made the request, or the last person to change the record. Normally when you create a group in BIRT, the …
One of the common reporting requests I get is provide a list of the most recent set of records out a series of updates or changes. For example, provide a list of all inventory items that have been added/changed in the previous month or all work orders that were …
It's a simple report. Just a couple of fields. You know it has to churn through a lot of data, but you did everything correct, and BIRT still decides to kick out an error stack. The latest example of this is when I did a simple inventory label report. I …