Failed to prepare the query execution for the data set

Joe Morgan

Again, new to BIRT... just upgraded to the absolute latest copy of Eclipse Helios with BIRT 2.6.1.

Have a report with 4 parameters, something like this:

select *
from customeranalysis
where clientID = ? and guideID = ?
and date(answerdate) between ? and ?

I therefore have 4 parameters, all mapped to report parameters. The last two are simple dates for begin and end date. The first two are mapped to parameters from other data sets that work just fine, and the values used within the dynamic settings cannot be null, and that restriction is defined within the DB.

So, I use the ID field from the client data set, and display the name. Same with the guide table.

I mapped the parameters named, in order, ClientID (maps to client list report parameter), GuideID (maps to guide list report parameter), BeginDate (maps to beginDate report parameter), and EndDate (maps to endDate report parameter).

When I save the data set for the report, I get the attached error, and, I cannot expand the data set within the Outline View of the report design (also attached).

Joe Morgan

Follow up note: I removed parameters one by one, and it continued to give the error. Once I removed ALL parameters, it no longer gave the error.