Populate data Crystal Report from a query

Posted by Selom on Stack Overflow See other posts from Stack Overflow or by Selom
Published on 2010-03-28T14:08:06Z Indexed on 2010/03/28 14:13 UTC
Read the original article Hit count: 558

Filed under:
|
|

hi big bro and sis, Im having a problem with how to display data using crystal report programmatically and need your help.

Im using vb.net for my project. I have a form that I called reportFrm on which I put the CrystalReportViewer1.

I also added the CrystalReport1.rpt to my project and the CrystalReport1.rpt contains a textbox called firstname.

i would like that when the reportFrm loads, it makes the following query and to fetch the firstname and put it in the textbox firstname:

query: Dim cmd As New SQLiteCommand("SELECT * FROM personal_details JOIN studies USING staff_ID WHERE staff_ID = '" + detailsFrm.Label13.Text + "'", conn)

my problem is that Im fetching data from two different tables and I don't how to do this. Thanks for helping

© Stack Overflow or respective owner

Related posts about crystal

Related posts about report