Solved

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

Posted on 2011-02-10
7
59 Views
Last Modified: 2016-05-15
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
Comment
Question by:shaz0503
  • 3
  • 2
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34866969
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
 

Author Comment

by:shaz0503
ID: 34867002
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
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 250 total points
ID: 34867040
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:shaz0503
ID: 34946479

thanks Capricorn1

I hope to test this out this week..

rgds
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 250 total points
ID: 34949135
If you would like to see an example that  shows multiple was to prompt for criteria then check out: .

Report Dialogs Examples  
0
 

Author Comment

by:shaz0503
ID: 34955672
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Running sum query 6 35
Parse last 2 characters of text value if they are letters 7 17
MS Access Hiden Columns 19 22
Convert Access formula to SQL 5 20
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now