View Single Post
  #19  
Old August 1st, 2006, 08:26 PM posted to microsoft.public.access.reports
erick-flores
external usenet poster
 
Posts: 85
Default How can I make a group not to show/display in a report if no data is under that group?


Well I guess I am going to need some coding for my report. What I am
trying to do is a replica of a FoxPro application. This application
produces the same report that I am trying to create. This is what the
groups headers looks like:
^ Page Header
Tag Num
Business Team
^ Group Header 1: cmp_id===================================

Description
^ Group Header 2: stg_id====================================

Description
Components Material
Part#
^ Groups Header 3: cyl_id===================================

Under this group are all the different components that the cylinders
can have. They are all one on top of another, like you can see one line
of data, but if you start moving the texbox you can see that there are
5 texbox one of top of another. So I guess that there is some code
behind this group so I will print only if there is data behind a
particular component
^ Group Header 4: bom.type1 + STR(bom.id1)

Same thing for these group, but this group will show the components
under the cylinder components.
^ Group Header 5: bom.type2 + STR(bom.id2)

Here are the last components under the components from the cylinder
components
^ Detail
^ Group Footer 5: bom.type2 + STR (bom.id2)
^ Group Footer 4: bom.type1 + STR (bom.id1)
^ Group Footer 3: cyl_id
^ Group Footer 2: stg_id
^ Group Footer 1: cmp_id

^ Pafe Footer

I was trying to imitate this report in Access. But now that I know
Access dont more than 10 groups, I guess I need to put some code behind
my Groups (4,5 and Detail). Also if you notice all the arrows for the
groups are pointing up. In Access is the other way, the arrows for the
groups point down.

Do you have any ideas of how to create some code for my groups in
Access? So I can see my report the same as I see it in FoxPro? or
perhaps another complete different way, that will produce the
same/similar results?

Thank you