<div>
YOu don't load dsr files that way. &nbsp;You can only load rpt files.<br />
<br />
mlmcc
</div>


YOu don't load dsr files that way.  You can only load rpt files.

mlmcc

<div>
changed to .rpt<br />
<br />
still same problem
</div>


<div>
one more thing how to &nbsp;bind record set ( RS ) with CrystalReport1.rpt<br />
<br />
is it ok if i will use following line of code<br />

<pre><code id="code-20-38477395-1">CrystalReport1.SQLQuery = &quot;Select * from RawStock where SleePDate between '&quot; &amp; DTPickerFrom.Value &amp; &quot;' AND '&quot; &amp; DTPickerTo.Value &amp; &quot;'&quot;</code></pre>
</div>


one more thing how to  bind record set ( RS ) with CrystalReport1.rpt

is it ok if i will use following line of code


CrystalReport1.SQLQuery = "Select * from RawStock where SleePDate between '" & DTPickerFrom.Value & "' AND '" & DTPickerTo.Value & "'"

<div>
<div class="content wysiwyg-content">
I have build crystal report in my project.<br />
from vb6 form i am using following code to display report, but &nbsp;getting RunTime Error 20525 &quot;Unable to Load Report&quot;<br />
<br />
and highlighted on &quot;.Action = 0&quot;<br />
<br />
<br />

<pre><code id="code-10-27893487-1">Set Rs = Nothing
If Rs.State = 1 Then Rs.Close
Rs.Open &quot;Select * from RawStock where SleePDate between '&quot; &amp; DTPickerFrom.Value &amp; &quot;' AND '&quot; &amp; DTPickerTo.Value &amp; &quot;'&quot;, con, adOpenKeyset, adLockOptimistic

If Rs.RecordCount &gt; 0 Then

    With CrystalReport1
        
    .ReportFileName = App.Path &amp; &quot;\CrystalReport1.Dsr&quot;
    .Connect = &quot;DSN=crystal;UID=crystal;PWD=crystalABC;DSQ=cryst&quot;
    .DiscardSavedData = True
    .Destination = crptToWindow
    .Action = 0
       
    End With
    
    End If</code></pre>
</div>
</div>


I have build crystal report in my project.
from vb6 form i am using following code to display report, but  getting RunTime Error 20525 "Unable to Load Report"

and highlighted on ".Action = 0"


(CODE)

RunTime Error 20525 &quot;Unable to Load Report&quot;

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.

Crystal Reports

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

RunTime Error 20525 &quot;Unable to Load Report&quot;

RunTime Error 20525 "Unable to Load Report"