Microsoft Reporting Services和CSV文件

时间:2020-12-19 08:18:56

I manage a data warehouse type application and one of the databases it connects to is about to be managed by an external organisation. The external organisation is setting up Microsoft Reporting Services to allow us to generate reports for our users to be able to view the data.

我管理数据仓库类型的应用程序,它连接的一个数据库即将由外部组织管理。外部组织正在设置Microsoft Reporting Services,以允许我们为用户生成报告以便能够查看数据。

The database is hosted on an external server. I have setup a test form in Microsoft Reporting Services in a test environment.

数据库托管在外部服务器上。我在测试环境中的Microsoft Reporting Services中设置了一个测试表单。

I don't have any other experience with this technology. My question is: does this technology enable you to generate CSV files or does the information have to be viewed in a web browser? I can't see how this can be done without web services.

我对此技术没有任何其他经验。我的问题是:这项技术能让您生成CSV文件,还是必须在网络浏览器中查看信息?如果没有Web服务,我无法看到如何做到这一点。

3 个解决方案

#1


4  

Yes SSRS (Reporting services) has a build in capability to export reports to these types of files

是SSRS(报告服务)具有将报告导出到这些类型的文件的内置功能

  • XML
  • Word
  • CSV
  • MHTNK
  • Excel
  • PDF
  • Tiff

Microsoft Reporting Services和CSV文件

I am also managing a data warehouse which accessible for customers. We also providing the reporting services hosting service

我还管理着一个可供客户访问的数据仓库。我们还提供报告服务托管服务

But to your question if you have reporting services installed, you can connect to any database you wish (of course if you have permissions)

但是对于你的问题,如果你安装了报告服务,你可以连接到你想要的任何数据库(当然,如果你有权限)

To create a report you will need:

要创建报告,您需要:

  1. A data source - tells the report that it's going to connect to some server and some DB
  2. 数据源 - 告诉报告它将连接到某个服务器和某个数据库

  3. Dataset- holds information most of the times which comes from a query against a database
  4. 数据集 - 大部分时间保存来自对数据库的查询的信息

  5. Design the report
  6. 设计报告

So when you create a data source you can provide ant server name / IP and any database name. (of course you will have to have permissions)

因此,在创建数据源时,您可以提供ant服务器名称/ IP和任何数据库名称。 (当然你必须拥有权限)

This is a picture which shows you how to create a data source Microsoft Reporting Services和CSV文件

这张图片向您展示了如何创建数据源

#2


2  

You seem to be asking two related but different things:

你似乎在问两个相关但不同的东西:

Q1: Can you generate in format X (in your question: X = CSV).
A: Yes, you can export to CSV, XML, XLS, PDF, Word, Html, and Tiff (MSDN). Note that the report has to be tailored towards your preferred export method, e.g. if you want to get CSV it's best to stick to just a simple report with merely a table, or with XML it's rather important to name all controls as they turn into element names.

Q1:你能用格式X生成(在你的问题中:X = CSV)。答:是的,您可以导出为CSV,XML,XLS,PDF,Word,Html和Tiff(MSDN)。请注意,报告必须根据您的首选导出方法进行调整,例如如果你想获得CSV,最好只关注一个只有一个表的简单报告,或者使用XML,将所有控件命名为元素名称是非常重要的。


Q2: How do you view/get a report? Does it have to be viewed in a browser?
A: There are several ways to deliver reports to end users and other systems, including:

Q2:您如何查看/获取报告?是否必须在浏览器中查看?答:有几种方法可以向最终用户和其他系统提供报告,包括:

  • Subscriptions, delivered through e-mail or FTP
  • 订阅,通过电子邮件或FTP传递

  • Through the ReportViewer (either in a web app or in a native app)
  • 通过ReportViewer(在Web应用程序或本机应用程序中)

  • A specific case of the "web app", being via a Sharepoint setup
  • 通过Sharepoint设置的“Web应用程序”的特定情况

  • Via the web service provided with SSRS
  • 通过SSRS提供的Web服务

  • Directly, using (pre)views in the Report Manager
  • 直接在报表管理器中使用(预)视图

#3


0  

If you are talking about SSRS, the answer is Yes.

如果你在谈论SSRS,答案是肯定的。

The external organization will have the choice to implement SSRS in one of 2 ways: stand-alone or embedded. Stand-alone means reports will run independent of any web applications or desktop applications they may have. This way, they set up a SQL Server that supports Reporting Service. Embedded means reports will run from a web application or desktop application.

外部组织可以选择以两种方式之一实施SSRS:独立或嵌入式。独立意味着报告将独立于他们可能拥有的任何Web应用程序或桌面应用程序运行。这样,他们就建立了一个支持Reporting Service的SQL Server。嵌入式意味着报告将从Web应用程序或桌面应用程序运行。

Either way, SSRS allows reports to be exported to different formats: PDF, Excel, CSV.

无论哪种方式,SSRS都允许将报告导出为不同的格式:PDF,Excel,CSV。

http://msdn.microsoft.com/en-us/library/dd239307.aspx

#1


4  

Yes SSRS (Reporting services) has a build in capability to export reports to these types of files

是SSRS(报告服务)具有将报告导出到这些类型的文件的内置功能

  • XML
  • Word
  • CSV
  • MHTNK
  • Excel
  • PDF
  • Tiff

Microsoft Reporting Services和CSV文件

I am also managing a data warehouse which accessible for customers. We also providing the reporting services hosting service

我还管理着一个可供客户访问的数据仓库。我们还提供报告服务托管服务

But to your question if you have reporting services installed, you can connect to any database you wish (of course if you have permissions)

但是对于你的问题,如果你安装了报告服务,你可以连接到你想要的任何数据库(当然,如果你有权限)

To create a report you will need:

要创建报告,您需要:

  1. A data source - tells the report that it's going to connect to some server and some DB
  2. 数据源 - 告诉报告它将连接到某个服务器和某个数据库

  3. Dataset- holds information most of the times which comes from a query against a database
  4. 数据集 - 大部分时间保存来自对数据库的查询的信息

  5. Design the report
  6. 设计报告

So when you create a data source you can provide ant server name / IP and any database name. (of course you will have to have permissions)

因此,在创建数据源时,您可以提供ant服务器名称/ IP和任何数据库名称。 (当然你必须拥有权限)

This is a picture which shows you how to create a data source Microsoft Reporting Services和CSV文件

这张图片向您展示了如何创建数据源

#2


2  

You seem to be asking two related but different things:

你似乎在问两个相关但不同的东西:

Q1: Can you generate in format X (in your question: X = CSV).
A: Yes, you can export to CSV, XML, XLS, PDF, Word, Html, and Tiff (MSDN). Note that the report has to be tailored towards your preferred export method, e.g. if you want to get CSV it's best to stick to just a simple report with merely a table, or with XML it's rather important to name all controls as they turn into element names.

Q1:你能用格式X生成(在你的问题中:X = CSV)。答:是的,您可以导出为CSV,XML,XLS,PDF,Word,Html和Tiff(MSDN)。请注意,报告必须根据您的首选导出方法进行调整,例如如果你想获得CSV,最好只关注一个只有一个表的简单报告,或者使用XML,将所有控件命名为元素名称是非常重要的。


Q2: How do you view/get a report? Does it have to be viewed in a browser?
A: There are several ways to deliver reports to end users and other systems, including:

Q2:您如何查看/获取报告?是否必须在浏览器中查看?答:有几种方法可以向最终用户和其他系统提供报告,包括:

  • Subscriptions, delivered through e-mail or FTP
  • 订阅,通过电子邮件或FTP传递

  • Through the ReportViewer (either in a web app or in a native app)
  • 通过ReportViewer(在Web应用程序或本机应用程序中)

  • A specific case of the "web app", being via a Sharepoint setup
  • 通过Sharepoint设置的“Web应用程序”的特定情况

  • Via the web service provided with SSRS
  • 通过SSRS提供的Web服务

  • Directly, using (pre)views in the Report Manager
  • 直接在报表管理器中使用(预)视图

#3


0  

If you are talking about SSRS, the answer is Yes.

如果你在谈论SSRS,答案是肯定的。

The external organization will have the choice to implement SSRS in one of 2 ways: stand-alone or embedded. Stand-alone means reports will run independent of any web applications or desktop applications they may have. This way, they set up a SQL Server that supports Reporting Service. Embedded means reports will run from a web application or desktop application.

外部组织可以选择以两种方式之一实施SSRS:独立或嵌入式。独立意味着报告将独立于他们可能拥有的任何Web应用程序或桌面应用程序运行。这样,他们就建立了一个支持Reporting Service的SQL Server。嵌入式意味着报告将从Web应用程序或桌面应用程序运行。

Either way, SSRS allows reports to be exported to different formats: PDF, Excel, CSV.

无论哪种方式,SSRS都允许将报告导出为不同的格式:PDF,Excel,CSV。

http://msdn.microsoft.com/en-us/library/dd239307.aspx