Passing values to a report

[paladin127]

I am running Crystal Enterprise 10 Embedded edition and am trying to run a report from ASP. I am using the following code:
*************************
<%
reportname = "wmsal001.rpt"
%>
<!-- #include file="AlwaysRequiredSteps.asp" -->
<%

Set NewValue = objFactory.CreateObject("CrystalReports.ParameterFieldDiscreteValue")
NewValue.Value = 1
Set TempParam = objFactory.CreateObject("CrystalReports.ParameterField")
ClientDoc.DataDefinition.ParameterFields.Item(0).CopyTo TempParam
TempParam.CurrentValues.Add NewValue
ClientDoc.DataDefController.ParameterFieldController.Modify ClientDoc.DataDefinition.ParameterFields.Item(0), TempParam

%>
<!-- #include file="CrystalReportsViewer.asp" -->
******************************

This works fine but when I modify the 'NewValue.Value = 1' line to read 'NewValue.Value = request.form("SiteID")' , I get the following error:

*******************************
Error Type:
webReporting.dll (0x80004005)
Error in File C:\WINNT\TEMP\{FC91B826-6F0A-46FA-96E1-93BA3A048629}.rpt: The specified value type is different to the current value type.
/reports/CrystalReportsViewer.asp, line 20
*********************************

I am new to this so I'm not sure if there is a way to pass variables from another web page via it's form fields.

Any ideas?

 

[paladin127]

Found the Problem.

Turns out it was variable type problem. Used the following line with success:

NewValue.Value = CInt(request.form("SiteID"))

Need to make sure the variable is of matching type.

 

[lyanch]

sorry wrong pdf...

http://support.businessobjects.com/communityCS/TechnicalPapers/ce8_urlcommands.pdf.asp

has the commands.

It says 8 and 8.5 but they still work for 9, at least mine do.

Lisa