Hi guys I'm having problem in crystal report where my inner join is a success but of my 3 fields that are affected dowsn't show up. The values from 2 tables that match is showing on the crystal report but the 3 fields that has a match doesn't. Tried inputting a formula where 2 fields on each tables are equal to each other. When I did that I saw in my report preview it's okay but when I run the program it gives me an error: This field is not know Details: errorKind.
Problem solved I just need to use some alias to match my records from the fields in crystal report because of using join the field name will have a prefix of their table thus changing its field name and not showing in the cystal report. No need to use formula
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...