更改 SQL Reporting 2005 中的货币符号
我正在使用 SQL Reporting 2005。我正在使用格式设置单元格中的货币
Format(Fields!NetPrice.Value, "C")
，但格式即将出来，
$10.00
我想要英镑，所以
£10.00
有人可以告诉我执行此操作的设置在哪里。我已经查看和谷歌但找不到它。很明显吗？如果可能的话，我想在报告级别设置它，并且不更改 SQL Server 设置，以尽量减少对其他地方的影响。
我可以将货币转换为字符串并添加 "£" 我猜，但我想正确地做到这一点。
I'm using SQL Reporting 2005. I'm formatting a currency in a cell using
Format(Fields!NetPrice.Value, "C")
but the format is coming out
$10.00
I want pounds so
£10.00
Can someone tell me where is the setting to do this. I've looked and google and can't find it. Is it obvious? I want to set it on the report level if possible and not alter SQL Server settings due to minimise impact elsewhere.
I could cast the currency to a string and add "£" I guess but I want to do it properly.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您不需要手动编辑 RDL 文件。我猜您看不到语言部分，因为您没有选择报告。
要查看报告属性，请单击报告轮廓后面的背景（黄色部分），然后检查属性窗口或在查看属性窗口时从下拉列表中选择“报告”。
You shouldn't need to manually edit the RDL file. I guess you couldn't see the language section as you didn't have the report selected.
To see the report properties click on the background behind the outline of the report (the yellow section) and check the properties window or select 'Report' from the drop down when viewing the properties window.
默认情况下，日期、货币和数字的格式由运行时的报表服务器语言确定。
要覆盖通过报表服务器语言提供的格式，您可以在设计报表时在报表中设置“语言”属性。这可以在报表级别或 TextRun 级别设置。如果要根据浏览器或客户端应用程序的语言或本地设置来改变格式，可以将 Language 属性设置为包含 User!Language 变量的表达式。
此信息在此处提供。
在报告上，您可以设置本地化部分中的语言属性。您将在此属性中放置语言代码（例如 en-GB）。如果您愿意，您也可以在现场级别执行此操作。这应该会影响您电脑上的区域和语言设置。如果您想覆盖它或控制它，那么您只需相应地设置报告属性即可。
如果您设置此属性，然后查看报告的代码 (RDL)，您将在最底部看到此信息：
此信息将用于货币、日期和数字转换。
By default, formats for date, currency, and numbers are determined by the report server language at run time.
To override the formatting provided through the report server language, you can set the Language property within the report when you design it. This can be set at the report level or the TextRun level. If you want to vary the formatting based on the language or local settings of the browser or client application, you can set the Language property to an expression that includes the User!Language variable.
This info was provided HERE.
On the Report you can set the Language Property which is in the Localization section. You will place the language code like en-GB in this property. You can also do this at the field level too if you want. This should pick-up on your Regional and Language settings on your PC. If you want to override this or control this then you can simply set the report property accordingly.
If you set this property and then view the code of the report (RDL) you will see this towards the very bottom:
This information will be used for currency, date, and numeric conversions.