Member Avatar for jjerryjenson 
i am having four combo boxes.the item in the combo box is taken from the database.we select the data whatever we want and clicking the submit button report want to be displayed.
While selection in the combo boxes, they may select all the fields sometimes they may select one fields and so on.i want to display records according to the selection.to display records i am using jasper i-report.
front end: JSP back end : My SQL
The problem is in the i-report i can write only one query, i cannot check condition sometimes some field may empty or null.

please send me the query so that i can check null values(ie. if the field is null it want to select all the data regarding that field) and select regarding the data.
  • 4 Contributors
  • 3 Replies
  • 116 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by marck_don
Member Avatar for sn4rf3r 
SELECT * FROM table WHERE column IS NULL
Member Avatar for jabeen1

Great one and its solved my problem

Member Avatar for marck_don

Use the COALESCE function:

COALESCE(Email, 'no email')

Edited by Ezzaral because: Snipped "fake sig" link. Please restrict such links to your site-wide user signature, which can be edited from the user control panel.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.