Adding a field to a query stops generating results

[cru]

Hello:

I have an ireport that generates data from a SQL Query, I needed to add a field in the report (another field from my table) and now I no longer get data - I get a message that the report is empty and aI cannot figure out why adding a field to a select would no longer generate the data for the report. I am using iReport 3.7.1, the strange thing is if I run the query within SQL I get data but when I try to generate the report I get the no data found.

The query is a bit long, however to understand below is the Original query that generates a report, all I need to do is add one field to the select statement: - I.UPROC_LABEL - When I add this field (it was added in the query and on the report layout) the report comes up with NO data. All I need is this extra field and I cannot figure out what I am doing wrong.

PLEASE any help will be GREATLY appreciated, I am pretty desperate.

Code:

Original Query.select d.NODE_NAME, l.MANAGEMENT_UNIT, l.SESSION_NAME, l.UPROC_NAME, l.UPROC_LAUNCH_NO,   (select count(ph_temp.PHASE_ID)   from UNI_REP_PHASES ph_temp inner join UNI_REP_STATUSES st_temp on ph_temp.STATUS_ID = st_temp.STATUS_ID   where ph_temp.LAUNCH_ID = p.LAUNCH_ID      and ph_temp.UPROC_EXEC_NO < p.UPROC_EXEC_NO      and st_temp.STATUS_CODE in ('T', 'I', 'R', 'O')  ) RELAUNCH_NO,   (convert(varchar(10), st_query.START_TIMESTAMP, 103) + ' ' + convert(varchar(8), st_query.START_TIMESTAMP, 108)) START_TIME,   (convert(varchar(10), p.START_TIMESTAMP, 103) + ' ' + convert(varchar(8), p.START_TIMESTAMP, 108)) FINAL_TIME,     s.STATUS_LABEL, oldest_ext.date_val OLDEST_EXT_DATE from UNI_REP_DATASOURCES d   inner join UNI_REP_LAUNCHES l on l.DATASOURCE_ID = d.DATASOURCE_ID   inner join UNI_REP_PHASES p on p.LAUNCH_ID = l.LAUNCH_ID   inner join UNI_REP_STATUSES s on p.STATUS_ID = s.STATUS_ID   inner join (    select ph_temp.START_TIMESTAMP, ph_temp.LAUNCH_ID, ph_temp.UPROC_EXEC_NO     from UNI_REP_PHASES ph_temp inner join UNI_REP_STATUSES st_temp on ph_temp.STATUS_ID = st_temp.STATUS_ID    where st_temp.STATUS_CODE = 'D'   ) st_query on st_query.LAUNCH_ID = l.LAUNCH_ID and st_query.UPROC_EXEC_NO = p.UPROC_EXEC_NO     inner join (    select count(*) cnt, ph_temp.LAUNCH_ID         from UNI_REP_PHASES ph_temp inner join UNI_REP_STATUSES st_temp on ph_temp.STATUS_ID = st_temp.STATUS_ID     where st_temp.STATUS_CODE in ('T', 'I', 'R', 'O')     group by ph_temp.LAUNCH_ID    ) rl on (rl.LAUNCH_ID = p.LAUNCH_ID)     and (((rl.cnt > 1) and ($P{ONLY_RELAUNCHED_JOBS} = 1)) or (($P{ONLY_RELAUNCHED_JOBS} = 0)))  inner join (    select convert(varchar(10), min(ee.START_TIMESTAMP), 103) + ' ' + convert(varchar(8), min(ee.START_TIMESTAMP), 108) date_val     from UNI_REP_EXTRACTIONS ee       inner join UNI_REP_DATASOURCES dd on ee.DATASOURCE_ID = dd.DATASOURCE_ID      inner join UNI_REP_LAUNCHES ll on ll.DATASOURCE_ID = dd.DATASOURCE_ID       inner join UNI_REP_PHASES pp on pp.LAUNCH_ID = ll.LAUNCH_ID       inner join UNI_REP_STATUSES ss on pp.STATUS_ID = ss.STATUS_ID     where dd.COMPANY = $P{COMPANY}      and (dd.NODE_NAME LIKE $P{NODES}          or charindex(','+dd.NODE_NAME+',', $P{NODES}) != 0)       and charindex(','+dd.AREA+',', $P{AREA}) != 0      and (pp.START_TIMESTAMP between convert(datetime, $P{START_DATE}, 103)                                   and convert(datetime, $P{END_DATE}, 103))      and ss.STATUS_CODE in ('T', 'I', 'R', 'O')             ) oldest_ext on 1 = 1where d.COMPANY = $P{COMPANY}    and (d.NODE_NAME LIKE $P{NODES}        or charindex(','+d.NODE_NAME+',', $P{NODES}) != 0)     and charindex(','+d.AREA+',', $P{AREA}) != 0    and (l.MANAGEMENT_UNIT like $P{MU}        or charindex(','+l.MANAGEMENT_UNIT+',', $P{MU}) != 0)    and (((l.APPLICATION is not null) and           (l.APPLICATION like $P{APPLICATION}              or charindex(','+l.APPLICATION+',', $P{APPLICATION}) != 0))         or ((l.APPLICATION is null) and ($P{APPLICATION} = '%')))        and (((l.SESSION_NAME is not null) and          (l.SESSION_NAME like $P{SESS}              or charindex(','+l.SESSION_NAME+',', $P{SESS}) != 0))         or ((l.SESSION_NAME is null) and ($P{SESS} = '%')))    and (l.UPROC_NAME like $P{UPROC}        or charindex(','+l.UPROC_NAME+',', $P{UPROC}) != 0)    and (p.START_TIMESTAMP between convert(datetime, $P{START_DATE}, 103)                                and convert(datetime, $P{END_DATE}, 103))    and s.STATUS_CODE in ('T', 'I', 'R', 'O')order by d.NODE_NAME, l.UPROC_LAUNCH_NO, RELAUNCH_NO, l.SESSION_NAME, l.UPROC_NAME, l.MANAGEMENT_UNIT