Allow user to create custom, filtered reports

[zzzjoshzzz]

I have a normalized database with (let's say) the following tables:



tblProjects
tblStaff
tblProjectPhase
tblOffice


I need a way to allow the end user to be able to create custom reports that show only projects in certain phases (let's say planning and construction) AND that are from certain Offices (let's say Office 1 and 3 but not 2) AND that were started between a certain date range.


What I'm envisioning is a checkbox-style form that has a 'create report' button at the bottom.

Your help is MUCH APPRECIATED. =)

[June7]

Build filter criteria based on selections on form and use the constructed criteria string in WHERE CONDITION argument of OpenReport method.

Review http://www.allenbrowne.com/ser-62.html

[ranman256]

In the report form, you would have combo boxes or text boxes.
the report would either use the combo in the qquery
select * from table where [dept] = forms!frmReport!cboDept.
OR

If you have many boxes and SOME are selected, then you must determine what got picked then filter in the openReport clause.

[zzzjoshzzz]

In the report form, you would have combo boxes or text boxes.
the report would either use the combo in the qquery
select * from table where [dept] = forms!frmReport!cboDept.
OR

If you have many boxes and SOME are selected, then you must determine what got picked then filter in the openReport clause.

Yes, I'm trying to do the second thing you mentioned. Do you know how to do this?

[June7]

Did you review link in post 2?

[zzzjoshzzz]

Build filter criteria based on selections on form and use the constructed criteria string in WHERE CONDITION argument of OpenReport method.

Review http://www.allenbrowne.com/ser-62.html

Thanks! I will try this today or this weekend and get back to you. Great link though. =)