473,395 Members | 1,629 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Subreport entries repeat in main report

3
Hi All---

I have a database where upon a click of a button, I want to see all medications used by a single patient. What I have created is a report that displays medications prescribed at Pharmacy A (PA) and a subreport that shows medications prescribed at Pharmacy B (PB). I want the report to first list out all the PA medications, followed by all the PB medications. However, in the report I have created, each PA med is followed by a listing of PB meds. To illustrate, this is what I want:

PA1
PA2
PA3

PB1
PB2
PB3

etc...

But, this is what I am getting:

PA1
PB1
PB2
PB3

PA2
PB1
PB2
PB3

etc....

Any suggestions on how to remedy this? I am stumped. Happy to answer any questions that may help....

Thanks.
Sep 12 '07 #1
3 1702
MMcCarthy
14,534 Expert Mod 8TB
Hi All---

I have a database where upon a click of a button, I want to see all medications used by a single patient. What I have created is a report that displays medications prescribed at Pharmacy A (PA) and a subreport that shows medications prescribed at Pharmacy B (PB). I want the report to first list out all the PA medications, followed by all the PB medications. However, in the report I have created, each PA med is followed by a listing of PB meds. To illustrate, this is what I want:

PA1
PA2
PA3

PB1
PB2
PB3

etc...

But, this is what I am getting:

PA1
PB1
PB2
PB3

PA2
PB1
PB2
PB3

etc....

Any suggestions on how to remedy this? I am stumped. Happy to answer any questions that may help....

Thanks.
Put both the PA and PB medications in their own sub reports and don't include PA in the main report just the patient details. Link to the subreports with the patient ID/Num.
Sep 12 '07 #2
jkwang
3
Thank you!!! The answer was so simple... Appreciate your help.
Sep 12 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Thank you!!! The answer was so simple... Appreciate your help.
Not a problem, thats what we're here for.
Sep 12 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Michael Charney | last post by:
I have a main report that has a subreport to it. On the sub report I have a running total. If there are no entries in the sub-report source table the sum total returns the #Error message for the...
1
by: Manal/report designer | last post by:
Thank you in advance for any suggestions... I'm using crystal reports version 8 & SQL server. I've created a report that is composed of 2 parts: 1st part contains the main report which uses...
2
by: Eddie Smit | last post by:
Hi all, I created a main report with a subreport. I want to display this subreport 8 times but with different data. (I do that with subreport.RecordSource = "sqlstring") HOW do I set this...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
1
by: shaqattack1992-newsgroups | last post by:
I know this is kind of a weird question, but is there anyway to give a subreport control of a main report? I posted my situation earlier about having drawings print out after a group. I have a...
3
by: lorirobn | last post by:
Hello, I have a report which uses a subreport. When I run the report, I get "Enter Parameter Value" error message for "tblGuestRoom". I click ok and the report seems to work fine. I...
3
by: Coll | last post by:
I have a report that I run every quarter. When I opened it this quarter, one of the subreports is not displaying. No error message - just nothing displays where the subreport data should be. If you...
11
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RowSource of a Master Report is: Me.RowSource = "TableOrQueryName"
0
by: EManning | last post by:
Using 2003. I've got a main report with a subreport and within that subreport is another subreport, all bound. The detail in the 2nd subreport is repeated multiple times for some reason. The...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.