Skip to Content
author's profile photo Former Member
Former Member

Crystal Reports External Link

Hi Gurus,

Can anyone let me know in detail about External Link in crystal report. I did a search in sdn and in google but not found a good document on this topic.

I'm in need of writing a crystal report on top of two heterogeneous databases.

Thanks in Advance!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jan 06, 2014 at 04:16 PM

    hello Abhi,

    you may wish to look into creating a subreport on the secondary database. you would then link the subreport based on the common field between the two.

    -jamie

    Add a comment
    10|10000 characters needed characters exceeded

    • here's some info on Linked Servers in ms sql server. there also may be licensing implications with sap ecc etc by using this method...you'd need to check with your admin on that one.

      other method other than subreports would be just adding both connections to the report in the database expert and linking them there, and then hope that the performance is acceptable. otherwise see Don's subeport method above if this is really slow.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.