The best solution is make a form with an unbound combobox and the RecordSource for the combobox, it's your choice.
In that form insert a list box and present what you want and export data to excel or pdf.
On the other hand, if your reports are required grouping and calculated fields then it's...