Creating a Row Number in a Grouped Detail

I've been working on a way to review with my power users how they've setup their Start Centers. The goal was to ensure suggested Start Center setups were in place and to see if any custom setups should be shared with other sites. This required getting a snapshot of what …

Common SQL Server Statements for Maximo

SQL Statements

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:

  • SQL Server Function …

Adding Custom Sort Order in BIRT

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 …

Using 'rank over partition' in BIRT reports

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 …

Top