By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Filtering in Sub Report

P: n/a
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.

Jan 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Jan 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.