Hello,

Is there a way to create a basic report embedding several other basic subreports? Based on the nature of the data, by using independent basics subreports would satisfy then nature of this request.

Thanks
Tony

This may be approached in several different ways but I'm not sure exactly what you are trying to do. Can you explain further?

What format of report do you require? If it's HTML, then it's very easy. You create your "sub reports" as format HTMTABLE and then imbed them in an HTML page with !IBI.FIL.sub-report-hold-file-name;

You could also do a compound report.

My apologies. If possible, I would like the report in adobe, but HTML would be just fine.

The report consists of of the following

Month To Date
Market NetSales PriorMonth %toPrior
Domestic $8000 $10000 80%

Quarter to Date
Market NetSales PriorQuarter %toPrior
Domestic $8000 $10000 80%

Year to Date
Market NetSales PriorYear %toPrior
Domestic $8000 $10000 80%


7 fields total in a cross-tab format. The subreports have already been created

The compound report tool should work fine for this type of report. But since your data looks to be the same in all three reports you could try doing a MATCH FILE or MORE.

Thank you all very much. Let me give it a try.

Hi,

I have a similar issue with subreports. I have a report that has a detail portion and a grand total. On the original report (crystal), 1 field on the grand totals is a subreport (data from a completely different table). How do I do this in WebFOCUS.

Here's a sample code:
TABLE FILE CAR
PRINT
COUNTRY
CAR
DEALER_COST
RETAIL_COST
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE SUMMARIZE AS 'TOTAL'
END

I would like to get the data for the grand total row for retail_cost(45,319) from another table (value for example could be 45,333). The dealer_cost grand total stays as it is. How do I do it? Do a use an Amper Var?

Thanks.

This message has been edited. Last edited by: dballest,

You could use an amper variable but you'd probably have to put the other file total in a subfoot, not the automatically generated total line. Then use the stylesheet to line them up properly.

Thanks for the reply Ginny. Looks like there would be extra work on the alignment part. I give it a try.