Need help filtering subreports by date

[Guest]

I have a report with two subreports that I have linked to it. I built a form
to prompt users for the beginning and ending dates to filter out the report,
my problem is that I can get the filter to work on the main report, but the
subreports are a different story. The filter dates will only work on the
subreports on my first group, after that it prompts me to enter a date for
each subsequent grouping.

I've tried setting the parameters in the query, but I get the same effect.
The first grouping on the report works, but all the subsequent ones don't.

 

[Duane Hookom]

Can you provide the SQL view of your subreports? One cause for the prompts
is using former parameter prompts in control sources within your subreport
like:
="Between " & [Enter Start] & " and " & [Enter End]

 

[Guest]

Is there any way to pass the filter criteria using the open arguments
statement and then use it to set the filter property of the subreport?
--
Kellie Murphy

Can you provide the SQL view of your subreports? One cause for the prompts
is using former parameter prompts in control sources within your subreport
like:
="Between " & [Enter Start] & " and " & [Enter End]

 

[Duane Hookom]

Are you using the controls on your form to filter the record source queries
of your subreports?


--
Duane Hookom
MS Access MVP

Is there any way to pass the filter criteria using the open arguments
statement and then use it to set the filter property of the subreport?
--
Kellie Murphy

Can you provide the SQL view of your subreports? One cause for the
prompts
is using former parameter prompts in control sources within your
subreport
like:
="Between " & [Enter Start] & " and " & [Enter End]

--
Duane Hookom
MS Access MVP

I have a report with two subreports that I have linked to it. I built a
form
to prompt users for the beginning and ending dates to filter out the
report,
my problem is that I can get the filter to work on the main report, but
the
subreports are a different story. The filter dates will only work on
the
subreports on my first group, after that it prompts me to enter a date
for
each subsequent grouping.

I've tried setting the parameters in the query, but I get the same
effect.
The first grouping on the report works, but all the subsequent ones
don't.

 

[Guest]

No, I tried to set it up that way, but it wouldn't work properly. When it
changed groups in my report it would prompt me for the date information
again, so I took that out.

Here is SQL view of one of my queries. I didn't see a SQL view for my report.
SELECT RawInputInformation.LineID, DownTimeInformation.SpecificDTReason,
DownTimeInformation.TimeFrom, DownTimeInformation.TimeTo,
DownTimeCodes.DownTimeCode, RawInputInformation.RawDate,
ProductOutputInformation.ProductOutputID
FROM (RawInputInformation INNER JOIN (DownTimeCodes INNER JOIN
DownTimeInformation ON DownTimeCodes.DownTimeID =
DownTimeInformation.DownTimeID) ON RawInputInformation.RawInputID =
DownTimeInformation.RawInputID) INNER JOIN ProductOutputInformation ON
RawInputInformation.RawInputID = ProductOutputInformation.RawInputID;

--
Kellie Murphy

Are you using the controls on your form to filter the record source queries
of your subreports?


--
Duane Hookom
MS Access MVP

Is there any way to pass the filter criteria using the open arguments
statement and then use it to set the filter property of the subreport?
--
Kellie Murphy

Can you provide the SQL view of your subreports? One cause for the
prompts
is using former parameter prompts in control sources within your
subreport
like:
="Between " & [Enter Start] & " and " & [Enter End]

--
Duane Hookom
MS Access MVP

I have a report with two subreports that I have linked to it. I built a
form
to prompt users for the beginning and ending dates to filter out the
report,
my problem is that I can get the filter to work on the main report, but
the
subreports are a different story. The filter dates will only work on
the
subreports on my first group, after that it prompts me to enter a date
for
each subsequent grouping.

I've tried setting the parameters in the query, but I get the same
effect.
The first grouping on the report works, but all the subsequent ones
don't.

 

[Duane Hookom]

You will not be prompted for the Forms!frmYourForm!txtYourText in subreports
as long as you have the form open. If you are getting prompted for a value
from a control on your form then make sure the form/control is spelled
correctly and the form is open.


--
Duane Hookom
MS Access MVP

No, I tried to set it up that way, but it wouldn't work properly. When it
changed groups in my report it would prompt me for the date information
again, so I took that out.

Here is SQL view of one of my queries. I didn't see a SQL view for my
report.
SELECT RawInputInformation.LineID, DownTimeInformation.SpecificDTReason,
DownTimeInformation.TimeFrom, DownTimeInformation.TimeTo,
DownTimeCodes.DownTimeCode, RawInputInformation.RawDate,
ProductOutputInformation.ProductOutputID
FROM (RawInputInformation INNER JOIN (DownTimeCodes INNER JOIN
DownTimeInformation ON DownTimeCodes.DownTimeID =
DownTimeInformation.DownTimeID) ON RawInputInformation.RawInputID =
DownTimeInformation.RawInputID) INNER JOIN ProductOutputInformation ON
RawInputInformation.RawInputID = ProductOutputInformation.RawInputID;

--
Kellie Murphy

Are you using the controls on your form to filter the record source
queries
of your subreports?


--
Duane Hookom
MS Access MVP

Is there any way to pass the filter criteria using the open arguments
statement and then use it to set the filter property of the subreport?
--
Kellie Murphy


:

Can you provide the SQL view of your subreports? One cause for the
prompts
is using former parameter prompts in control sources within your
subreport
like:
="Between " & [Enter Start] & " and " & [Enter End]

--
Duane Hookom
MS Access MVP

I have a report with two subreports that I have linked to it. I
built a
form
to prompt users for the beginning and ending dates to filter out the
report,
my problem is that I can get the filter to work on the main report,
but
the
subreports are a different story. The filter dates will only work
on
the
subreports on my first group, after that it prompts me to enter a
date
for
each subsequent grouping.

I've tried setting the parameters in the query, but I get the same
effect.
The first grouping on the report works, but all the subsequent ones
don't.

 

[Guest]

Thanks, your were right I forgot to leave the form open.
--
Kellie Murphy

You will not be prompted for the Forms!frmYourForm!txtYourText in subreports
as long as you have the form open. If you are getting prompted for a value
from a control on your form then make sure the form/control is spelled
correctly and the form is open.


--
Duane Hookom
MS Access MVP

No, I tried to set it up that way, but it wouldn't work properly. When it
changed groups in my report it would prompt me for the date information
again, so I took that out.

Here is SQL view of one of my queries. I didn't see a SQL view for my
report.
SELECT RawInputInformation.LineID, DownTimeInformation.SpecificDTReason,
DownTimeInformation.TimeFrom, DownTimeInformation.TimeTo,
DownTimeCodes.DownTimeCode, RawInputInformation.RawDate,
ProductOutputInformation.ProductOutputID
FROM (RawInputInformation INNER JOIN (DownTimeCodes INNER JOIN
DownTimeInformation ON DownTimeCodes.DownTimeID =
DownTimeInformation.DownTimeID) ON RawInputInformation.RawInputID =
DownTimeInformation.RawInputID) INNER JOIN ProductOutputInformation ON
RawInputInformation.RawInputID = ProductOutputInformation.RawInputID;

--
Kellie Murphy

Are you using the controls on your form to filter the record source
queries
of your subreports?


--
Duane Hookom
MS Access MVP

Is there any way to pass the filter criteria using the open arguments
statement and then use it to set the filter property of the subreport?
--
Kellie Murphy


:

Can you provide the SQL view of your subreports? One cause for the
prompts
is using former parameter prompts in control sources within your
subreport
like:
="Between " & [Enter Start] & " and " & [Enter End]

--
Duane Hookom
MS Access MVP

I have a report with two subreports that I have linked to it. I
built a
form
to prompt users for the beginning and ending dates to filter out the
report,
my problem is that I can get the filter to work on the main report,
but
the
subreports are a different story. The filter dates will only work
on
the
subreports on my first group, after that it prompts me to enter a
date
for
each subsequent grouping.

I've tried setting the parameters in the query, but I get the same
effect.
The first grouping on the report works, but all the subsequent ones
don't.