Question about Crystal Report in vb.net

R

Ray

Hi all,
I am a new user of vb.net. I would like to ask how to choose one record
from sql database in vb.net and only show that record in the crystal report.
Now, I only know how to bind the sql database in crystal report and show all
the records.
Is there any reference web site describing this?

Thanks a lot,
Ray
 
L

Lucas Tam

I would like to ask how to choose one record
from sql database in vb.net and only show that record in the crystal
report. Now, I only know how to bind the sql database in crystal
report and show all the records.
Is there any reference web site describing this?
Click to expand...

Just do a simple Select WHERE
 
J

Jorge

Hi Ray

You can also use:

formula = "{Table.Field}='" & Var1 & "'"
crReportDocument.RecordSelectionFormula = formula

Formula, Var1, table.field are string and
crReportDocument is the report your are using.

Kind Regards
Jorge
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pass a parameter from vb.net to Crystal Report 1
Crystal Reports in VB.NET Express Edition 4
Vb.net 2008 Crystal Reports - Boolean parameter field issue 2
HTML report in vb.net 1
Filtering a Crystal Report by date using the SelectionFormula 0
Crystal Report + Vb.net 1
Question about Connection to SQL 3
Vb.net Running crystal reports issue - differing output 1

Top