Report not retrieving any data in Maximo

Hi All,

I'm not able to see any data in the report while running in Maximo. Where as I could run the report successfully in Eclipse and data is populated as expected.

Please let me know if anything to be modified to fit in Maximo.

Thanks,
Suresh.

Find more posts tagged with

Comments

vijay_kota

hi,

Is your report taking filter criteria from maximo application as a where clause...??

If yes try to print the query which gets appended during the run time in maximo...

wwilliams

Have you tried to display your query in the header of the report? I have seen this a few times where it runs fine in Eclipse, but not in Maximo. All times Maximo added another equal sign in my query.

-Wes

peraka

<blockquote class='ipsBlockquote' data-author="'wwilliams'" data-cid="101281" data-time="1337870522" data-date="24 May 2012 - 07:42 AM">
Have you tried to display your query in the header of the report? I have seen this a few times where it runs fine in Eclipse, but not in Maximo. All times Maximo added another equal sign in my query. 
 
-Wes </blockquote>
 
Hi Williams, I have tried to print the query in eclipse. It's working fine. Could you please let me know how to print in Maximo header. 
 
Do I need to add other dataset. 
 
Thanks, 
Suresh.

vijay_kota

Hi Suresh,

Attaching one .rptdesign file which designed in 2.3.2.

This will give you an idea how you can print query.

Deploy this report in maximo.

Run the report for your filter criteria.

Even though report doesn't give any o/p, it will print the entire query.

Analyse the query you will be able find some thing.

wwilliams

I am sure there are many ways, but I create a global variable in the initialize method. 
In my open method of the dataSet just above maximoDataSet.setQuery(sqlText)I just make that variable equal to sqlText, then place the variable in the header and it should display the SQL when the report has run. 
Also have you added an equal sign like this? 
<pre class='_prettyXprint _lang-auto _linenums:0'>MXReportSqlFormat.createParamWhereClause("pol.storeloc","=" + params["location"].toUpperCase())</pre>
 
If so remove it and re-import and see if it runs correctly,