Filtering Sub-Reports

[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.

 

[Wolfgang Kais]

Hello "Ashg657" (or may I say Ashg?)

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.

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.

The two properties mentionned above do the filtering for you.

 

[Guest]

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.

 

[Wolfgang Kais]

Hello Ash..g657.

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?

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.