Reporting Services：导出到 Excel 的结果与在 IE 上查看的结果不同
我遇到了这个问题：
SQL Server 保存一个所述值，比方说 990.30，Reporting Services 报表在浏览器中在线查看时显示不同的值 (948.33)，而当报表导出到时显示第三个值 (912.22)优秀。
Excel 中没有公式，只有简单的值。 此外，报告的布局没有公式。 该代码仅显示一个简单的选择，当在 SQL Server Management Studio 上运行时，它返回原始值 (990.30)。
我到底该如何开始解决这个问题呢？
I'm having this problem:
The SQL Server holds a said value, let's say 990.30, the Reporting Services Report show a different value (948.33) when viewed online, in the brower and a third value (912.22) when the report is exported to Excel.
There are no formulas on Excel, just plain values.
Also, there's no formula on the layout of the report.
The code shows only a simple select that, when run on the SQL Server Management Studio, returns me the original value (990.30).
How on earth shall I start to troubleshoot this ?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我以前从未听说过此类问题。我建议向 Microsoft 提交一张票证，并向他们提供错误的屏幕截图、RDL 文件、存储过程的示例输出等。
要自行解决此问题，我建议创建一个新报告，其中只包含简单的表，返回存储过程或查询的所有详细信息，以验证所有接口中的值是否一致。从那里开始增加复杂性，直到您得到的报告看起来像今天的样子。
I've never heard of this kind of problem before. I would recommend submitting a ticket to Microsoft and provide them with screen shots of the errors, the RDL file, a sample output of the stored procedure, etc.
To troubleshoot this on your own, I would recommend creating a new report that just has a simple table that returns all the details from your stored procedure or query to validate the values are consisten across all interfaces. From there, just start adding on complexity until you get the report to look like it is today.