Logical Report Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Any help you could provide me is much appreciated.

I have a main report that has 6 subreports in it.
Each subreport has a field called [Month]

I have a form that the user chooses a Month or chooses "*".

What I want to have happen is that each subreport filter for the same month
chosen on the form UNLESS the user chooses "*".
If the user chooses "*" then I want the reports to pull ALL Months.

Can you help me? I've tried all I know about criteria, filters,
stLinkCriteria, etc. to no avail.

Thank you!

Sandy S.
Database Coordinator
 
Provided you have the month included in teh source of your main report, you
should be able to link the subreports to the main report.
An other way would be to create a form or use an existing form with a field
where you select the desired month, and than tie the source data for each of
the reports to the field of this form.
Maybe you can provide some more specifics.
Hope this helps.
Fons
 
Fons,

Thank you for your assistance.

More specifically, I need to have the query criteria look at the field on
the form for the month (it does this now just fine) OR, if the field on the
form displays * instead of a month I want the query to run all of the months.

This way the user has an option to run it by month or by all months without
me having to create an additional query.

I tried using Like "*", *, "", and Like "* as field list items to pull all
months but have not succeeded thus far.

Your help is much appreciated!

Sandy

Fons Ponsioen said:
Provided you have the month included in teh source of your main report, you
should be able to link the subreports to the main report.
An other way would be to create a form or use an existing form with a field
where you select the desired month, and than tie the source data for each of
the reports to the field of this form.
Maybe you can provide some more specifics.
Hope this helps.
Fons
Sandy said:
Hi,

Any help you could provide me is much appreciated.

I have a main report that has 6 subreports in it.
Each subreport has a field called [Month]

I have a form that the user chooses a Month or chooses "*".

What I want to have happen is that each subreport filter for the same month
chosen on the form UNLESS the user chooses "*".
If the user chooses "*" then I want the reports to pull ALL Months.

Can you help me? I've tried all I know about criteria, filters,
stLinkCriteria, etc. to no avail.

Thank you!

Sandy S.
Database Coordinator
Click to expand...
Click to expand...
 
Sandy, I have tried but have not found it yet. I remember something in this
NewsGroup but have not been able to find it.
Fons

Sandy said:
Fons,

Thank you for your assistance.

More specifically, I need to have the query criteria look at the field on
the form for the month (it does this now just fine) OR, if the field on the
form displays * instead of a month I want the query to run all of the months.

This way the user has an option to run it by month or by all months without
me having to create an additional query.

I tried using Like "*", *, "", and Like "* as field list items to pull all
months but have not succeeded thus far.

Your help is much appreciated!

Sandy

Fons Ponsioen said:
Provided you have the month included in teh source of your main report, you
should be able to link the subreports to the main report.
An other way would be to create a form or use an existing form with a field
where you select the desired month, and than tie the source data for each of
the reports to the field of this form.
Maybe you can provide some more specifics.
Hope this helps.
Fons
Sandy said:
Hi,

Any help you could provide me is much appreciated.

I have a main report that has 6 subreports in it.
Each subreport has a field called [Month]

I have a form that the user chooses a Month or chooses "*".

What I want to have happen is that each subreport filter for the same month
chosen on the form UNLESS the user chooses "*".
If the user chooses "*" then I want the reports to pull ALL Months.

Can you help me? I've tried all I know about criteria, filters,
stLinkCriteria, etc. to no avail.

Thank you!

Sandy S.
Database Coordinator
Click to expand...
Click to expand...
Click to expand...
 
Back
Top