Report Template/Master Question

[ShannonMarie]

In a project that already holds 14 letters and 4 reports my partner and I have decided to add a report template should any more be needed later. (Ever heard that before? ) The titles are all different. The detail section has 3 repeating fields, however two reports have unique fields as well. The footer has a simple calculation. Three of the four have a Detail Header that is the same. Should I build a lookup table for the title of the report? If I insert the 3 repeating fields in the template and a report is designed later that does not require this information can those fields simply be deleted? Still learning as I go so experience builds wisdom. Please know that all of the answers that I recieve here are appreciated and gratefully recieved.

 

[doss]

Hello.

I'm not sure that I completely understand what you mean by "Building a Lookup Table for the title of the Report...."

Here is what we do when we need another report: If we have one that is already similar, we simply copy and paste the report, rename it, and then change the record source, titles, etc.

Hope that helps....

 

[ShannonMarie]

Thanks!

I agree that your suggestion is the easiest way. I have done that as well. I built a table with ReportID and ReportTitle. Then in the header of the report master I wrote a DLookup statement to pull the title into the heading. It is not what I would have prefered, however it is what my partner (who has ownership) wanted done. I believe in copy and paste at any possibile instance! Thanks for your response. I know that there are probably other ways to work this out, however, I feel more like a user than a developer on this one. Whatever works to meet the specs.

 

[ShannonMarie]

I have lived and learned!

I created a master with the lookup in the title. Copy and past is what I did to create all of the reports necessary. I misunderstood her specifics when she asked for it. The report master has to be altered for each report but contains all possible fields needed for all of them. I wanted to post my resolve. Thank you for your advice, I appreciate your consideration.