<div>
are you setting the value? also how do you use this parameter? in a select query?
</div>


<div>
Yes, value set, I checked that and select query look like this:<br />
SELECT &nbsp;* &nbsp; &nbsp;from memo m <br />
&nbsp;where m.memo_userid = &lt;% myParam1|enter user id|'ALL'%&gt; 
</div>


<div>
but where do you set the value of this parameter?<br />
i see you create a parameter, set its properties (but not the value, so value should be null by default) and query uses ALL because you never provided a value for your parameter
</div>


<div>
here is a sample i found on net<br />
<br />
you are missing <br />
<br />
myParam1.DefaultValue = &quot;This is myParam1 default value&quot;<br />
<br />
<a href="http://www.datadynamics.com/Help/ActiveReports6/arHOWAddParameters.html" rel="ugc">http://www.datadynamics.com/Help/ActiveReports6/arHOWAddParameters.html</a><br />

<pre><code class="code-1 nolinks" id="code-1016948"><span>Dim myParam1 As New Parameter()</span>
<span>myParam1.Key = &quot;myParam1&quot;</span>
<span>myParam1.Type = Parameter.DataType.String</span>
<span>myParam1.PromptUser = True 'set to False if you do not want input from user</span>
<span>myParam1.Prompt = &quot;Enter last name:&quot;</span>
<span>myParam1.DefaultValue = &quot;This is myParam1 default value&quot;</span>
<span>Me.Parameters.Add(myParam1)</span>
</code></pre>
</div>


<div>
I did not type it here, I checked with a messagebox, value is not null<br />
<br />
Parameter myParam1 = new Parameter();<br />
myParam1.Key = user_id;<br />
myParam1.Value = s_user;<br />
myParam1.Type = Parameter.DataType.String;<wbr /><br />
myParam1.PromptUser = false;<br />
this.Parameters.Add(myPara<wbr />m1);<br />
I saw that sample it is for VB lower there for C#<br />

</div>


<div>
so you added this code to <br />
<br />
Double-click in the gray area below the report to create an event-handling method for the ReportStart event. <br />
Add code to the handler to change the data source at run time. <br />
<br />
if you add this into ReportStart, then it should be fine... 
</div>


<div>
<div class="content wysiwyg-content">
I placed SQL code in a datasource &nbsp;field of my report and<br />
put the following code in ReportStart event<br />
<br />
Parameter myParam1 = new Parameter();<br />
myParam1.Key = user_id;<br />
myParam1.Type = Parameter.DataType.String;<wbr /><br />
myParam1.PromptUser = false; <br />
this.Parameters.Add(myPara<wbr />m1);<br />
<br />
But datasource does not receive parameter at all.<br />
Could anybody tell what should I do?
</div>
</div>


I placed SQL code in a datasource  field of my report and
put the following code in ReportStart event

Parameter myParam1 = new Parameter();
myParam1.Key = user_id;
myParam1.Type = Parameter.DataType.String;
myParam1.PromptUser = false; 
this.Parameters.Add(myParam1);

But datasource does not receive parameter at all.
Could anybody tell what should I do?

ActiveReports with paramerters in C#

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).