G
Guest
Basically, I'm trying to get a report with a subreport to print all records
with the same system (TypeOfSystem) to print on the same page according to
the week and service I have selected. I access the report from a form which
applies a query as the source. The query shows all the correct records but
the report doesn't come out as desired. It was suggested that I remove all
links between the report and subreport except for the Type of System. This
puts the records in the desired format, however, it will not distinguish
between the week and system. What would be the best way to go about this????
There's examples of what I'm trying to achieve listed below, plus, I've
attached all of my past correspondence so you can get an idea of what I'm
trying to achieve and what has been suggested. I feel like I"m so close to
resolving this issue and just need a little guidance on how to finish
up....Thanks!
*******************************
Okay, I've been trying some different things...If I remove all the links, I
get a report with each type of system but with all the systems for that
customer listed....So I added the type of System to the link, than I get the
correct report. Except now, it doesn't differentiate between weeks or
service. So when I click on my form to open all reports for week 1, it
brings up every system for each customer regardless of if they are serviced
in week 1. The same thing happens with TypeOfService, it now brings up all
systems regardeless that I've specified that I want only systems serviced
with an A or an S to be on the report (see original question for example of
what I'm trying to achieve)....If there is a way for me to apply my filter to
the report as it is now, I think my question will be answered. Is this a
possibility?????
I feel like I"m getting closer to resolving this issue so I really
appreciate your time and ideas.
with the same system (TypeOfSystem) to print on the same page according to
the week and service I have selected. I access the report from a form which
applies a query as the source. The query shows all the correct records but
the report doesn't come out as desired. It was suggested that I remove all
links between the report and subreport except for the Type of System. This
puts the records in the desired format, however, it will not distinguish
between the week and system. What would be the best way to go about this????
There's examples of what I'm trying to achieve listed below, plus, I've
attached all of my past correspondence so you can get an idea of what I'm
trying to achieve and what has been suggested. I feel like I"m so close to
resolving this issue and just need a little guidance on how to finish
up....Thanks!
*******************************
Okay, I've been trying some different things...If I remove all the links, I
get a report with each type of system but with all the systems for that
customer listed....So I added the type of System to the link, than I get the
correct report. Except now, it doesn't differentiate between weeks or
service. So when I click on my form to open all reports for week 1, it
brings up every system for each customer regardless of if they are serviced
in week 1. The same thing happens with TypeOfService, it now brings up all
systems regardeless that I've specified that I want only systems serviced
with an A or an S to be on the report (see original question for example of
what I'm trying to achieve)....If there is a way for me to apply my filter to
the report as it is now, I think my question will be answered. Is this a
possibility?????
I feel like I"m getting closer to resolving this issue so I really
appreciate your time and ideas.