Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 102
  • Last Modified:

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

0
shaz0503
Asked:
shaz0503
  • 3
  • 2
2 Solutions
 
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
 
Rey Obrero (Capricorn1)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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
shaz0503Author Commented:

thanks Capricorn1

I hope to test this out this week..

rgds
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now