Skip to Content
author's profile photo Former Member
Former Member

Keep Multiple Data elements together

I am using Crystal XI with a MS SQL 2005 database. I'm also new to Crystal. I have created a multi-level drill-down report and have reached a point that I'm stuck. I'm dealing with medical patient data. The relationship of the data is as follows:

There are single Master_Clinics that have multiple Clinics beneath them. Each clinic has multiple patients. Each patient has multiple Standing Orders and each Standing Order has either one or many specified tests. This is my problem area. I have the report set up so that the test or tests defined by each Patient's Standing Orders are in the detail section of the report, because I can't figure out how to get them to stay together within a Group. The problem is that when a particular Standing Order specifies more than one test, the report will not keep the listed tests together. There are more levels beneath this that I need to develop, but each time I add any other data element, the report puts that data between each of the listed Standing_Order_tests, rather than completely beneath them. Any suggestions will be greatly appreciated?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 07:55 PM

    Do standing orders have other things besides tests in them that you need to display separate from the tests? Are there other things besides standing orders that you need to display? If either of these is true, I would have your subreport group on standing order id and then show tests in the details. Link the subreport on Patient ID as Vinay suggested and put the subreport in its own patient group header section. This will show you all tests as related to their standing order.

    Then create similar subreports for any other details that you need to report on, linking on Patient ID and putting each in its own patient group header section. By putting each in its own section, the sections will grow or shrink as needed so that your subreports don't overlap.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 05:27 PM

    Hi,

    Try Inserting Sub-report for displaying the test details and insert a group on patient and display the sub rpeort in the group header of the patient group

    Link teh main report and sub report by the patient id.

    Regards,

    Vinay

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.