report with sub reports and a sub sub report...

[misscrf]

I don't know what information you need, so I will direct you to a post that explains my database. You

can look at that if you want to understand anything about my table layout, relationships, forms and their

setup.


thread702-975336

If you skim through you will find screenshots and such...

http://www.geocities.com/misscrf/images/

this will get you to the parent directory of my images. I tried

to name them logically, since I have changed from continuous to single subforms.

Here is the issue. I have a button on my entry form, which is to give the user a quick candidate report,

for the candidate they are viewing.

This report has a control source to the candidate table ( query builded for some formulas)

Then there are subreports for the address, phone and applications. All of them work fine.

Then in the applications subreport, there is an activity subreport. Now when I view the application

subreport on its own, the activities come through somewhat ok. When I view the whole candidate

report, none of the activities show. I have lengthend the report so that there is plenty of room to show

the report.

Also, On the form, the user I would choose for a test report would have 2 applications and 3 activities in

on application. In in the query of the acitivity report, only 3 activities show.. I am so confused.

Besides that, I had to change my subforms to single, because the checkboxes and conditional fields

where showing for every form. I did that, and when I test the navigation, it still does that. Grr.

http://www.geocities.com/misscrf/CandidateHiring.htm

This is a lot to look at, but all of the information for my whole database is available at that url.

If anyone can help me with this report issue or the form issues, I would really appreciate any advice.

Thank you.



misscrf

It is never too late to become what you could have been ~ George Eliot

 

[markphsd]

One of the great things about reports is grouping.

Grouping removes the need for most subreports. I'll give an example:

For a basic Business Contact Report:
You have a report with Contact types. Then you put a subreport that contains the contacts, where a contactID is located in the Contact Table.. The Contacts subreport is placed in the detail section, The main report has a group w/ a header of Contact Type. All the contacts show up under their contact type.

Now, that would work.. but it would be more efficient to just create a query that joined the contact type and contact table, then use that query for the main report, sort on the contact type with a header for contact type and ignore the hold sub report.

Hope that's helpful. From what I read, it looks like the way to go.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[misscrf]

thanks. I think you may have a good idea with the query thing. I am still working on some form issues, but once that section is taken care of, I plan to play around with the query thing. I might just start the reports from scratch!


misscrf

It is never too late to become what you could have been ~ George Eliot