Filter report by report

  • Thread starter Thread starter Eka1618
  • Start date Start date
E

Eka1618

Hello, I have two reports and the second I will need to be filtered from the
first.

In my first report (Single Key Test Summary), It brings up a list of all
tests that are have a particular REQUEST_NO. Each records that appears is a
different type of test(i.e.-Impact, Static). Each test type will have it's
own kinds of test result & summaries. The test summary information is on the
second report. I have a report for each type of test since each summary will
have show different information.

What happens in the first report (Single Key Test Summary), is that in the
details area, I have placed a button that will open up the report that
matches the test type shown in that current record. This part works. What is
not working is that I am trying to filter the second report so that it only
shows information with the current test queue ID (Q_INC). In the filter
section of this report I have tried the following statement:

[Q_INC]=Reports.[Single Key Test Summary].Q_INC

I had an earlier design which was working, but it has stoped filtering and I
get all of the records on the second report.

I'm trying to explain this the best way I can. These reports must be
seperate from one another because each test is different and I was having
difficulty combining the different types of information on the report because
each record was spitting out information that was wrong.... For instance, if
I had a request that had an Impact, and Static test, each record in the
second report would give me information on both types of tests (even if there
was nothing to show).

I can explain this more if this it too confusing (hopefully it wasn't)
Please let me know if anyone has any suggestions on how i can filter the
second report. Thank you!

~Erica~
 
You should be doing this in the second report's record source query. If you
create a record source query for the second report that uses field necessary
to filter the record source the same way the record source for the first
report is filtered, that will solve your problem.
 
Dave,

The first report is filtered by the user being prompt to enter the request
number. However, Q_INC is an autonumber PK. They do not know this information
and that is why I want them to beable to just click on the button and
generate the report using whatever value is stored in the Q_INC field for
that particular record at the time the button is clicked.

I do not understand why it stoped working though, I changed the first form
just a little bit and now the filter statement in the second form does not
work. I've tried putting the statement in the criteria section of my query
(Like [Reports].[Single Key Test Summary].[Q_INC]) but it does not work... It
seems that it will just not grab the value from the report weather I have the
field enabled or not.

Maybe I just do not know how to write the statement. Is it different that
when you refference a forms field?

~Erica~




Klatuu said:
You should be doing this in the second report's record source query. If you
create a record source query for the second report that uses field necessary
to filter the record source the same way the record source for the first
report is filtered, that will solve your problem.
--
Dave Hargis, Microsoft Access MVP


Eka1618 said:
Hello, I have two reports and the second I will need to be filtered from the
first.

In my first report (Single Key Test Summary), It brings up a list of all
tests that are have a particular REQUEST_NO. Each records that appears is a
different type of test(i.e.-Impact, Static). Each test type will have it's
own kinds of test result & summaries. The test summary information is on the
second report. I have a report for each type of test since each summary will
have show different information.

What happens in the first report (Single Key Test Summary), is that in the
details area, I have placed a button that will open up the report that
matches the test type shown in that current record. This part works. What is
not working is that I am trying to filter the second report so that it only
shows information with the current test queue ID (Q_INC). In the filter
section of this report I have tried the following statement:

[Q_INC]=Reports.[Single Key Test Summary].Q_INC

I had an earlier design which was working, but it has stoped filtering and I
get all of the records on the second report.

I'm trying to explain this the best way I can. These reports must be
seperate from one another because each test is different and I was having
difficulty combining the different types of information on the report because
each record was spitting out information that was wrong.... For instance, if
I had a request that had an Impact, and Static test, each record in the
second report would give me information on both types of tests (even if there
was nothing to show).

I can explain this more if this it too confusing (hopefully it wasn't)
Please let me know if anyone has any suggestions on how i can filter the
second report. Thank you!

~Erica~
Click to expand...
Click to expand...
 
Sorry, but I have never even considered using a report's recordset to filter
another's. I would just use the value the user entered to do the filtering
for the second report as well.
--
Dave Hargis, Microsoft Access MVP


Eka1618 said:
Dave,

The first report is filtered by the user being prompt to enter the request
number. However, Q_INC is an autonumber PK. They do not know this information
and that is why I want them to beable to just click on the button and
generate the report using whatever value is stored in the Q_INC field for
that particular record at the time the button is clicked.

I do not understand why it stoped working though, I changed the first form
just a little bit and now the filter statement in the second form does not
work. I've tried putting the statement in the criteria section of my query
(Like [Reports].[Single Key Test Summary].[Q_INC]) but it does not work... It
seems that it will just not grab the value from the report weather I have the
field enabled or not.

Maybe I just do not know how to write the statement. Is it different that
when you refference a forms field?

~Erica~




Klatuu said:
You should be doing this in the second report's record source query. If you
create a record source query for the second report that uses field necessary
to filter the record source the same way the record source for the first
report is filtered, that will solve your problem.
--
Dave Hargis, Microsoft Access MVP


Eka1618 said:
Hello, I have two reports and the second I will need to be filtered from the
first.

In my first report (Single Key Test Summary), It brings up a list of all
tests that are have a particular REQUEST_NO. Each records that appears is a
different type of test(i.e.-Impact, Static). Each test type will have it's
own kinds of test result & summaries. The test summary information is on the
second report. I have a report for each type of test since each summary will
have show different information.

What happens in the first report (Single Key Test Summary), is that in the
details area, I have placed a button that will open up the report that
matches the test type shown in that current record. This part works. What is
not working is that I am trying to filter the second report so that it only
shows information with the current test queue ID (Q_INC). In the filter
section of this report I have tried the following statement:

[Q_INC]=Reports.[Single Key Test Summary].Q_INC

I had an earlier design which was working, but it has stoped filtering and I
get all of the records on the second report.

I'm trying to explain this the best way I can. These reports must be
seperate from one another because each test is different and I was having
difficulty combining the different types of information on the report because
each record was spitting out information that was wrong.... For instance, if
I had a request that had an Impact, and Static test, each record in the
second report would give me information on both types of tests (even if there
was nothing to show).

I can explain this more if this it too confusing (hopefully it wasn't)
Please let me know if anyone has any suggestions on how i can filter the
second report. Thank you!

~Erica~
Click to expand...
Click to expand...
Click to expand...
 
Well I just do not understand how I was able to get it to work once, and now
it does not work. I never changed anything about the second report at all...
I didn't even change the first one as far as using Q_INC is concerned. It
will just not read the value out of that field from the first report. if I
type in the number its looking for, my report loads fine, I just need to
figure a way to grab that value from that record...

Thanks anyway, if you think of anything else please let me know.

~Erica~

Klatuu said:
Sorry, but I have never even considered using a report's recordset to filter
another's. I would just use the value the user entered to do the filtering
for the second report as well.
--
Dave Hargis, Microsoft Access MVP


Eka1618 said:
Dave,

The first report is filtered by the user being prompt to enter the request
number. However, Q_INC is an autonumber PK. They do not know this information
and that is why I want them to beable to just click on the button and
generate the report using whatever value is stored in the Q_INC field for
that particular record at the time the button is clicked.

I do not understand why it stoped working though, I changed the first form
just a little bit and now the filter statement in the second form does not
work. I've tried putting the statement in the criteria section of my query
(Like [Reports].[Single Key Test Summary].[Q_INC]) but it does not work... It
seems that it will just not grab the value from the report weather I have the
field enabled or not.

Maybe I just do not know how to write the statement. Is it different that
when you refference a forms field?

~Erica~




Klatuu said:
You should be doing this in the second report's record source query. If you
create a record source query for the second report that uses field necessary
to filter the record source the same way the record source for the first
report is filtered, that will solve your problem.
--
Dave Hargis, Microsoft Access MVP


:

Hello, I have two reports and the second I will need to be filtered from the
first.

In my first report (Single Key Test Summary), It brings up a list of all
tests that are have a particular REQUEST_NO. Each records that appears is a
different type of test(i.e.-Impact, Static). Each test type will have it's
own kinds of test result & summaries. The test summary information is on the
second report. I have a report for each type of test since each summary will
have show different information.

What happens in the first report (Single Key Test Summary), is that in the
details area, I have placed a button that will open up the report that
matches the test type shown in that current record. This part works. What is
not working is that I am trying to filter the second report so that it only
shows information with the current test queue ID (Q_INC). In the filter
section of this report I have tried the following statement:

[Q_INC]=Reports.[Single Key Test Summary].Q_INC

I had an earlier design which was working, but it has stoped filtering and I
get all of the records on the second report.

I'm trying to explain this the best way I can. These reports must be
seperate from one another because each test is different and I was having
difficulty combining the different types of information on the report because
each record was spitting out information that was wrong.... For instance, if
I had a request that had an Impact, and Static test, each record in the
second report would give me information on both types of tests (even if there
was nothing to show).

I can explain this more if this it too confusing (hopefully it wasn't)
Please let me know if anyone has any suggestions on how i can filter the
second report. Thank you!

~Erica~
Click to expand...
Click to expand...
Click to expand...
 
I didn't say it wouldn't work. I just meant I wouldn't do it. I see too
many possibilities for errors and problems. Thus, the source of your
question.
--
Dave Hargis, Microsoft Access MVP


Eka1618 said:
Well I just do not understand how I was able to get it to work once, and now
it does not work. I never changed anything about the second report at all...
I didn't even change the first one as far as using Q_INC is concerned. It
will just not read the value out of that field from the first report. if I
type in the number its looking for, my report loads fine, I just need to
figure a way to grab that value from that record...

Thanks anyway, if you think of anything else please let me know.

~Erica~

Klatuu said:
Sorry, but I have never even considered using a report's recordset to filter
another's. I would just use the value the user entered to do the filtering
for the second report as well.
--
Dave Hargis, Microsoft Access MVP


Eka1618 said:
Dave,

The first report is filtered by the user being prompt to enter the request
number. However, Q_INC is an autonumber PK. They do not know this information
and that is why I want them to beable to just click on the button and
generate the report using whatever value is stored in the Q_INC field for
that particular record at the time the button is clicked.

I do not understand why it stoped working though, I changed the first form
just a little bit and now the filter statement in the second form does not
work. I've tried putting the statement in the criteria section of my query
(Like [Reports].[Single Key Test Summary].[Q_INC]) but it does not work... It
seems that it will just not grab the value from the report weather I have the
field enabled or not.

Maybe I just do not know how to write the statement. Is it different that
when you refference a forms field?

~Erica~




:

You should be doing this in the second report's record source query. If you
create a record source query for the second report that uses field necessary
to filter the record source the same way the record source for the first
report is filtered, that will solve your problem.
--
Dave Hargis, Microsoft Access MVP


:

Hello, I have two reports and the second I will need to be filtered from the
first.

In my first report (Single Key Test Summary), It brings up a list of all
tests that are have a particular REQUEST_NO. Each records that appears is a
different type of test(i.e.-Impact, Static). Each test type will have it's
own kinds of test result & summaries. The test summary information is on the
second report. I have a report for each type of test since each summary will
have show different information.

What happens in the first report (Single Key Test Summary), is that in the
details area, I have placed a button that will open up the report that
matches the test type shown in that current record. This part works. What is
not working is that I am trying to filter the second report so that it only
shows information with the current test queue ID (Q_INC). In the filter
section of this report I have tried the following statement:

[Q_INC]=Reports.[Single Key Test Summary].Q_INC

I had an earlier design which was working, but it has stoped filtering and I
get all of the records on the second report.

I'm trying to explain this the best way I can. These reports must be
seperate from one another because each test is different and I was having
difficulty combining the different types of information on the report because
each record was spitting out information that was wrong.... For instance, if
I had a request that had an Impact, and Static test, each record in the
second report would give me information on both types of tests (even if there
was nothing to show).

I can explain this more if this it too confusing (hopefully it wasn't)
Please let me know if anyone has any suggestions on how i can filter the
second report. Thank you!

~Erica~
Click to expand...
Click to expand...
Click to expand...
 
Are you using Access 2007? That version, I hear, allows some user
interaction with Reports; prior versions do not -- since Access 1.0 the rule
has been "Reports are for viewing data that is formatted and displayed or
printed and Forms are for interacting with data, but can be used for viewing
displayed data". If you actually were interacting with an Access 2003 or
earlier report to show another, then I am sure that many here would be
enlightened to learn _how_.

If you are using Access 2007, then I will not be able to assist, because I
do not have an installed, working copy just now. Many in these newsgroups
are not yet using Access 2007, so it is particularly important to note the
version if that is what you are using.

Larry Linson
Microsoft Office Access MVP
 
Back
Top