Patman Posted October 4, 2006 Share Posted October 4, 2006 I have probably a simple problem which is nevertheless a challenge for me: The statement couloured in purple seems not to be correct. My intention is to exclude the records where Storniert_am = empty / no entry. In the report it shows null in this case. Storniert_am is a date field. SELECT * from Belegung b left join Adresse a on b.Belegempfaenger = a.Nr where Von > {d '2006-9-1'} and Storniert_am = null order by Objekt, Von Thanks for your help! By the way: Is there somewhere a repository of examples of SQL statements for iReport which I can use as templates? Link to comment Share on other sites More sharing options...
lucianc Posted October 4, 2006 Share Posted October 4, 2006 You might want to try Storniert_am is null. HTH,Lucian Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now