Skip to main content
K
kevomac12
Inspiring
October 15, 2015
Answered

How do I use sub reports in ColdFusion Report Builder 10

  • October 15, 2015
  • 2 replies
  • 1104 views

lets say I use the first report to create a cover page, and now I want to in to the Query Builder a sub-report.

This section will handle the next report...is that not correct?

    This topic has been closed for replies.
    Correct answer EddieLotter

    The app has to find accounts and properties, plus the user can add and delete Required Fields based on US Forestry Documents and regulations (EPA).


    Now you're talking about app requirements, but you haven't explained how you want to use multiple queries in a single report. I suspect that's not what you actually need.

    Essentially, each report has one query. To get a parent/child relationship (think of the master/detail paradigm) you use sub-reports. A sub-report is a fully fledged report in its own right, but its purpose is to be embedded within another report. The sub-report's query is usually constrained by values passed to it from the parent report using report parameters.

    See Using Subreports in the documentation for more details.

    Cheers

    Eddie

    2 replies

    K
    kevomac12Author
    Inspiring
    October 15, 2015

    Yes Eddie thank you for filling in my request even though I wasn't clear.

    Yes I want the first page as a cover/title page, and all the rest of the pages to contain the reports and graphs.

    Is it possible to have nine (9) different queries in the .cfr file?

    Kevin

    EddieLotter
    EddieLotter
    Inspiring
    October 15, 2015

    It is possible, but it begs the question: What do you want to do with those nine queries?

    Cheers

    Eddie

    K
    kevomac12Author
    Inspiring
    October 20, 2015

    The app has to find accounts and properties, plus the user can add and delete Required Fields based on US Forestry Documents and regulations (EPA).

    EddieLotter
    EddieLotter
    Inspiring
    October 15, 2015

    You're missing some words in your post, but I'm guessing you're asking about where to place the sub-report in a parent report.

    You can place a sub-report in any band of a parent report. If you place the sub-report in a header or footer band then the sub-report will only be run when the header or footer appears in the final report. For example, if the parent report is the main report and you place sub-report in the report header band, then the sub-report will only ever be run once. If you place the sub-report in the page header band then the sub-report will run once for every page.

    If you place the sub-report in the detail band of the parent report then the sub-report will be run once for every row in the parent report's result set.

    If all you want to do is create a cover-page for the report, use the report header band and make it the same size as (or close to) the report's page size. That way, the rest of the report will follow on subsequent pages. This avoids having to use a sub-report.

    Cheers

    Eddie

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices