我正在利用2008年的SSRS编写报告。 是否可能从多个数据来源编写一份报告?
感谢。
With SQL Server Reporting Services 2008 R2 you can use the lookup functions to lookup a piece of data from a second dataset: http://blog.datainspirations.com/2010/03/19/sql-server-2008-r2-reporting-services-look-up-look-down-look-all-around-part-i/ Very handy.
From older versions of SSRS, you can create a subreport that occupies a cell in a table: the subreport can be called with a different parameter for every row, effectively "joining" to the second dataset. http://technet.microsoft.com/en-us/library/ms160348.aspx
是的,你可以使用多种数据来源。 虽然你可以加入数据。 例如,你可以有一份表格,列出两个数据来源的田地。 BUT 您可以拥有来自Oracle的数据来源和来自MSQ的数据来源。 你可以使用清单把事情合在一起。
一般来说,如果你能够而且确实在你的询问中工作,你就希望使用连接的服务器。
但是,如果你利用某种技术将这一数据从数据库中合并,即采用存储程序,则不可能在单一报告中提供多种数据来源的数据。 而且,如果您所储存的程序回归多种结果,你必须做些事情,把数据加到表格中,并作为单一结果退回合并数据,这种结果并非可怕的,而是在你最初提出的问题上,你可以很容易地在一份报告中使用多种数据来源。
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would ...
I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable. CREATE ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8
