?
Solved

Process of Joining multiple BEx Queries in Crystal

Posted on 2014-03-28
1
Medium Priority
?
287 Views
Last Modified: 2014-04-22
I have 4 independent BEx queries feeding a crystal report.   I am wondering what is the process of joining them.   I know you join by linking similar fields ( or the ones you know are related to each other).   But how do I know which characteristic is the key and which object it should be joined to from other query?   Crystal 2011 crashes when I try to join more than 2 BEx?

Thanks.
0
Comment
Question by:zafridi
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 39962010
Related question

http://www.experts-exchange.com/Database/Reporting/Crystal_Reports/Q_28397008.html

I think rhinok's comment in your previous question is at least part of the answer.

BEX queries are external to Crystal so trying to join them is probably not fully supported in Crystal.

mlmcc
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses
Course of the Month12 days, 16 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question