By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,687 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Subreport entries repeat in main report

P: 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
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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

P: 3
Thank you!!! The answer was so simple... Appreciate your help.
Sep 12 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thank you!!! The answer was so simple... Appreciate your help.
Not a problem, thats what we're here for.
Sep 12 '07 #4

Post your reply

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