<div>
Maybe your report is not attached to the right DB or theres no data to be shown
</div>


Maybe your report is not attached to the right DB or theres no data to be shown

<div>
Read craefully the whole page this should help<br />
<a href="https://www.experts-exchange.com/questions/20716911/Crystal-report-accessing-using-VB.html" rel="ugc">https://www.experts-exchange.com/questions/20716911/Crystal-report-accessing-using-VB.html</a>
</div>


Read craefully the whole page this should help
https://www.experts-exchange.com/questions/20716911/Crystal-report-accessing-using-VB.html [https://www.experts-exchange.com/questions/20716911/Crystal-report-accessing-using-VB.html]

<div>
currently the report is only showing records, where the field {FACTURA.num_factura} has the &nbsp;value &quot;frmfactura.textbox1.text&quot;<wbr />. you need to place the frmfactura.textbox1.text outside the string literal. <br />
<br />
so try chaning this lineMe.CR.SelectionFormula<wbr /> = &quot;{FACTURA.num_factura}=frm<wbr />factura.te<wbr />xtbox1.tex<wbr />t&quot;<br />
<br />
to something simliar to this if the field value is a number<br />
Me.CR.SelectionFormula = &quot;{FACTURA.num_factura}= &quot;&nbsp;&amp; frmfactura.textbox1.text<br />
<br />
or if it's a string<br />
Me.CR.SelectionFormula = &quot;{FACTURA.num_factura}= '&quot; &amp;&nbsp;frmfactura.textbox1.text &amp;&nbsp;&quot;'&quot;<br />

</div>


currently the report is only showing records, where the field {FACTURA.num_factura} has the  value "frmfactura.textbox1.text". you need to place the frmfactura.textbox1.text outside the string literal.

so try chaning this lineMe.CR.SelectionFormula = "{FACTURA.num_factura}=frmfactura.textbox1.text"

to something simliar to this if the field value is a number
Me.CR.SelectionFormula = "{FACTURA.num_factura}= " & frmfactura.textbox1.text

or if it's a string
Me.CR.SelectionFormula = "{FACTURA.num_factura}= '" & frmfactura.textbox1.text & "'"


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm trying to print a report using Crystral 8. In VB I've this code:<br />
<br />
Private Sub Command1_Click()<br />
&nbsp; &nbsp; Me.CR.SelectionFormula = &quot;{FACTURA.num_factura}=frm<wbr />factura.te<wbr />xtbox1.tex<wbr />t&quot;<br />
&nbsp; &nbsp; Me.CR.Action = 1<br />
End Sub<br />
<br />
Private Sub Form_Load()<br />
&nbsp; &nbsp; Me.CR.ReportFileName = &quot;D:\dev\InFactu\proGym\Rep<wbr />orts\Factu<wbr />ra.rpt&quot;<br />
End Sub<br />
<br />
The problem is that I get the report, but without any data. What wrong / missing.<br />
<br />
Pls help me! &nbsp;Thanks.<br />
<br />

</div>
</div>


Hello,

I'm trying to print a report using Crystral 8. In VB I've this code:

Private Sub Command1_Click()
    Me.CR.SelectionFormula = "{FACTURA.num_factura}=frmfactura.textbox1.text"
    Me.CR.Action = 1
End Sub

Private Sub Form_Load()
    Me.CR.ReportFileName = "D:\dev\InFactu\proGym\Reports\Factura.rpt"
End Sub

The problem is that I get the report, but without any data. What wrong / missing.

Pls help me!  Thanks.



Get the report with crystal 8

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.