Join Data Sets and Script

sweetcrash

Hi

I have a problem with the join data set, in my report I greated to data set and a joind data set with both tables.

Then in my java class I am setting a parameters like this:

setSQL(" where historico.fecha!='' and productos.johnson=true");

so in the jsp I have embebed the report to pass the parameter.

my problem is where to put the script, I can no put in the join data set so I am using the historico data set like this:

this.queryText = this.queryText + params["sql"];

so I am getting an error beacuse the productos.johson I am not sure how or where to put the correct where clause

Thanks in advance

mwilliams

Hi sweetcrash,

Is one of the parameters for one dataSet and the other for the other dataSet? Or do they both limit just one of the dataSets you used in the joint dataSet?