Dears,

 

When I navigate through the reports from UI view (by simply click on report items in the browser), the report will be displayed properly ..

But when I use "Show Query" with "Query Editor" to run the same SQL query, all values will be displayed as "Not Assigned" !!

 

for this I've already collected the SDP logs, and I see lots of java exception will be throw :

 

[13:00:33:691]|[05-15-2013]|[com.adventnet.servicedesk.utils.DBUtilities]|[INFO]|[26]|: Database Connection is requested : Generate SQL report.|
[13:00:33:791]|[05-15-2013]|[SYSOUT]|[INFO]|[26]|: java.sql.SQLException: Column 'WORKORDERID' not found.|
.

.

[13:00:33:795]|[05-15-2013]|[SYSOUT]|[INFO]|[26]|: java.sql.SQLException: Column 'TITLE' not found.|
.

.