Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 16th, 2010, 11:34 AM
Registered User
 
Join Date: Apr 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Red face Simple ASP w/Crystal Viewer for 8.0 Multi parameter

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?




Similar Threads
Thread Thread Starter Forum Replies Last Post
Error with Crystal Reports Viewer in ASP.NET jaucourt Crystal Reports 2 February 24th, 2012 03:39 PM
problem with crystal activex viewer in asp.net NagarajuK Crystal Reports 0 November 22nd, 2007 10:20 AM
asp.net with crystal activex viewer NagarajuK Crystal Reports 0 November 22nd, 2007 10:17 AM
Help needed Crystal Reports ASP and ActiveX Viewer ros1188 Classic ASP Professional 17 January 28th, 2005 11:24 PM
Crystal 10 Viewer ASP.Net reprompts for parameters klgrube Crystal Reports 0 November 7th, 2004 02:16 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.