I have a crystal report on a web server which is based on a stored procedure with a parameter. I need to capture the value of the parameter from a url that I will be giving to a user to use to link into the report viewer. I have used servername/myintranet/viewername?variable=value and I get server error which states parameter field value not found.

It depends on how you are using the reports viewer; are you trying to directly pass the value into the report? Is it a single value?

If it is a single value you may want to try this:

                        strCurrentValue = Request("someValue")
                        crParamDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue
                        crParamDiscreteValue.Value = strCurrentValue
                        crCurrentValue.Add(crParamDiscreteValue)
                        crDef.ApplyCurrentValues(crCurrentValue)

Where crParamDiscreteValue is type of: CrystalDecisions.Shared.ParameterDiscreteValue
crCurrentValue is type of: CrystalDecisions.Shared.ParameterValues
and crDef is type of: CrystalDecisions.CrystalReports.Engine.ParameterFi eldDefinition

hope this helps.

"The one language all programmers understand is profanity."

thank you I am passing a single value and placing the variable name in the url after the name of the crystal viewer i.e. servername/myintranet/viewername.aspx?variable=value. I understand you to say that the included code needs to go into the code behind of the viewer. I will look forward to further wisdom on this topic from you. Thanks.