Setting parameters for queries in reports

[Ofer]

After you get the year parameter, use the filter of the
month as follow:

On the year sub - "Year(mydate)=YearGivenParameter"
and on each quarter sub - "Year(mydate)=YearGivenParameter
and Month(MyDate) in (1,2,3)"(first quarter)

If you want to use the same sub for all 5 reports then put
the filter in LinkChildField and LinkMasterField.

I hope it make sense.

 

[Ofer]

When your report is open, you select a sub report on it,
and on the sub report properties you select to which
report you want to bound the sub report.
You also have on it two other proprties:
1. LinkChildField
2. LinkMasterField

on the master you refer a field that is created on the
master report
on the child you refer to field created on your sub report.
the Report than will match the value between the two of
then.
that way each sub can have a different filter but you
still use the same sub report.

 

[jl5000]

K,
Create a form where you send the parameters, and link all your queries to
that form, that way your form sends the parameters only once, You can aloso
visit www.joshdev.com for a tool to send parameters to reports

 

[D Thompson]

I was trying very hard to read through the postings to find a Q/A to help me.
Is it possible to create a Parameter control for a report that prompts the
user to enter their name? Mind you, the report I have is not based off of any
query--not exactly anyway. Its a chart based off of a query that shows
departments and how many forms they have submitted. My problem is that
whenever this report is run the time frame is different. So I would like the
user to be able to enter their name and/or time period of the report
everytime its ran. I appreciate any help and thank you for your time!

 

[John]

I was trying very hard to read through the postings to find a Q/A to help me.
Is it possible to create a Parameter control for a report that prompts the
user to enter their name? Mind you, the report I have is not based off of any
query--not exactly anyway. Its a chart based off of a query that shows
departments and how many forms they have submitted. My problem is that
whenever this report is run the time frame is different. So I would like the
user to be able to enter their name and/or time period of the report
everytime its ran. I appreciate any help and thank you for your time!

What I usually do is base a parameter query on text input or
selection from a list on a form

PrintMenu has a place to enter the date (date1) and
maybe another date (date2) for a BETWEEN action

PrintMenu also has a place to enter the name1

In the query criteria, use "something like" for the date... if
you are using a query to SELECT dates
[forms]![PrintMenu]![date1]
or
Between [forms]![PrintMenu]![date1] And [forms]![PrintMenu]![date2]

If all you are doing is PRINTING the information, put a control
in your report, with the source as...
[forms]![PrintMenu]![date1]
and another control with source of
[forms]![PrintMenu]![date2]
to show a date range

Then, for name, a control with source of
[forms]![PrintMenu]![name1]

 

[D Thompson]

Excellent! Thanks!

I was trying very hard to read through the postings to find a Q/A to help me.
Is it possible to create a Parameter control for a report that prompts the
user to enter their name? Mind you, the report I have is not based off of any
query--not exactly anyway. Its a chart based off of a query that shows
departments and how many forms they have submitted. My problem is that
whenever this report is run the time frame is different. So I would like the
user to be able to enter their name and/or time period of the report
everytime its ran. I appreciate any help and thank you for your time!

What I usually do is base a parameter query on text input or
selection from a list on a form

PrintMenu has a place to enter the date (date1) and
maybe another date (date2) for a BETWEEN action

PrintMenu also has a place to enter the name1

In the query criteria, use "something like" for the date... if
you are using a query to SELECT dates
[forms]![PrintMenu]![date1]
or
Between [forms]![PrintMenu]![date1] And [forms]![PrintMenu]![date2]

If all you are doing is PRINTING the information, put a control
in your report, with the source as...
[forms]![PrintMenu]![date1]
and another control with source of
[forms]![PrintMenu]![date2]
to show a date range

Then, for name, a control with source of
[forms]![PrintMenu]![name1]