tags:

views:

502

answers:

2
+1  Q: 

SQL Reporting Services Express: datasource to external server

Using SSRS 2008 Express Edition, is it possible to create a datasource that connects to an external SQL server, or is it artificially limited to same SQL Server and instance of that Reporting Services engine?

+1  A: 

I figured out myself. You can not define an external datasource.

See: MSDN

 2008-12-10 14:06:09
A: 

You could try using a linked server, where you would just call the procedures in the remote (linked) data source.

 2008-12-17 07:13:10

related questions

Strip HTML from string in SSRS 2005 (VB.NET)
SQL Server 2008 Reporting Services Control
How do I resolve a System.Security.SecurityException with custom code in SSRS?
Sending e-mail from a Custom SQL Server Reporting Services Delivery Extension
How to aggregate data from SQL Server 2005
Is there a Box Plot graph avalible for Reporting Services 2005?
How do I set a textbox to multi-line in SSRS?
SQL 2005 Reporting Services custom report item (CRI) - what are the limits?
SQL Reporting Services viewer for webpage - can you move the View Report button?
Custom font in SQL Server 2005 Reporting Services
I can share a SQL Server Reporting Services Data SOURCE... what about a Data SET?
Enterprise Reporting Solutions
Internationalization in SSRS
Easy way for Crystal Reports to MS SQL Server Reporting Services conversion
SSRS - Post Publishing Tasks
SSRS - Process dies/goes to sleep after not being used
SSRS - RSS Feeds
SSRS - Uninstall Trial Version of VS Business Intelligence
Optimizing the PDF Export of Huge Reports in Sql Reporting Services 2005
SSRS scheduled reports not working.
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
How do you handle audit logging with SSRS?
Reading recommendations for: SQL Server 2005 Reporting Services
How can I dynamically center an image in a MS Reporting Services report?