Multiple reports on same page

[technonurse]

I am trying to create a report for prescriptions to print. I want to populate the page with 4 separate reports so that if 4 different medications are ordered on the patient, the 4 different meds show up on the same page divided into fourths. What I'm getting now is a mirror image from left to right so that two meds print twice. Any ideas? Technonurse-Spokane

 

[synapsevampire]

Perhaps if you show sample data, including the tables used and the type of joins, and the desired output someone can more readily help you.

It sounds like you may want the Format with multiple columns (right click the details section and check it), but it's hard to say without having more to go on.

You want to avoid using 4 different reports as this will be much slower.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[technonurse]

Thanks for responding. The links are equal joins. The tables being used have a one-t0-many relationship. The construct of the report is as follows:

{Patient name} * {Patient_name}
{medication_order} * {medication_order}
{med_sig} * {med_sig}
{med_quantity} * {med_quantity}
{refills_ordered} * {refills_ordered}

I want the report to populate two different medications side-by-side. I went into the section and clicked the columns option and still got the mirroring effect. The same medication showed up on the left and right sides.
Technonurse-Spokane