P
PC
I have a report that has 2 subform/subreports nested in
it. These are working just fine and giving me the info
that I expect them to. I'm not sure if I have done
this "correctly" but the report is functioning as I wish
it to.
My new problem is that I wish to futher filter the data
that is displayed in the subreports and cannot figure out
how to do this. I think I am trying to do a subquery but
cannot get it working.
Here is the scenario-Each report/subreport is being
driven by its own query.
The overall report shows the school. Each school may have
some associative PHASE 1 or 3 costs. My subreports break
these out respectively. So, for any school, if there is
only Phase 1 costs, the Phase 3 data does not show at
all. What I would like to do for either PHASE subreport
is filter for say, a given consultant or that is user
selectable via a combo box. So I think the "question"
would be "Show me all schools (or just this school) and
their Phase 1 or 3 costs that are using Consultant x"
How can I filter or subquery my subreports?
Thanks in advance!
PC
it. These are working just fine and giving me the info
that I expect them to. I'm not sure if I have done
this "correctly" but the report is functioning as I wish
it to.
My new problem is that I wish to futher filter the data
that is displayed in the subreports and cannot figure out
how to do this. I think I am trying to do a subquery but
cannot get it working.
Here is the scenario-Each report/subreport is being
driven by its own query.
The overall report shows the school. Each school may have
some associative PHASE 1 or 3 costs. My subreports break
these out respectively. So, for any school, if there is
only Phase 1 costs, the Phase 3 data does not show at
all. What I would like to do for either PHASE subreport
is filter for say, a given consultant or that is user
selectable via a combo box. So I think the "question"
would be "Show me all schools (or just this school) and
their Phase 1 or 3 costs that are using Consultant x"
How can I filter or subquery my subreports?
Thanks in advance!
PC