Skip to Content
author's profile photo Former Member
Former Member

Generate Multiple Copies of a Subreport

Hi all,

I have a report that has 4 sections in the report header. Each of those sections contain only a subreport. Each of the subreports is a one page form. All other sections of the report are suppressed.

The main report has parameters that are used to suppress the various report header sections so that only the desired forms are included in the report.

What I need to accomplish now is to be able to generate multiple copies of the various subreports. For instance, 1 copy of the subreport in report header a, 3 copies of the subreport in report header b, and suppress report headers c and d.

The first thing I would expect to do is to change my report parameters and replace the current boolean flags with an integer count for each of the subreports. Given that, does anyone have any suggestions on how I can get the various subreports to print the number of times specified by the parameters?

Thanks,

David

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 03:51 PM

    Split section into many sections as required to achive max number of copies.

    Insert same subreport into each section.

    In section Expert suppress depending on number entered into your parameter for number of copies.

    Ian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Jamie Wiseman

      Hi Jamie,

      I think I see where you are going with this. To set up for this I need to define a table in my database that has a single int column. There needs to be enough rows in the table to account for the total copies of all subreports. (i.e. if 3 copies of subreport a, 2 copies of subreport b, 6 copies of subreport c, and 0 copies of subreport d then the table needs to have at least 11 rows in it.) I could limit the number of rows returned by implementing a record selection formula that limits the value of the integer column to Sub1 + Sub2 + Sub3 + Sub4, or 11 in my example.

      Getting creative with the section suppression formulas, you could also add a flag to collate. So you could print:

      Sub a

      Sub b

      Sub c

      Sub d

      Sub a

      Sub b

      Sub c

      Sub d

      OR

      Sub a

      Sub a

      Sub b

      Sub b

      Sub c

      Sub c

      Sub d

      Sub d

      Yes, very creative solution. Thank you.

      David

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.