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
 
Ad

Advertisements

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?

Just do a simple Select WHERE
 
Ad

Advertisements

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

Top