打印 Access 报告和小数位怪异
我的客户有一个不是我们编写的 Access (2000) 应用程序,并且我们无权访问 MDB(它是一个 MDE)。其中一项功能是创建装箱单报告。没有预览选项,只能打印或保存到文件。
有一个字段代表权重;这是一个双字段。在独立计算机上,它可以正确打印,但是当通过终端服务打印时,它显示全零。然而,打印到 XPS 格式使我们能够看到它正在将数字格式化为大约二十位小数,这表明在独立计算机上它可能会做同样的事情,但左对齐字段,但右对齐(并因此仅显示零)通过终端服务。
无论如何,我与这件事无关,但我们的网络人员把它带给了我。如果需要的话我可以获得更多信息。有什么想法可能会导致这种情况发生以及如何解决它吗?
My client has an Access (2000) application that we didn't write and we don't have access to the MDB (it's an MDE). One of the functions is to create a packing slip report. There's no option to preview, only print or save to file.
There's a field that represents a weight; it's a Double field. On a standalone machine, it prints correctly, but when printing through Terminal Services it displays all zeros. Printing to XPS format, however, allowed us to see that it was formatting the number to about twenty decimal places, which suggests to me on the standalone machine it may be doing the same thing but left-aligning the field, but right-aligning (and thus displaying only the zeros) through Terminal Services.
For what it's worth, I had nothing to do with this, but our network guy brought it to me. I can get more info if needed. Any ideas what may cause this to happen and how to fix it?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
唯一可能的解决方法是正确格式化字段,这需要 MDB 源代码。抱歉,但这是唯一真正的解决方案。
The only possible fix is properly formatting the field and that requires the MDB source code. Sorry, but that's the only real solution.
服务器上的默认打印机可能以不同的方式格式化报告。对于我们店里拥有不同默认打印机的人来说,Crystal .NET 也会发生类似的情况 - 有时靠近边距的元素不会显示,有时会被剪裁,有时则很好。如果可能,请将终端服务器上的默认打印机更改为与“独立计算机”上相同的打印机,以进行测试。
It's possible that the default printer on the server is formatting the report differently. A similar thing happens with Crystal .NET for people in our shop who have different default printers - sometimes elements close to the margin don't show, sometimes they clip, sometimes they are fine. If possible, change the default printer on the Terminal Server to the same printer as on the "standalone machine", as a test.
我尝试更改默认打印机但无济于事。现在唯一的打印机是系统的共享打印机,可以在独立机器上正确打印提货单。
毕竟也许可以访问源代码。您能想到为什么它可以在独立环境(xp 上)而不是在 TS 2003 中工作吗?感谢您的任何见解。
I tried changing default printer to no avail. The only printer on there now is a shared printer to a system that prints the picking slip correctly on the stand alone machine.
It may be possible to access the source after all. Can you think of any reason why it might work in a stand alone environment (on xp) and not in TS 2003? Thanks for any insight.