Zucker report parameters

[kavita]

as per my project need.. [in jasper report template] i want to provide parameter to report.

scenario :With the help of Parameter Binding in Zucker reports i have made two combo box .. when i select option from first combo , options related to first combo should be displayed in second combo (from database).I tried this by writing a user-defined query in the second parameters edit view but im not getting the output.

eg first combo has country like India,China,etc .Then in second combo states of the country selected should be displayed in dropdown list .
Suppose i select India then states under India like Rajasthan, Punjab, Maharashtra etc should be displayed in the second combos dropdown list.

u have any solution for this..
Plzzzzzzzzzz help.

reply.

[genius786]

Hi,

You have to make changes in code to make this types of combo boxes.


Best regards,

[kavita]

Thank you for the reply..but, i have already created the combo box through parameter binding option in zucker reports...i want the dynamic parameter of the first combo box so as to populate the second combo box with the filtered values..plz help

[elsadsis]

Oh!!oh!!oh!!oh!!oh!!oh!!oh!!oh!!oh!!oh!!oh!!oh!!oh !!

[genius786]

Hi,

I told you it is not possible, or if you want to do you have to change in code.


Best regards,

[alewin]

That is easy, you have to use javascript. Here's an example of what I did loading content for my installations combo based on a textbox with the account. You need to add the code in the correspondent php file. Note that the method named addEvent is not in the code because is in my funciones.js file.
I have added this code to the display() method in the editview. You can use jquery to simplify.
Cheers.
echo '<script src="include/javascript/funciones.js" type="text/javascript" ></script>';
echo '
<script type="text/javascript">
function loadInstalations(){
loadForAccount("getInstalaciones")
}
function loadForAccount(fn){
var parametros = new Array(document.getElementById("account_id").value) ;
ServerRequest("handleRequest.php", fn, parametros);
}
function retornoRequest(respXML){
var root = respXML.firstChild;
if(root!=null){
switch(root.nodeName){
case "instalaciones":
procesarRetorno(root, "instalacion_c", "instalacion");
break;
}
}
}
function procesarRetorno(root, htmlElement, xmlElement){
var s = document.getElementById(htmlElement);
clearSelect(s);
if(root.hasChildNodes()){
var list = root.getElementsByTagName(xmlElement);
if(list!=null){
for(i=0; i<list.length; i++){
addToCombo(htmlElement, list.item(i).childNodes[0].childNodes[0].nodeValue, list.item(i).childNodes[1].childNodes[0].nodeValue);
}
}
}
}
function clearSelect(select){
var largo = select.length;
for(i=0; i<largo; i++){
select.removeChild(select.item(0));
}
}
function addToCombo(combo, valor, texto){
var select = document.getElementById(combo);
var option = document.createElement("OPTION");
option.value = valor;
option.text = texto;
try{
select.add(option, null);
}
catch(ex){
select.add(option);
}
}
var objInstalacion = document.getElementById("instalacion_c");
addEvent(objInstalacion,loadInstalations, "onfocus");
</script>';

[kaisar]

2 kavita: Try to create 1 bind parameter.
For example, in your combo: India, Rajasthan
then
India, Mumbai
then
India, Punjab