Crystal Report设计中的五个表数据集 [英] Five tables dataset in Crystal Report designing

问题描述

我在一个数据集中有5个表，该数据集是用这5个名为
的表设计的
1.Patient(LABID，PatientName，Age，RelativeName，EntryDate，EnterBy，Email，PUID，CashReceiptNo，TotalAmount，PaidAmount，Balence)
2.ResultMaste(LABID，TestID，结果，Opnion，Coments，ReferenceRanges，DelDate，TestStatus，ReadytoPrint，Charges，异常，VerifiedBy，EnterBy)
3.ResultMicrscopy(LABID，TestID，PusCell，RBC，SquCell，CocciGram，Bacilligram，AFB)
4.ResultParmeter(LABID，TestID，TPID，ParmeterName，结果，异常)
5.ResultSensitivity(LABID，TestID，Organisam，药物，敏感性)

病人与ResultMaster(mondatry)有一对多的关系，
ResultMaster与ResultParmeter具有一对多关系，
ResultMaster与ResultMicrscopy和
有一对多的关系 ResultMicrscopy与ResultSensitivity具有一对一的关系

我想在pageheader部分及其子表数据的详细信息部分显示患者字段，但对于每个患者，我想要一个单独的页面.

如何为这些表设计Crystal Report.没有子报表，可以吗?

请帮助我.

I have 5 table in a dataset and the dataset is designed withe these five tables named

1.Patient(LABID,PatientName,Age,RelativeName,EntryDate,EnterBy,Email, PUID, CashReceiptNo , TotalAmount, PaidAmount, Balence)
2.ResultMaste( LABID, TestID, Result, Opnion, Coments, ReferenceRanges,DelDate, TestStatus, ReadytoPrint, Charges, Abnormal, VerifiedBy, EnterBy)
3.ResultMicrscopy(LABID, TestID, PusCell, RBCs, SquCell, CocciGram, Bacilligram, AFB)
4.ResultParmeter(LABID, TestID, TPID, ParmeterName, Result, Abnormal)
5.ResultSensitivity(LABID, TestID, Organisam, Drug, Sensitivity)

Patient have one to many relationship with ResultMaster (mondatry),
ResultMaster have one to many relationship with ResultParmeter,
ResultMaster have one to many relationship with ResultMicrscopy and
ResultMicrscopy have one to one relationship with ResultSensitivity

i want patient fields on pageheader section and its child''s tables data in detail section, but for each patient I want a separate page.

How to design Crystal Report for these tables. Is it possible with out subreport?

Please help me some one.

推荐答案

您的项目听起来真的很深入而且很复杂.您不太可能会找到可以为您设计此报告的人.如果您需要帮助，则需要分解您的问题. 我该如何设计"太含糊了.另外，请告诉我们您已经尝试过的内容.如果您还没有开始，那么要做的一件好事就是研究一些有关Crystal Reports的文章，以了解它们的工作原理.您可以在代码项目文章 [ ^ ].

您是否在数据库专家中设置了关系?如果没有，您可能需要进行研究.

您是否对Crystal Reports中的分组进行过任何研究?您可能对此很感兴趣.在分组专家中，还有一个共同的属性称为之后的新页面"，我将其与分组一起使用，以确保页面上只有我的一个主要项目(在您的情况下，每页一名患者).
希望这可以帮助您入门.

Your project sounds really in-depth and complicated. It''s not likely that you are going to find someone who will design this report for you. If you want some help, you need to break down your question. "How do I design this" is just too vague. Also, let us know what you have tried already. If you haven''t started, a good thing to do is research some articles about Crystal Reports to get an idea of how they work. You can find a bunch of help in the Code Project Articles[^].

Have you setup the relationships in the Database Expert? If not, you may want to research that.

Have you done any research into Grouping in Crystal Reports? That may be of interest to you. There is also a common property in the Section Expert called "New Page After" which I have used along with grouping to make sure only one of my main items is on a page (in your case one patient per page).

Hope this helps you get started.

这篇关于Crystal Report设计中的五个表数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！