How To hide Group header
- Thread starter Falcon88
- Start date
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.
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.
Last edited:
GinaWhipp
AWF VIP
- Local time
- Today, 12:55
- Joined
- Jun 21, 2011
- Messages
- 5,899
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.
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.
GinaWhipp
AWF VIP
- Local time
- Today, 12:55
- Joined
- Jun 21, 2011
- Messages
- 5,899
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.
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.
GinaWhipp
AWF VIP
- Local time
- Today, 12:55
- Joined
- Jun 21, 2011
- Messages
- 5,899
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.
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.
