Click here to Skip to main content
15,893,337 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
HELLO ALL

I make a project on clinical lab using c#.net,sql srver 2005
so when a new patient comes he will be registered along with their various tests tests
so at the time of registration the data will save in two tables .
actually i have four tables
1. test master (testid,test name,test rate)
2. referral master (docid,doctor_name)
3. registration_test (regid,test_id);
4. new_registration(regid,patientname,age,sex,docid(FK));

now during insertion data will saved in 4th table(new registration)
and 3rd table (registration_test)

now after sucessful insertion
report which hold current regid(max regid), patient name,sex age,test name,test rate ,doctor name from above four tables
on crystal report

how to do that
Posted

Create a stored procedure that selects the information you want from the database, passing the regid as a parameter, then create a crystal report that displays data from the stored procedure.
 
Share this answer
 
hello,

For crystal report kindly refer to this article that i wrote

My Crystal Report Article[^]

Do rate my answer once you find it useful...

Thanks & Regards
Radix :rose:
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900