<div>
But, I can point the WHERE to a Parameter rite? If this is not true, may I know how?<br />
As I see I only have the option of &quot;is equal to&quot; or something like that.<br />
<br />

</div>


But, I can point the WHERE to a Parameter rite? If this is not true, may I know how?
As I see I only have the option of "is equal to" or something like that.



<div>
Found the solution, Thanks.<br />

</div>


<div>
Glad i could help<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to set a new data source for my Crystal Report Subreport. But, in the SQL string, it's something like this<br />
SELECT * FROM tblRelationship WHERE ClientID = {?MainClientID}<br />
Where {?MainClientID} is a param that pass value from the Main Report.<br />
<br />
And during VB runtime, we need to change the database connection<br />
&nbsp; &nbsp; rs_main.Open strsql2, DB_CONN, adOpenStatic, adLockReadOnly<br />
&nbsp; &nbsp; rs_sub1.Open strSql, DB_CONN, adOpenStatic, adLockReadOnly &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; m_report.Subreport1.OpenSu<wbr />breport.Da<wbr />tabase.Set<wbr />DataSource<wbr /> rs_sub1<br />
<br />
&nbsp; &nbsp; m_report.Database.SetDataS<wbr />ource rs_main<br />
<br />
So, now the problem come from, I can't directly set the SQL String to the mySQL as they will not accept {?MainClientID} . May I know how can I solve this?
</div>
</div>


Hi,

I need to set a new data source for my Crystal Report Subreport. But, in the SQL string, it's something like this
SELECT * FROM tblRelationship WHERE ClientID = {?MainClientID}
Where {?MainClientID} is a param that pass value from the Main Report.

And during VB runtime, we need to change the database connection
    rs_main.Open strsql2, DB_CONN, adOpenStatic, adLockReadOnly
    rs_sub1.Open strSql, DB_CONN, adOpenStatic, adLockReadOnly        
       
    m_report.Subreport1.OpenSubreport.Database.SetDataSource rs_sub1

    m_report.Database.SetDataSource rs_main

So, now the problem come from, I can't directly set the SQL String to the mySQL as they will not accept {?MainClientID} . May I know how can I solve this?

How to include Param in the SubReport SQL connection via VB?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.