is it possible to have 'dynamic' reports using a template

All

I have several reports within a database that are replicated far 20 different areas with that area information only.

Is it possible to use a template and then through a 'function' get the reports for each area.  main reason is that I currently have 80 reports (20 x 4 different report) and if I need to change something need to amend all 20.

Is not ot big a deal but if am able to use a template that just updates with 'function' would be easier

rgds

shaz0503Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
Can all these reports run off the one query? Yes but NO filter.

create a form
add a combo box and set the row source to the Department that you will use as filter.

add a command button_ use this to open the report

private sub btnOpenReport_click()
dim strFilter as string
if me.comboDepartment & ""<>"" then
   strFilter="[Department]='" & me.comboDepartment & "'"

  docmd.openreport "reportName", acviewpreview,, strfilter

end if

end sub


0
 
Rey Obrero (Capricorn1)Commented:
yes it is possible, you just need one report and use filters to change the content of the report.

it will be better to use a form to set all the values for the different areas.

0
 
shaz0503Author Commented:
Thanks Capricorn1

Can you give me a bit more detail -

Can all these reports run off the one query?  The Department Description field is what will determine the area report produced.

I have a seperate query that reports records using a 'between dates' query (pop up asks for date range'......is the principle here the same....

rgds
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
shaz0503Author Commented:

thanks Capricorn1

I hope to test this out this week..

rgds
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
If you would like to see an example that  shows multiple was to prompt for criteria then check out: .

Report Dialogs Examples  
0
 
shaz0503Author Commented:
Thanks

Have had a quick look and looks like something I can definately use....will have a play and let you know..

rgds
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.