开发者

Reporting Services: Exported to Excel results are different than the ones viewed on IE

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开发者_C百科 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 ?


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜