Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Report and sub report

I’m using Access 2003; I have a report in my database which has a sub report on it.
I use this for keeping track of family drugs. Who is taking what and so forth. I the main report I have a listing of all the drugs for that family member. At the top of the report is where the sub report is. This report only shows the names of the doctors for that member only. My question is how to hide the sub report for all the members of the family except for dad. So when I print the report for my dad it show doctors name but when I print it for others I don’t want the sub report to show. Can this be done?
Thanks for any help.
0
cdb424ttm
Asked:
cdb424ttm
  • 3
  • 2
1 Solution
 
Bob LambersonSoftware EngineerCommented:
It should be a simple matter of excluding the information you don't want, from your data source for the report. If you could post the code you are using, might be able to help a little easier.

Bob
0
 
NBrownohCommented:
What are you using to print the report out, Crystal, ms access, visual basic reports?  

If your using crystal reports or vb reports you can easily edit the sql string limiting what the detail section of the report gets to print to the report.
0
 
cdb424ttmAuthor Commented:
using access 2003 NBrownoh
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
cdb424ttmAuthor Commented:
no answer on this pelase give not points and close question out.
Thanks
CDB
0
 
Bob LambersonSoftware EngineerCommented:
The answer to your question is Yes it can be done.
0
 
Bob LambersonSoftware EngineerCommented:
If you would like to respond to the comments I'm sure someone can give you the help you apparently need.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now