Reports, multiple charts, manual inputs...

[mrb783]

Okay, so here's the deal. I need to make a report that has 10 charts in it with the following criterion:

1. Each chart has its own query associated with it. I have tested the charts ahead of time individually and they all work as desired.
2. Each query has 1-2 data inputs (Month number and Year) that are requested at the time of query execution (query parameters along the lines of [Enter Month] and [Enter Year]). Thus, when each chart is run, they too require the data inputs.
3. All 10 charts will use the same two inputs.

When the report loads, I want it to request only two inputs and then generate all of the charts from that data. Is there a way (easy or otherwise) to do this? I really don't want to have to input the same information 10-15 times (or tell my boss to...). Thanks in advance!

 

[WayPay]

Create a form (frmReport) with 2 input fields (txtYear and txtMonth) and a button (btnShowReport). Have all the queries use Forms!frmReport!txtYear and/or Forms!frmReport!txtMonth instead of [input year]/[input month]. for the button On Click event, use something like

DoCmd.OpenReport "MyReport", acViewPreview

to preview the report or use acViewNormal to print it.

Other solutions DO exist .

 

[mrb783]

Thank you so much! Now I just have to go back through about 50 queries.....oi....at least my test run worked!

 

[WayPay]

Thank you so much! Now I just have to go back through about 50 queries.....oi....at least my test run worked!

I built a tool to (eventually) do that kind of thing (output queries to text files, change the text files, re-apply the text files) but as it is it's only useful for me ; I should get working on that again . I think I read somewhere that V-Tools has a useful search&replace function, you might want to check that out.