我可以使用 MailMerge 和 MS Words 作为报告生成器而不是 Access 报告吗?

发布于 12-07 17:27 字数 813 浏览 0 评论 0原文

这不是关于编码问题。这是关于软件(数据库)设计的。

背景:我的办公室有一个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

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

空气里的味道2024-12-14 17:27:58

是的,您可以使用 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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文