Multiple Reports

[MarkNie]

Hi

Was just wondering if anybody could shed some light on the below for me.

I currently have a DB that tracks reports which are created printed and sent out. Each Analyst does a certain amount of reports, there are about 15 analysts. I want to create a standard report for all the Analysts and the only thing that changes is the data per analyst. Would I have to create a report for each Analyst or is there a way of automatically creating a report. Or can you choose the analyst name from a drop down and then the report get created automatically.

Not sure what is the best way to do this so if anybody has any ideas it would be greatly appreciated.

Thanks
Alot

 

[THWatson]

Mark
You say that the only thing that changes is the "data per analyst."

Therefore, a question to clarify...
What data changes?

Or, are the reports identical, except that the name of the Analyst that appears on the report is different, depending upon the Analyst?

Tom

 

[MarkNie]

Hi Tom

I will try and explain as best I can.

I have a table with the following fields:

1. Tracking ID
2. Analyst Name
3. Report Name
4. Perf Date
5. Run Date
etc.

I need to show reports for each analyst with there reports in. So each report will only have that analysts data in.

The Analysts will change on a Monthly basis so I don't want to create and delete reports every month. The data is imported from a excel spreadsheet on the first day of every month all the old data gets exported into a backup excel file.

If there is anyway that I can have a drop down that looks for the analyst in the table and then autocreates a report for the analyst from a template report.

Thanks alot for you help.
Regards
Mark

 

[THWatson]

Mark
From your explanation, it appears to me that you have two things that vary - the Analyst Name, and the Report Name.

In other words, AnalystA could have Report1, Report2, Report3, etc. AnalystB could have Report2, Report5, Report7 etc.

If this is correct, then here is one way you could do it...

1. Create your template report, but leave the Record Source bank.
2. Create an unbound form.
3. On that form, create two option groups - optAnalysts and optReports.
4. Put code behind the option group buttons, using Select Cast statements, so that, depending upon which Analyst and which Report was chosen, the SQL statement would change. The specific SQL statement would be the Record Source for the report.
5. Create a command button to drive the report.

Hope that helps.

Tom