I am using mysql db and tried to associate a report query to a stored proc in the db and it didn't work. For example, in the associate query i simply put call sp_something ($P!{1}, $P!{2}) The SP run fine and the parameter were fine too. However, the results threw Jasper exception in the log window. Any clues folks? Thanks in advance, Shankar