Data pull

[blandow]

I am new to Crystal. I am using ver XI.

I am simply creating a query to pull some basic information
from a very large database.

What I can't understand is, when I run the same query on the same database through excel, I get a larger set of results than I do with Crystal. Why would Crystal not report back the same data?

 

[lbass]

Are you using multiple tables? You might need to use a different type of join or it could result from selection criteria on tables to the right of a left join.

You could copy the query into this thread and then tell use what you are expecting to see--all results from one table, some from another, etc.

-LB

 

[Madawc]

One common problem is when you take data from two tables, A and B, with a shared account number. If you do an ordinary link, you get just the cases where there are details just on table A.

The standard solution is to make the link a left-outer, meaning that it's OK to show Table A records without a coresponding Table B record.

This too can run into problems. If you link table A to table B using a left-outer, but then put a condition on table B, it treats it as if it was an equals join, refused to show table A entries without a table B entry. This is part of Crystal's general habit of stopping whenever it gets a null value. When the table B entry is absent, all of its fields are null.

You get round this by including a test for null value first, followed by the table-B condition.

An alternative is to remove the table B test and suppress the data you do not want. You don't say exactly what you are doing: possible methods are a lower-order group with details suppressed, or a logical test to blank fields that you do not want.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP