Contact US

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.

Students Click Here

Avoiding running endless sub-reports

Avoiding running endless sub-reports

Avoiding running endless sub-reports

Here is my problem: I have a main table that contains lots of information on grant applications. Linked to this table is another table that links to the first table by a unique 6-digit identifier number and contains about 50 keyword fields. Each keyword field contains either a "1" or a "0" -- and any linked grant application can have a lot of different keywords attached to it.

When I run a report listing the identification numbers and organization names for one group of keywords (e.g., the 14 different kinds of project purposes), I have no choice by to run a main report that simply runs 14 sub-reports. In the printed output, each subreport looks like a group, with a header and a bunch of applications listed.

The same is true if I run a report showing the applications from the 13 different types of organizations (e.g., community-based, economic development, k12 schools, museums, etc.) One report, 13 time-consuming sub-reports.

Is there a way to get around this? At the moment, I have five shell reports and something like 50 subreports defined. Is there some way to set up a formula or an array in the main report that simply goes through a list of values and runs a subreport in which the principle of selection is (valueX=1)? It seems awfully wasteful to define 50 or more sub-reports, when the only difference among them is that the selection criterion is (valueX=1).

Do I have a choice? I remember from earlier database management programs that there was some function called FOREACH, and it would run a procedure, substituting each value listed under the FOREACH statement until it had run out of values. Does this work in SCR?

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! Already a Member? Login

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