| T O P I C R E V I E W |
| anavagomez |
Posted - 08/22/2012 : 14:18:03
Is it possible to upload a crystal report that uses data from a linked server?
Is possible would you mind explaining how to accomplish this?
Thank you very much.  |
| 3 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 08/23/2012 : 11:29:33
This error might nothing to do with the fact that your report is using a linked server. Please make sure that your Crystal report is using Microsoft OLE DB Provider for SQL Server. http://www.reportportal.com/help/crystal/example.htm
Which authentication type are you using for your linked server: Windows or SQL Server? |
| anavagomez |
Posted - 08/23/2012 : 08:20:19
I did exactly that, but when I open the report and get to the screen where to select the input parameters, and click view report, I get a screen that reads:
The report you requested requires further information.
And shows all the fields to provide the database server info.
|
| admin |
Posted - 08/22/2012 : 16:08:57
You can point a Crystal Report to a SQL Server linked server. Steps:
1. Define a linked server on your SQL Server: http://msdn.microsoft.com/en-us/library/ff772782
2. Create a Crystal report based on the linked server. For example, if your linked server is LinkedServer1 and table name is Table1 the SQL will be:
Select * from LinkedServer1.Database1.dbo.Table1
3. When uploading the Crystal Report to ReportPortal, select the connection that points to the server where the lined server is defined. |
Report Portal
