Maximo Wire - The IBM Maximo Help & Discussion Forum
May 20, 2012, 10:08:14 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to Maximo Wire, the IBM Maximo help forum. Feel free to register and ask any Maximo related questions you like.
 
  Home Help Search Login Register  
*
Pages: [1]   Go Down
  Print  
Author Topic: how i can differ maximo table identifier when running report  (Read 937 times)
0 Members and 1 Guest are viewing this topic.
janhavi
Newbie
*

Karma: 2
Posts: 19


View Profile Email
« on: September 28, 2010, 09:34:29 am »

Hi friends,

when i provide a condition in where clause of maximo and run it, it shows me records according to that like
WHERE (historyflag = 0 and siteid = 'XYZ' and totalcost > 2800.0)

it will show me the list of records.but when i run the report from select action it taks like this
( ( po.historyflag = 0 and po.siteid = 'XYZ' and po.totalcost > 2800.0 ))


suppose if i have built one report using view ex. PO_view (of PO table) and when i will run this report from maximo application like purchase order, it will gives me error because it takes table identifier automatically(here is PO).

now my question is how i can append this table identifier to run that view based report from maximo??

please suggest me,


Regards
janhavi
Logged
Ethen
Global Moderator
Sr. Member
*****

Karma: 16
Posts: 302



View Profile WWW
« Reply #1 on: September 28, 2010, 03:31:42 pm »

never happened to me. I have run hundres of reports but it always takes the query specified in the report.

are we talking about different reports.. I am talking about actuate.
Logged

regards,

Ethen...
janhavi
Newbie
*

Karma: 2
Posts: 19


View Profile Email
« Reply #2 on: September 28, 2010, 07:11:49 pm »

Hi,

yes i m running crystal reports from maximo
Logged
Ethen
Global Moderator
Sr. Member
*****

Karma: 16
Posts: 302



View Profile WWW
« Reply #3 on: September 29, 2010, 03:36:39 pm »

no idea about crystal report..
Logged

regards,

Ethen...
Pages: [1]   Go Up
  Print  
 
Jump to:  

Recent

TinyPortal v1.0 beta 4 © Bloc
Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!