|
hello i have made an application for a certain clinic,the patient come to the clinic and makes some tests in the laboratory of the clinic,some tests have two properties Result and referencerange but another tests have another properties(such as for the urine test has Appearence,color,PH,Nitrite,Protein,Glucose),in the application i have made a crystal report and inside the cystal report i have made a stored procedure that takes an input which is the casenumber of the patient and returns the result and the referencerange,i have made a table in SQL server that contains three fields(TestName,Result,ReferenceRange),my question is to display the date in the crystal report like this:
TestName Result: ReferenceRange: ------------- -------- ---------------- Waalor rose 12 1254
TestName Appearence color ------------ ------------- ----- Urine good yellow
so how can i solve the problem shall make a table which contains all the properties of all the tests and i display the properties of the tests in the cystal report as follows:
TestName Result: ReferenceRange: Appearence color ----------- -------- ---------------- ------------- ------ Waalor rose 12 1254 urine good yellow
but i see the above crystal report is more best,but how can i make this? thank you for the time and for the help
|