IBM Support

Using Date Ranges with QBR reports in Maximo 7

Technote (FAQ)


Can we use start and end dates as filters with QBR?


The QBR creation tool doesn't seem to allow the use of greater than or less than operators.


To implement Date Range filters in QBR, do the following.

1. Create your QBR, but do not include the Date field as a parameter. Be sure to save.

2. In Report Administration, locate the entry for your new QBR report.

3. Add 2 new Parameters titled 'Enter Start Date' & 'Enter End Date'. Set the Attribute to the Date field in question. Set the operator to <= and >= respectively.

4. You can also add the lookup 'datelookup' so that the user can select the dates from a calendar tool.

5. Save and rebuild the Request page XML.

If you have any difficulty implementing this, please open up a PMR with Support and we can assist.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Maximo Asset Management Report Admin Platform Independent 7.1.1, 7.5 All Editions

Document information

More support for: Maximo Asset Management
Report Admin

Software version: 7.1.1, 7.5

Operating system(s): Platform Independent

Software edition: All Editions

Reference #: 1470557

Modified date: 12 February 2013

Translate this page: