Dynamically Adding Sub-Report into Main Report

[f15e]

I don't know if this is possible but hoping someone could steer me in the right direction. I want to be able to create a new report and then insert it into an existing main report all done dynamically. The main report currently has 8 sub-reports in it. I believe I can create a new report but I'm not sure how to then insert it to the bottom of the the main report.



To give a little background on why I'm trying to do this:
I have created a Structural Weight Control Report Database. The sub-reports within the main report are based on an Area and computations, graphs, reports, etc., can be generated from the DB. For example, an offshore platform that consists of different areas such as Main Deck, Cellar Deck, Heli-Deck, etc. I want to allow a user to be able to add a new Area to the DB and when the new area is created, a sub-report is dynamically created and then inserted at the bottom of the last sub-report in the main report. Like I said, I don't know if this is even possible but hoping someone can tell me if it is or not and maybe some pointers on how to do it.

Thank you.

[ranman256]

i would have the subreports already there and invisible.
when I want one to show
subRptCellar.visible = forms!myForm!chkCellar.value

[f15e]

Thanks for your reply ranman256.
Cellar was just an example. In reality, I would not know ahead of time what new area the user would add and therefore could not have a subreport available and hidden ahead of time. It is not practical to have a subreport for every possible area plus the name of the areas may differ depending on Client. This is the reason I am asking about creating these subreports from scratch programmatically and then adding it as the last subreport in the Main Report.