Filtering Sub-Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am trying to implement a sub-report into a Function Costing report which
shows all costs for a particular function.
I need a sub-report to show a "Recovery and Contra" breakdown and total. I
have used the "subreport wizard" in Access 2000, but I only get ONE record or
ALL of the records. Obviously I need to filter the records to relate to the
FunctionID number so that it will display a breakdown for that particular
Function. However, its not working, what is the exact filter syntax i need to
use and which settings in the subreport wizard do i need?
If you need any more information about my problem ill be happy to provide it.
Thanks in advance.
 
Hello "Ashg657" (or may I say Ashg?)

Ashg657 said:
Hi,
I am trying to implement a sub-report into a Function Costing report
which shows all costs for a particular function.
I need a sub-report to show a "Recovery and Contra" breakdown and
total. I have used the "subreport wizard" in Access 2000, but I only get
ONE record or ALL of the records.
Click to expand...

Configure the LinkChildFields and LinkMasterFields properties of the
subreport control in your report. Therfore, a "FunctionID" field must be
contained in the query the subreport is based on.
Obviously I need to filter the records to relate to the FunctionID
number so that it will display a breakdown for that particular Function.
Click to expand...

The two properties mentionned above do the filtering for you.
 
Just call me "Ash". :-)
Thanks for the help, just one more thing.
When you launch the subreport wizard, am i correct in saying that the data
source MUST come from a query or table rather than a form?
For my problem mentioned earlier,would you do a query and then use that as
the controlsource or use the table which contains the data?
Thanks again in advance.
 
Hello Ash..g657. :-)

Ashg657 said:
Just call me "Ash". :-)
Thanks for the help, just one more thing.
When you launch the subreport wizard, am i correct in saying that the
data source MUST come from a query or table rather than a form?
Yes.

For my problem mentioned earlier,would you do a query and then use
that as the controlsource or use the table which contains the data?
Click to expand...

If the data needed for the report is the data in a table, use the table.
If you need data from other tables or filtering, build a query.
 
Back
Top