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