Five tables dataset in Crystal Report designing

Question

1.00/5 (1 vote)

See more:

VS2008

, +

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.

Posted 30-Oct-11 0:32am

sher ali

Updated 30-Oct-11 3:02am

Nueman

v3

Add a Solution

Comments

Nueman 30-Oct-11 9:03am

Spelling, punctuation, capitalization, readability.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Kschuler · Answer 1 · 2011-11-11T11:09:00

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.