I am sure this is possible. What is the best method for creating nested sub reports? I want for each row in the parent report, several child reports under the parent. An example is below where each customer has a nested sub report for orders and invoices. The only relationship between this data is the customer row ID.

Customer A (Table A)
Nested Report 1 - Customer Open Orders (Based on Cust_id param) (Table B)
XX YY ZZ
XX YY ZZ
XX YY ZZ

Nested Report 2 - Customer Invoice Documents (Based on Cust_id param) (Table C)
AA BB CC
AA BB CC
AA BB CC



Customer B (Table A)

Nested Report 1 - Customer Open Orders (Based on Cust_id param) (Table B)

XX YY ZZ
XX YY ZZ
XX YY ZZ

Nested Report 2 - Customer AR Documents (Based on Cust_id param) (Table C)
AA BB CC
AA BB CC
AA BB CC


So how can I exec two canned reports for each row in the parent report?

TIA,

Steve

Steve, how about a drilldown from your customerid in your principal report, with multiple choices for which report the user wants next.
Is it that your parent report presents the customer id's?
you can drill down from a customer id, and either (a):
give both ORder and INvoice reports on one page for the selected customerid
or(b):
give the user a choice of whichreport they want to run,either orders or invoices, and have two separate reports.
Which way do you want to go?
If (a), then write your fex to produce both reports , using
ON TABLE HOLD AS MYTAB1 FORMAT HTMTABLE
...more fex
ON TABLE HOLD AS MYTAB2 FORMAT HTMTABLE
..
END
and then at the end of your fex
-RUN
-HTMLFORM BEGIN
< !-- WEBFOCUS TABLE MYTAB1 -->
< !-- WEBFOCUS TABLE MYTAB2 -->
-HTMLFORM END

If (b), then lookup the feature DRILLMENUITEM to see how to do multiple choice drill downs.

What the users wants is best described as automatically drilled down. It's as if you had the list of customers with a drilldown on the ID but the drilldown happens automatically with both secondary reports displaying after each Customer ID row.

oh, so you want to loop by a customer list,
and for each customer id, print 2 reports.
right?
1. you can do just that...have your customer ids print out to a flat file, then -READ that file, and for each CUSTID that you read from the file, create 2 reports . (your customer list file is made in the agent and stays in the agent, no electronic clutter)
or..
2. you can use FML to create wildly different looking paragraphs from a single data set, but that hurts my head.
..If you need any help setting up -READ, just holler.

...but that hurts my head. So does reading from a file for me
I wish the product would let me do it in DevStudio Report Painter bt drag and drop.
Thanks for your info. Looping will have to do for now.

A true GUI report tool will allow a creation of "n" reports that take 1 or more parameters. These should then be able to be dropped onto the design space and allow each row on the main report to call each sub-report to display it's data for the current row in the main report. Putting data to a flat file for looping is 80s technique and very inefficient from a design perspective.

Perhaps a compound PDF report with drillthrough (summary report serving as TOC for detail reports below) is what you're looking for.

I believe the detail reports can be produced in a single report request, using REPAGE. So there would be no need for dialog manager looping.

Hi

I think you can achieve it using developer studio GUI -> (PDF)composer , use the feature for coordinated reports,
as long as the first BY field is the same for all reports , in your example, customer id, webfocus will automatically create all reports per customer id
This works in PDF, DHTML, AHTML

It seems a little odd that your first post is a criticism. How about posting a question about how to do something - we may be able to answer that.