I am a newbie to crystal report. I am using Crystal report version 9.
I am doing a window application that handle Patients' records using vb.net.Patient particular (name nric…) are stored in a sql database.
What I want to achieve:
I have PatientID, PatientName and Date on FormA, 7 buttons(6 for the 6 questionaires and 1 is "Generate Report " btn). KKSSScore(one of the 6 questionaires) has PatientID, PatientName and Date. After data is key in and click "save" btn. Data (include PatientID and Date) on KKSSScore is save to a sql database.
In FormA i click “Generate Report” btn it will show viewer(another form) where there is a combobox where I can select the type of CR to display and maybe print.
Example PatientName= Cindy, Patient ID =1 and Date= 01/10/2004.
How to generate report for Cindy on this date 01/10/2004. If Cindy came for a second visit on 01/11/2004. i need to generate another set of reports for Cindy. Likewise for other patients.
How to use Patient ID and Date to generate the Crystal reports?
Thank davelye