ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

Username:	Password:
Save Password
Forgot your Password?

All Forums

ReportPortal General Forum

Report Portal General Issues

using linked servers on crystal report

New Topic

Reply to Topic

Printer Friendly

Author

Topic

anavagomez

29 Posts

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.

admin

1635 Posts

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.

anavagomez

29 Posts

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

1635 Posts

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?

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

ReportPortal