解密数据以供 SQL Reporting Services 2008 使用
我最近开始关注sql报告服务。 我将数据存储在数据库中,该数据库在存储之前已使用 AES 密码进行加密。
我已经尝试过使用 Microsoft Report Builder 2.0 构建一些报告,并且将一些简单的报告拼凑在一起似乎非常好且简单。
我的问题是:我可以在将这些数据显示在报告上之前对其进行解密吗?无论如何可以使用这些报告运行代码吗?
I have recently started to look at sql reporting services.
I have data stored in a database which has been encrypted with an AES cypher before being stored away.
I've had a look at building some reports using Microsoft Report Builder 2.0 and it seems quite nice and simple for knocking together some simple reports.
My question is: Can I decrypt this data before displaying it on a report? Is there anyway to run code with these reports?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
使用 RDLC(C 代表客户端),然后查看 Microsoft.Reporting.WebForms 和 Microsoft.Reporting.WinForms 命名空间。
这允许您使用代码生成数据,例如从 SQL Server 获取数据,然后根据需要对其进行解密,然后再将其呈现给 ReportViewer 控件。
Use a RDLC (C is for Client), and then look at the Microsoft.Reporting.WebForms and Microsoft.Reporting.WinForms namespaces.
This allows you to use code to generate your data, for example get your data from SQL Server then decrypt it as required before presenting it to the ReportViewer control.