INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

access report dynamic rollup

access report dynamic rollup

(OP)
Hello,

I am trying to create report where each ID can have 1 to 10 designators. Each designator has a small report required. I tried a single report with all 10 and it is 4 pages long. If an ID has only 3 designators can a report be created to print only the 3 needed on one page? Sort of a rollup where the un-needed parts of the report do not print. Sub-reports need a single page for each. Can these be rolled onto a single page?

RE: access report dynamic rollup

ID, designators, un-needed parts, ...? Please post using technical, generic terms that we understand.

Duane
Hook'D on Access
MS Access MVP

RE: access report dynamic rollup

(OP)
ok,

Member A has 3 out of 10 possible memberships. The report needs to show the 3 levels member A has. Then member B, C and so forth with each corresponding membership. Each membership needs 4-6 inches of space on the report. Is this better?

RE: access report dynamic rollup

Are the levels in a subreport or part of the main report record source?

Are levels the same as memberships?

Are there sections and controls that are set to Can Shrink?

Duane
Hook'D on Access
MS Access MVP

RE: access report dynamic rollup

(OP)
Yes, each membership level is currently in a seperate subreport.

To better understand;

smith - Pool
gym
tennis

Jones - Pool
tennis
golf
beach

Then each, such as pool, will have a number of questions. Mr Jones can not have questions for gym on his report.

Hope this help clarify. I will check on the shrink setting.

RE: access report dynamic rollup

So, is Pool the same "level" as gym, tennis, golf, and beach or is it something else?

Duane
Hook'D on Access
MS Access MVP

RE: access report dynamic rollup

(OP)
Perhaps attribute would descirbe better than level. Driven from the member table there are 10 attribute boolean fields (t/f). With each attribute having its own subreport. I don't want a seperate page for each subreport so this may be be the best way to set it up.

RE: access report dynamic rollup

If I understand, you have a main report record source that contains 10 boolean fields and there are separate subreports that relate to each of these. If a boolean field is false, you don't want to display the subreport.

If you don't want separate pages for each subreport, you shouldn't add page breaks.

Duane
Hook'D on Access
MS Access MVP

RE: access report dynamic rollup

(OP)
Yes, that is correct.

RE: access report dynamic rollup

You can add some code in the On Format event of the main report section containing the subreports like:

CODE --> vba

Me.srptTennis.Visible = Me.chkTennis = -1 

Duane
Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close