Simple ASP w/Crystal Viewer for 8.0 Multi parameter

eparker57 · April 16th, 2010, 11:34 AM

I need help in getting a multi parameter to a Crystal Report 7.0 via Crystal Viewer used normally for 8.5. Don't laugh. We're way behind. We are not using asp.net just simple asp that's edited with notepad. There are two parameters to the report. A date and one other one that can take one or more values. When I send the date (prompt0) and one value for prompt1, the report displays data. When I send 2 values in prompt1, it doesn't display anything. The multi parameter is set up as multi, discrete values as a string. Here's the code:

Code:

function RunLNlogsheet(opt){
	var pubdate = "";
	
	var url = "reports/AdPower/LNlogsheet3ep.rpt?user0=sysname&password0=Pass123&promptOnRefresh=1&";

	var parm0;
	var parm1;
	var frm;
	var errstr = "";

	<!--var selIdx = 0; -->			
	var bc = "";
	
	frm = document.frmLNlogsheet;
	
	var selected = new Array()
	var index = 0;
	for (var intLoop=0; intLoop < opt.length; intLoop++){
		
		if (opt[intLoop].checked) {
	
			index = selected.length;
			selected[index] = new Object;
			selected[index].value = opt[intLoop].value ;
			selected[index].index = intLoop;
			
		}
	}

	var strSel = "";
	for (var item in selected) { 
		if (strSel!="") strSel += ", ";
    		strSel += selected[item].value;
		
	}	
		
	
	bc = strSel;
	alert ("Selected Items:\n" + bc);

	<!--selIdx = frm.selPubCodeA.selectedIndex; -->
	<!--bc = frm.selPubCodeA.options(selIdx).value;-->
	
	

	errstr = VerParmDate( frm.insert_date.value );

	parm0 = "prompt0=" + CrystalDate(frm.insert_date.value);
	parm1 = "&prompt1=" + bc;

	if ( errstr == "0" ){
		
		url = url + parm0 + parm1;
		window.open(url,"wnewboxes");
	}
	else{
		alert( errstr );
		return;
	}
}

I've tried wrapping the multi-value values in quotes and ticks. Then a single value doesn't work. I've tried just putting quotes between the multi-values so the prompt1 looks like RES", "LO. Nothing seems to work. Do you all have some ideas for a real novice?