我需要一份关于如何从一开始就为 ASP.NET 应用程序设置 SSRS 的初学者指南？
我非常熟悉 ASP.NET，目前正在使用 ASP.NET 编写 MVC 应用程序。 我现在需要将报告集成到我的应用程序中。 我选择的选项（我对此很灵活）是 SSRS。 我在 SSRS 方面的经验为零，似乎需要执行很多步骤来进行设置，从安装报表服务器、配置报表服务器、在 Business Intelligence Development Studio 中创建报表项目以及将报表发布到报告服务器。我可能在这个过程中做错了什么，因为我不确定报表服务器的大约一半配置设置。任何人都可以指导我了解如何执行以下操作的“教程”：
1.) 正确设置和安装 SSRS。我正在使用 SQL Server 2008。（不是 R2）。
2.) 创建报告并将其发布到报告服务器。
3.) 能够从我的 ASP.NET Web 应用程序访问此报告。
我很感激任何回应！谢谢！！
麦克风
I'm pretty familiar with ASP.NET, and am currently writing an MVC app in ASP.NET.
I'm at the point where I need to integrate reports into my application.
The option I chose to go with (and I'm flexible on this) is SSRS.
I have zero experience in SSRS and it seems that there are a LOT of steps involved in getting that set up, from installing the Report Server, configuring the Report Server, creating a report project in Business Intelligence Development Studio, and publishing the report to the Report Server. I might have done something wrong in the process since I wasn't sure about half of the configuration settings with Report Server. Can anyone guide me to a "tutorial" on how to:
1.) Set up and install SSRS properly. I'm using SQL Server 2008. (Not R2).
2.) Creating and publishing a report to the Report Server.
3.) Being able to access this report from my ASP.NET web application.
I appreciate any responses!! Thanks!!
Mike
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这有 3 个部分。
a) 创建报告：
您可以将 Reporting Services 组件安装到 VS.net（或 BIDS，因为 Microsoft 在本例中称为 VS.net），从这里您可以连接到数据源，设计、创建和预览报告 - 所有舒适地使用您的机器。甚至还有向导可以帮助您入门。您将在“创建新项目”对话框中名为“商业智能”的新部分下看到这些内容，
其本质上是创建一个报告文件（扩展名为 .RDL 的 XML 文件）和数据源文件（扩展名为 .RDS）
b) 使用报告：
您需要在服务器上安装 RS 组件。 RS 通过 http(s) 访问，需要 SQL Server 数据库来存储有关报告的信息。它们可以驻留在同一个盒子上。
用于管理 RS 站点的工具称为“报告管理器”，是一种基于 Web 的工具。
http://localhost/reports
一旦完成此设置（包括安全性），只需部署步骤 1 中的报告即可一切顺利 - 您只需在 VS.net 中的新报告上“右键单击/部署”即可完成此操作
c) 此时，您将充分了解其工作原理，因此将报告查看器控件添加到你的应用程序会很简单。
There are 3 parts to this.
a) Creating a report:
You can install the Reporting Services components into VS.net (or BIDS as VS.net is called by Microsoft in this instance), from here you can connect to a datasource, design, create and preview reports - all from the comfort of your machine. There are even wizards to help you get up and started. You will see these under a new section in the "create new project" dialog called "business intelligence"
What this essentially does is to create a report file (an XML file with an .RDL extension) and a datasource file (.RDS extension)
b) Using the report:
You will need to install the RS components on a server. RS is accessed via http(s) and needs a SQL Server db to store information about the reports. They can both reside on the same box.
The tool for managing the RS site is called 'report manager' and is a web based tool.
http://localhost/reports
Once you have this set up (including security), simply deploy your report from step 1 and you're good to go - you can do this by simply 'right clicking/ deploy' on your new report in VS.net
c) At this point you'll have a good understanding of how it all works so adding the report viewer control to your app will be simple.
1）安装非常简单。甚至不确定你是否真的需要指示，除非你正在做一些特别的事情。我将其作为基本 SQL 2008 安装的一部分进行安装，非常简单。这是一个可以帮助您的链接。 http://msdn.microsoft.com/en-us/ library/bb839480(SQL.90).aspx
安装后，只需打开 Reporting Service 配置管理器，您就可以稍后更改任何数据或设置。您还可以看到该服务器访问报告的链接以及在哪里编辑它们。仅供参考，需要安装 IIS 来托管前端报告页面。
2) 浏览至“报告管理器 URL”。您可以从 Reporting Service 配置管理器获取此信息。默认安装可能会将其安装为
http://127.0.0.1/Reports/，插入任何IP，但如果登录到应该工作的服务器。从那里，您可以单击并安装“Report Builder”[在顶部菜单栏]。我认为它安装版本 1，如果是版本 1，我建议从 Microsoft [免费] 下载并安装 Report Builder 2.0？报告生成器 3 也可用，但该版本需要 R2。下载并安装该应用程序后，您可以从那里构建所有报告，还可以链接到您的服务器并自动上传它们。安装并运行该程序后非常容易。没有出价的理由。
3）也许是最简单的部分！使用VS中已经创建的“Report Viewer”控件。在控件中输入 SSRS 的正确 URL 路径以及要提取和宾果的报告。
这是为您提供的一个很好的演练。在报表生成器中创建报表并在 ASP 页面上访问它们。 http://msdn.microsoft.com/en-us/库/ms251686(VS.80).aspx
1) It is really easy to install. Not even sure you really need instructions unless you are doing something special. I installed it as part of the base SQL 2008 install and it was straight forward. Here is a link that may help you out. http://msdn.microsoft.com/en-us/library/bb839480(SQL.90).aspx
Once installed, just open the Reporting Service Configuration Manager and you can change any data or settings at a later time. You also see what the links are for that server to get to the reports and where to edit them. FYI, IIS will need to be installed to host front end report page.
2) Browse to the "Report Manager URL". You can get this from the Reporting Service Configuration manager. Default install would probably install it as
http://127.0.0.1/Reports/, plug in whatever IP but if logged into the server that should work.From there, you can click on and install "Report Builder" [on top menu bar]. I THINK it installs version 1, if it is version 1, I recommend downloading and installing Report Builder 2.0 from Microsoft [free]? Reports builder 3 is also available but you need R2 for that version. Once you download and install the app you can build all your reports from there and can also link up to your server and auto upload them. Very easy once you install and run this program. No reason for BIDS.
3) Maybe the easiest part! Use the already created "Report Viewer" control in VS. Enter the correct URL path of SSRS in the control and which report to pull and bingo.
Here is a nice walk through for you. From creating reports in Report Builder and accessing them on ASP page. http://msdn.microsoft.com/en-us/library/ms251686(VS.80).aspx