Annamap

Thank you Buddy.

Hi All I am new to IReport. I have a situation here that I am not able get the field names for an SQL query with UNION operator in the IReport tool. The field names are blank and I am not able to design the report. Please help me in solving this problem of IReport with UNION SQL Query. My Query is: SELECT DISTINCT GRANTEE WHERE GRANTEE='ANNAMAP' UNION SELECT DISTINCT GRANTEE WHERE GRANTEE='POORNI' The field name GRANTEE is not appearing in the jasper report. Thanks and Regards, Poornima.A

Hi All I am new to IReport. I have a situation here that I am not able get the field names for an SQL query with UNION operator in the IReport tool. The field names are blank and I am not able to design the report. Please help me in solving this problem of IReport with UNION SQL Query. My Query is: SELECT DISTINCT GRANTEE WHERE GRANTEE='ANNAMAP' UNION SELECT DISTINCT GRANTEE WHERE GRANTEE='POORNI' The field name GRANTEE is not appearing in the jasper report. Thanks and Regards, Poornima.A