I am trying to produce SSRS reports to integrate with a MOSS Dashboard. Reporting Services 2005 only seems to be able to render .xls out of the box. Does SSRS 2008 have the ability to render in xlsx format?
我正在尝试生成SSRS报告以与MOSS仪表板集成。 Reporting Services 2005似乎只能提供开箱即用的.xls。 SSRS 2008是否能够以xlsx格式呈现?
2 个解决方案
#1
To the best of my experience, exporting to excel2007 is not built into SSRS2008, you need to get an external component for that. Currently looking into what is available on the market, i'll get back to you with what i find.
根据我的经验,导出到excel2007并没有内置到SSRS2008中,您需要为此获得外部组件。目前正在研究市场上有哪些产品,我会用我发现的东西回复你。
Edit:
Ok had a look at both aspose.cells and OfficeWriter by SoftArtisans. Both claim to offer .xlsx-exporting capabilities for SSRS, but in both cases this is a partial truth at best.
好的,看看SoftArtisans的aspose.cells和OfficeWriter。两者都声称为SSRS提供.xlsx导出功能,但在这两种情况下,这都是最好的部分事实。
Both work by having you recreate your report in Excel using their respective add-ons, and then pasting their own markup into your RDL-file. This also has the effect that if you are making an excel-exportable report in either tool, you won't be able to view or export it in anything else from SSRS. Both have the ability to open an existing report and access their datasets from there, which is a major advantage over trying to get MSQuery to work for you.
两者都可以使用各自的附加组件在Excel中重新创建报表,然后将自己的标记粘贴到RDL文件中。这也会导致如果您在任一工具中创建可导出Excel的报表,您将无法从SSRS查看或导出其他任何内容。两者都能够打开现有报告并从那里访问其数据集,这比尝试让MSQuery为您工作更具优势。
Aspose suffers from various issues with permissions on the server, where you need to grant it full trust (not everyone would want that). I also had a major hassle getting it installed properly.
Aspose在服务器上遇到各种权限问题,你需要授予它完全信任(不是每个人都希望这样)。我也有一个很大的麻烦,正确安装它。
OfficeWriter has some issues with shared datasources, where you generally have to go in and set them manually after you've published your report. It also seems to choke on VS2008 RDLs, if you want to use a dataset from a VS2008 report, you have to make a new report in VS2005 with your dataset, and use that as a basis for your excel-built report.
OfficeWriter在共享数据源方面存在一些问题,您通常必须在发布报告后手动设置它们。它似乎也扼杀了VS2008 RDL,如果你想使用VS2008报告中的数据集,你必须在VS2005中使用你的数据集创建一个新报告,并将其用作你的excel构建报告的基础。
Personally I don't care much for either. But overall Officewriter does seem like it comes out ahead. Next stop is figuring out if it has built-in support for matrices, or that is something we would have to program in VB to get.
就个人而言,我也不在乎。但整体Officewriter确实看起来像未来。下一步是确定它是否内置了对矩阵的支持,或者这是我们必须在VB中编程才能获得的。
#2
According to Exporting to Microsoft Excel(msdn)
根据导出到Microsoft Excel(msdn)
The Excel rendering extension renders a report that is compatible with Microsoft Excel 97 and later.
Excel呈现扩展插件呈现与Microsoft Excel 97及更高版本兼容的报表。
This seems to suggest the old format.
这似乎暗示了旧的格式。
#1
To the best of my experience, exporting to excel2007 is not built into SSRS2008, you need to get an external component for that. Currently looking into what is available on the market, i'll get back to you with what i find.
根据我的经验,导出到excel2007并没有内置到SSRS2008中,您需要为此获得外部组件。目前正在研究市场上有哪些产品,我会用我发现的东西回复你。
Edit:
Ok had a look at both aspose.cells and OfficeWriter by SoftArtisans. Both claim to offer .xlsx-exporting capabilities for SSRS, but in both cases this is a partial truth at best.
好的,看看SoftArtisans的aspose.cells和OfficeWriter。两者都声称为SSRS提供.xlsx导出功能,但在这两种情况下,这都是最好的部分事实。
Both work by having you recreate your report in Excel using their respective add-ons, and then pasting their own markup into your RDL-file. This also has the effect that if you are making an excel-exportable report in either tool, you won't be able to view or export it in anything else from SSRS. Both have the ability to open an existing report and access their datasets from there, which is a major advantage over trying to get MSQuery to work for you.
两者都可以使用各自的附加组件在Excel中重新创建报表,然后将自己的标记粘贴到RDL文件中。这也会导致如果您在任一工具中创建可导出Excel的报表,您将无法从SSRS查看或导出其他任何内容。两者都能够打开现有报告并从那里访问其数据集,这比尝试让MSQuery为您工作更具优势。
Aspose suffers from various issues with permissions on the server, where you need to grant it full trust (not everyone would want that). I also had a major hassle getting it installed properly.
Aspose在服务器上遇到各种权限问题,你需要授予它完全信任(不是每个人都希望这样)。我也有一个很大的麻烦,正确安装它。
OfficeWriter has some issues with shared datasources, where you generally have to go in and set them manually after you've published your report. It also seems to choke on VS2008 RDLs, if you want to use a dataset from a VS2008 report, you have to make a new report in VS2005 with your dataset, and use that as a basis for your excel-built report.
OfficeWriter在共享数据源方面存在一些问题,您通常必须在发布报告后手动设置它们。它似乎也扼杀了VS2008 RDL,如果你想使用VS2008报告中的数据集,你必须在VS2005中使用你的数据集创建一个新报告,并将其用作你的excel构建报告的基础。
Personally I don't care much for either. But overall Officewriter does seem like it comes out ahead. Next stop is figuring out if it has built-in support for matrices, or that is something we would have to program in VB to get.
就个人而言,我也不在乎。但整体Officewriter确实看起来像未来。下一步是确定它是否内置了对矩阵的支持,或者这是我们必须在VB中编程才能获得的。
#2
According to Exporting to Microsoft Excel(msdn)
根据导出到Microsoft Excel(msdn)
The Excel rendering extension renders a report that is compatible with Microsoft Excel 97 and later.
Excel呈现扩展插件呈现与Microsoft Excel 97及更高版本兼容的报表。
This seems to suggest the old format.
这似乎暗示了旧的格式。