Actuate "invalid identifier" error

[gammoncs]

I have a simple report that is designed to list records from the maximo.ticket table.  I have published the report in Maximo 6.2.2 under the SR application and report tab.  The report has 3 parameters (a start date, an end date, and a siteid).  When I run the report without a site id, the report runs correctly showing all sites.  However, if I enter a single site id, I get the following message.  "Status No: 1 : Basic Error: 1011 Module: afc\db.bas Line: 193 Database Error 2: Error generated by the connected data source ... 904: ORA-00904: "SR"."SITEID": invalid identifier ".  It looks like it is substituting the application id (SR) for the table name (ticket) when it tries to run the query.  Any thoughts or ideas on how to resolve this?  Thanks.

[Ethen]

not sure how you can do it.
however you can create a inner join between SR and Ticket in your report and make it work.

[Yesterday]

• Not able to access the ma... by Dileep Kumar [Yesterday at 06:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]
• Data insertion in Work Or... by Sarbjeet.Jassal [May 09, 2012, 09:06:53 am]
• Want userdefined name whi... by G Jeevan [May 08, 2012, 10:43:40 am]
• my newly created continio... by G Jeevan [May 08, 2012, 10:41:22 am]
• All User Account unable t... by bphome [May 03, 2012, 05:09:47 pm]