Jump to content
Changes to the Jaspersoft community edition download ×

IReport UNION Query Not displaying the field names


Annamap

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...