pe********@gmail.com wrote:
I have a Report A, which compute daily sales.
Example:
Date: 18 Jan 06
Pen - 4 pieces
Ruler - 5 pieces
Pencil - 7 pieces
Date: 19 Jan 06
Pen - 3 pieces
Ruler - 5 pieces
Pencil - 2 pieces
Another sub report, Report B, which compute the average sales.
Report A and B, both uses a same query
I need to combine Report A and B to form Report C.
Report C:
The main content is from Report A, displaying the Daily Sales over a
period (monthly)
At the Report Footer of Report C, i need to display the average sales
which is Report B, with the same period used for Report A.
I cannot figure out a way to do it.
Any suggestions?
Thank You.
You provide no reason to have report C, which basically is a combination
of A and B. Unless you need to keep them separated.
You also provide no reason why the report B, in C, fails. So I'll be a
"great seer" and divine your reason for failure. Maybe it's because the
report footer is a poor place to put ReportB. I don't think report
footers grow or if they do they may not have the length to grow much.
So here's how I would handle it. I use this tip for creating
multi-column reports. I add another column to the query. In your case,
add one to report A. Call it Master:"M" for example. Now, under
Grouping/Sorting in the menu I create a new group called Master. I
create a footer for the MasterBand. (for multicolumn reports I create a
header and put my column heading(s) there). In the footer band for
Master drop the subreport.