Report running

[dcarr]

Hi Guys,

I have a report that at the moment requires user input, that is it prompts the user for an input before executing. A typical input would be LG, SG or WG.
Upon inputting this value the report executes and produces a report.
However I have a problem. I want to try and automate all of this. I want to create three reports for the different inputs. I thought I would be able to simply copy the main report and odify the query behind each so an input would not be required. This was not the case as the report attempts to reference the first report. Is there any way I can change this without having to modify the data source on each of the fields

A typical data source is:
=DSum("[SumOfSumOfNETCHARGE1]","[AdLyTyDeBuTotCentre]","[periodkey]='" & [Reports]![repTor4]![periodkey] & "' and [weekno] <= '" & [Reports]![repTor4]![weekno] & "'and [Centre] = '" & [Reports]![repTOR4]![CentreGroup] & " '")

Where I need to change the [repTor] to [repTOR&"User Input"]

Thanks

 

[The_Doc_Man]

[Reports]![repTor4]![periodkey]
[Reports]![repTor4]![weekno]
[Reports]![repTOR4]![CentreGroup]

These are references to fields on your report (assuming it is called repTor4). What confuses me is that if your report of interest ISN'T repTor4, this syntax will fail unless the repTor4 report is already open.

Is that part of your operational procedure? (I.e. that the repTor4 report must be opened before you can run the other reports?) Or is repTor4 the report you want modified?

As you can see from this question, we might need more info to help you better.

 

[dcarr]

Report Running

The report [repTOR4]! is the original report. Behid the report is a query which prompted the user for some sort of input. The typical inputs are SG, LG, and WG. The user must choose out of these three. The report itself had to be run three times once for each of the inputs.
The report does not have to be open. All I want to do is to copy (duplicate) the report three times so instead of inputting a value the query behind the report already holds the input value (LG, SG or WG).
Hope this helps.

 

[dcarr]

Running Report

Thanks for your help guts. I have now managed to resolve the problems. I copied the reports and modified both the underlying queries and the references to fields within the query and table that the report related to. It now works fine.
Thanks