我可以使用 MailMerge 和 MS Words 作为报告生成器而不是 Access 报告吗?
这不是关于编码问题。这是关于软件(数据库)设计的。
背景:我的办公室有一个ADP数据库作为前端,SQL Server作为后端。 ADP文件中有十几个基本标准报告。最终用户每年都会稍微更改报告,例如添加一些文本、更改徽标、粗体、突出显示。我来回帮助他们更新这些。在他们同意报告后,我将其上传到服务器,以便其他用户可以使用它。我一遍又一遍地这样做(数百次)。我认为应该有更好的方法。
最近,我通过拆分报表和数据库来测试新的设计。我让用户为他们喜欢的报告创建一个单词文件。完成后,我在报告中添加 MailMerge 字段。我的用户非常擅长使用 MS Word。在数据库中,我添加标准 MailMerge 代码。当用户选择他们想要的报告模板(docx)然后运行它时,它工作得很好。
问:我可以使用 MailMerge 和 MS Words 作为报告生成器而不是 Access 报告吗?如果工作正常,我将推出所有报告。我只是想在这样做之前错过任何事情。
Pro(s)
- Users can add any complex format to a report (almost anything you can imagine in MS Words, which you can't do in Access)
- I have less work. No recode, recomplie, or reupload.
Con(s)
- Report Desinger is run faster than MailMerge for a large report.
- Train user how to update MailMerge fields
This is not about coding question. It's about Software (Database) Design.
Background: My office has a ADP database as front and SQL Server is a backend. There are a dozen of basic standard reports in the ADP file. End users slightly change reports every year such as adding some texts, changing logo, bolds, highlights. I help them back and forth for updating these. After they are ok with the report, I upload to the server so other users can use it. I do this over and over over the time (hundreds times). I think there should be a better way.
Recently, I test a new design by splitting Report and Database. I let user create a words file for the report that they like. I add MailMerge fields in the report after they're done. My users are very good in MS Words. In the database, I add standard MailMerge code. When users pick what template (docx) they want for a report then runs it, it works fine.
Question: Can I use MailMerge and MS Words as Report Generator instead of Access Report? if it's work fine, I will rollout to all the reports. I just want to miss anything before doing so.
Pro(s)
- Users can add any complex format to a report (almost anything you can imagine in MS Words, which you can't do in Access)
- I have less work. No recode, recomplie, or reupload.
Con(s)
- Report Desinger is run faster than MailMerge for a large report.
- Train user how to update MailMerge fields
是的,您可以使用 Word 和 MailMerge 创建报告。但是,请记住,您正在放弃控制权,因为用户可能会以破坏 MailMerge 的方式编辑模板。
Yes, you can use Word and MailMerge to create reports. However, keep in mind that you're giving up control, since users could edit the templates in a way that breaks your MailMerge.