471,595 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,595 software developers and data experts.

Crystal Reports Out Joins with DataSet?

I'm trying to create a Crystal Report based on a strongly-typed DataSet
(that I'm populating manually instead of from a database). This is almost
working except Crystal seems to always do inner joins along the
relationships in the DataSet, but I want an outer join.

I have a table (QuestionTable) that's a list of questions. Each row
contains the question, as well as the foreign key to a row in AnswerTable
(which contains the description/text for the selected answer). I have a
Relation connecting QuestionTable to AnswerTable.

If I only include fields from QuestionTable in my report, then I get all
rows from QuestionTable in my report (even if the AnswerId field is blank).
This is good. If I try to include the AnswerTable.Description field in my
report however, then the report only shows the rows from QuestionTable where
there is a value for QuestionTable.AnswerId. Crystal seems to be doing an
inner join between QuestionTable and AnswerTable. But I want an outer join.
I want to display all questions, and the answer description for the
questions that have been answered. How can I do this?

VS 2005 Team Suite, C#, ASP.NET 2.0
Jan 3 '07 #1
1 1750

Figured it out... on the "Links" tab of the 'Database Expert' I can change
how the links (relationships) work.
Jan 3 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by kristoff plasun | last post: by
4 posts views Thread by Rick Thiel | last post: by
3 posts views Thread by John Smith | last post: by
reply views Thread by Maqsood Ahmed via .NET 247 | last post: by
2 posts views Thread by =?Utf-8?B?Um9zcyBNYXNvbg==?= | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.