a paramter passing problem

[nabeelisnabeel]

Hi guyz

Suppose I have a stored procedure which takes one parameter of type 'datetime' named @d. My crystal report calls this procedure to display data. The report has one paramter named @d. The names should be same as of the procedure paramter. Am i right here?

2ndly, what will be the type of the parameter @d of crystal report. Do I have to specify of type date or leave it as of type string.

3rdly, when I right click on some report parameter and click EDIT, then some parameters are un-editable like in the attached image. Why is it so?

[jggtz]

When your data source is a stored procedure w/parameters, is not neccesary to define them in the report. The report automaticly take them

[nabeelisnabeel]

When your data source is a stored procedure w/parameters, is not neccesary to define them in the report. The report automaticly take them

From where the report automatically take them? Do u mean the required parameters are automatically created. If this is the case then the parameter of sql type datetime is shown as of type string in report as in the image...

[nabeelisnabeel]

anybody can elaborate ?

[HairyMonkeyMan]

I believe jggtz is talking about parameters for your stored procedure, but this is different.

Your having trouble setting a parameter value in your report?

Which language are you using? When setting parameters programatically, I use the SetParameterValue method of the reportdocument object.

What code are you using to do this?

[tboley]

I am also having a similar issue. I have an application running (VB.Net Code) using CR11 , I have a stored procedure that requests a parameter(fiscal period) to run a report. The only problems is a receive the following error and donot know how to get around it. Error - ActiveX control '8856f961 -340a-11d0-a96b-00c04fd705a2' cannot be intantiated because the current thread is not in a single-threaded apartment. I am still a beginner and could really use some help and advice if any one has some. Thankyou.