one report to rule them all ( i know, that a horrible way analogy)

[shades714]

So here is what I have. 1x table with all data. 4x queries dividing the data up by departments. 4x reports (personal, work history, training, finance)


Here's what Id like to be able to do.....
I want to create a simple form that I can select from a drop down one of those queries and then be able to select a button that will display the corresponding report but only for the department I selected in the drop down.
When the report display I would like it to have the department name up in the header but thats not as important as getting everything to work on the same report

the report design doesnt change....just the data

I know something along these lines is possible and i do not want to create a separate report for each department.

im useing 2007-2016 on a WIN 10.

[madpiet]

Pass a filter in the Report's Open event and pass the parameters from your comboboxes. Use ONE report. Create the report with only the filters you want for every "version" of the report. Except you only have one report. Open it from an unbound form where users can choose the filters they want to apply, and then concatenate all the reports into a string and the you pass those in the Open event of the report.

[shades714]

great......i should clarify something. i understand what you are saying but not the how. can you give me a little more detail and possibly steps to do.

[madpiet]

great......i should clarify something. i understand what you are saying but not the how. can you give me a little more detail and possibly steps to do.

Create a button on a form and have the wizard open a report for you.

DoCmd.OpenReport method (Access) | Microsoft Learn

[davegri]

Have a look at this:

Shades-davegri-v01accdb.zip

[shades714]

not exactly what im going for. I clarify further....
i have a form with several buttons and each button when selected brings up the specific report. I am looking to add a drop down to that same form that when you select a department and select one of the buttons it will bring up the report with only that departments info on it. Hope that clarifies it better

[ano]

you mean : the button start the report already but before the button you like to select a department that is active in those reports.
then you take the example you have here and the

DoCmd.OpenReport "your_report", acViewPreview, , "SelectType='" & cboChoice & "'"

assuming you have this code nearly in use
and in your report : in heading field

="Report for " & [SelectType]

seems to me what you are looking for.
did u test and check the codes?

[davegri]

Assume 4 reports, all from same table. Each callable to show one of 4 departments or all departments if dropdown not used.
Report headings indicate report content.

Shades-davegri-v02accdb.zip

[ano]

i would hide the buttons till choosen which department and then visible so there is input

[Welshgasman]

I used to use a combo for my reports, as there were a few I could run.

[davegri]

i would hide the buttons till choosen which department and then visible so there is input

My interpretation of post#1 was that the reports could be run without any dropdown as well.

[ano]

then you should put the selection left from the buttons

[madpiet]

"concatenate all the reports"? LOL

Sorry, what I meant was to "concatenate all the filters"

[madpiet]

The biggest problem with a layout like this is "What happens when you add another report?" that's why I don't use buttons like that. Access can't use control arrays the way VB can. that's a big reason to use comboboxes and listboxes, because you can filter them. (show/hide items)