Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 02-05-2015, 04:53 PM   #1
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
How To hide Group header

Dear All

In my Db , Med. Lab Results
in RptMain
I want HeadSecndGrop is Hide if :
SubName , has one related Service (test).

and
if
i haven't enter all Group members of SubName (like in orderID 1)
Attached Files
File Type: accdb MySubGrps.accdb (756.0 KB, 76 views)

Falcon88 is offline   Reply With Quote
Old 02-06-2015, 08:42 AM   #2
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
Re: How To hide Group header

More Explanation

I have Groups (MainName) , Subgroups (SubName) ,and Items (Services)
Items belongs to Subgroups and subgroups belongs to Groups.

Example.
in MainFrm
if i select (Enter) all the Items (Services) that belongs to the Subgroup "CBC" , as in (order 1).
In RptMain: i want to show Group Header "HeadSecndGrop" .
and
if i select (Enter) some of Items (Services) that belongs to the Subgroup "CBC" , as in (order 2).
in this case in RptMain: i want to hide Group Header "HeadSecndGrop" .

I want to do this in all SubGrpups.

I hope that you may well did you understand my request.

In this attachment ,there are some Amendment.
Attached Files
File Type: accdb NewMySubGrps.accdb (464.0 KB, 43 views)

Last edited by Falcon88; 02-06-2015 at 08:47 AM.
Falcon88 is offline   Reply With Quote
Old 08-07-2015, 11:41 AM   #3
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: How To hide Group header

You are going to need some sort of *trigger* to indicate whether it should show or not. So, do you have something like that in one of your Tables that could serve as a trigger?

Side note, I would also suggest you switch to a Report/Subreport scenario. Just seems a bit much to try to run everything from one query to one report. I can see this leading to issues down the road.

And I would also suggest you get some consistency across your Tables. Field names need to be consistent. As your database grows this will become important.

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 08-07-2015, 01:36 PM   #4
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
Re: How To hide Group header

Please help me as it deems appropriate. do the right construction that you see fit to my database, according to your experience. Please amendment to my database attached above.
Falcon88 is offline   Reply With Quote
Old 08-07-2015, 02:05 PM   #5
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: How To hide Group header

Ahh, no... you need to amend the database and then I can review. Remember this is a Forum and the people, like myself, are unpaid volunteers using our spare time.

Now, I can help you to set up the proper tables but you will create the tables not me. And before we could even do that I would need to understand exactly what business model you are trying to follow.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 08-08-2015, 04:27 AM   #6
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
Re: How To hide Group header

the business model that i trying is a medical lab. db. in a village medical center.
Falcon88 is offline   Reply With Quote
Old 08-08-2015, 05:48 AM   #7
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: How To hide Group header

Okay, then where are the rest of the Tables? Are you doing just the Lab Tests?

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 08-08-2015, 06:50 AM   #8
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
Re: How To hide Group header

i have attached an example that explain my current problem.
Falcon88 is offline   Reply With Quote
Old 08-08-2015, 07:20 AM   #9
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: How To hide Group header

And in Post#3 I told you what you need to do to get the results you want. Have you added a *trigger* to the Table?

Falcon, we are not here to write your database for you. We are UNPAID volunteers here to assist you... period. If you want someone to write your database for you please consider hiring a Developer. However, if you want help then add something to the Table that will be a trigger. The database needs to have some way of telling when/where you want something to show. It only does what you tell it do.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 08-08-2015, 08:50 AM   #10
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
Re: How To hide Group header

Ok Mr GinaWhipp .

I do not know what you mean about " trigger "
i do some changes.
Attached Files
File Type: zip NewMySubGrps.zip (31.9 KB, 34 views)
Falcon88 is offline   Reply With Quote
Old 08-08-2015, 09:01 AM   #11
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: How To hide Group header

There needs to be a field in your Table, like Show - Data Type Yes/No or something along those lines. Then in the report you can use that to determine whether or not the Subgroup Header shows.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 08-08-2015, 09:04 AM   #12
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: How To hide Group header

That file is the same one you already uploaded, nothing for me to do till you make the changes.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 08-08-2015, 10:01 AM   #13
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
Re: How To hide Group header

i add *Trigger*
and add sub report , as you suggest.
Attached Files
File Type: zip NewMySubGrps1.zip (35.8 KB, 34 views)
Falcon88 is offline   Reply With Quote
Old 08-08-2015, 11:32 AM   #14
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,369
Thanks: 21
Thanked 893 Times in 878 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: How To hide Group header

Here you go...

You'll be able to see what I did by looking at the Recordsource of the Subreport.
Attached Files
File Type: zip NewMySubGrps 8.8.2015.zip (53.4 KB, 33 views)
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 08-08-2015, 11:53 AM   #15
Falcon88
Newly Registered User
 
Join Date: Nov 2014
Posts: 188
Thanks: 34
Thanked 0 Times in 0 Posts
Falcon88 is on a distinguished road
Re: How To hide Group header

but the default *Trigger* value is yes.

Falcon88 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide parental header/footer from subreports Sreemike Reports 1 01-21-2012 03:08 PM
Referencing Group Footer Calculated Field in Report Group Header rmoreno Reports 7 03-17-2008 08:15 PM
Group Header spiderghd Reports 7 01-30-2008 02:40 PM
[SOLVED] Group header problem lanye Reports 1 04-09-2005 07:35 AM
hide page header on first page of group Jhitch Reports 0 04-11-2003 08:03 AM




All times are GMT -8. The time now is 11:21 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World