where can i get maximoReport datasource driver and steps to design maximo report?

SrinivasaRao

Hi,

I am new to Birt with Maximo.

I have downloaded Birtreport designer2.3.2 from Ibm site to generate maximo reports.

But, i have found need to copy the maximoreport datasourcedriver file in to my reportdesigner to generate report.

Anybody can you please suggest me any links for
1.Where can i download MaximoBirtReportdesigner.
2.What are the steps need to follow to generate report and run report

Waiting for your kind response.


Thanks in advance.


Thanks,
Srinivas.T

maximo9988

We have found that it's less than straightforward to get going with Maximo reports as well. Here are the steps we have taken:

1) Start with a canned report (any of them in <maximo>maximoreportsbirtreports ). Make a copy of that file and open it in BIRT designer.
2) In Data Explorer, under Data Sources, ignore the maximoDataSource, and just create a new Data Source, e.g. named myDataSource. Details here should probably match what is in maximo.properties file. For us, running SQL Server, the Driver Class is com.inet.tds.TdsDriver and Database URL, username, and pword are all the same as in maximo.properties (in fact we truncate the URL after the "database" parameter)
3) Similarly, create a new Data Set, call it what you like, and define your own SQL query to get the data you will want to display. Delete the existing DataSet that was already there for the canned report, as you won't need it anymore.
4) Design your report however you like.
5) While on the layout tab, hover over the report layout until you see the "table" button become available at the bottom left. Click on that.
6) In the "Bindings" tab at the bottom now, select the dropdown for Data Set and select your myDataSet. In some cases we've found that you also need to delete any rows in that Bindings section for data columns that you don't actually use in your report (shouldn't need to do this but seems to cause problems in some cases unless we do).
7) In the "Sortings" tab, delete anything in there that you didn't create yourself. Repeat the same for the "Groups" tab, etc.
8) Click "Preview" and see if it looks correct. If so, you should be able to create the new report template in Maximo, upload that file, click the button to generate the xml, and try executing it (preview button in Maximo).

By no means an expert here so this may or may not work for you, but hopefully it helps you out!