c#.net中的水晶报表 [英] crystal report in c#.net

问题描述

HELLO ALL

我使用c#.net，sql srver 2005在临床实验室中进行了一个项目.
因此，当新患者来临时，他将与他们的各种测试一起注册.
因此在注册时，数据将保存在两个表中.
其实我有四个桌子
1.测试主(testid，测试名称，测试率)
2.推荐主(docid，doctor_name)
3. registration_test(regid，test_id);
4. new_registration(常规，患者姓名，年龄，性别，医生(FK));

现在，在插入过程中，数据将保存在第4个表中(新注册)
和第三张表(registration_test)

现在，在成功插入后
上面四个表格中包含当前登记(最大登记)，患者姓名，性别，年龄，检查名称，检查率，医生姓名的报告
关于水晶报告

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

推荐答案

创建一个存储过程，从数据库中选择所需的信息，将regid作为参数传递，然后创建一个显示数据的水晶报表来自存储过程.

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.

你好，

对于水晶报告，请参考我写的这篇文章

我的Crystal报告文章 [ ^ ]

一旦发现有用，请对我的回答进行评分...

谢谢&问候
基:rose:

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:

这篇关于c#.net中的水晶报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！