IReport UNION Query Not displaying the field names

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
Annamap's picture
Joined: Aug 15 2006 - 3:23pm
Last seen: 16 years 9 months ago

0 Answers:

No answers yet
Feedback