Form w/ Selectable Report Options?

[DBLoser]

I have a table called Labor with the following fields:

Date
Project
Dept
Hours
Rate

I need a flexible report selection form to allow different department managers to select specifics to print a report. I could manually build some 60 reports and make them all happy but I know there is a way to create a form to allow selection of criteria to fill a single report.

I designed a form with:

StartDate - textbox (I will probably insert a calendar object but for now a textbox will suffice)
Project - combobox
Dept - combobox

And an option group with the following options:

Daily, Weekly, Monthly, Yearly

The option group is to do time-interval grouping. This could either be done on the fly via code or I could just build 4 reports and choose that specific report by the option. Either way would be fine with me.

For starters, seeing some code to pass the first couple selection criteria (StartDate and Project) would probably be enough for me to figure out the rest.

I really want to learn how to do this but don't know where else to start. Any help will be greatly appreciated and save me hours of report design time.

Thanks,

Bruce Brannan
MIS

 

[ZOR]

Have you looked in the sites FAQ section. There is an article on generating a query by selection. You want to base queries for reports against selected user inputs ie From Combo selections, etc,etc. There are other articles in there as well. Also I did a keyword search on SQL. 3 lines down there is a reference to a download of a user input search form in a database. I have not tried it but thats the sort of area I would look at. Queries based on SQL. What you want to do is compose a list of all the things that would be searched for to get a report, and then build queries based on variable inputs in the queries. Thsi would certainly be the way to go and avoid creating multiple reports and be more flexible.

 

[ZOR]

Just noticed it, but have you seen the thread 9 lines down on this page?

 

[DBLoser]

Zor,

Thanks to the point to the other thread. I'll study it and then ask questions.

Bruce