Hi i am using IReport/Jasper Reports and I have mastered inserting parameters into the SQL. Can anyone tell me if it is possible to insert optional parameters into the SQL that a user may or may not select EG SELECT * FROM CAT {WHERE USERSELECTION = 1} The problem with the only way i know at the moment is you would be left with the where clause even if the user did not use the parameter, i would expect you to be able to wrap the whole where clause in the property statement as above. Thanks Neil Musgrove
