Losing information in a report

[NoExperienceInUtah]

I can't figure out why this is happening. Any help would be greatly appreciated.

I have a report with just one group, it pulls almost ALL of the information it needs from one table in my database. There are 2 fields however that I need it to report that aren't located in that table. So I created a table and added those two fields to the table along with one common field for linking. When I browse the field data for those fields, I get exactly what I expect to see in those fields, and if I run my report without inserting them into it, I get all 20 hits that I should, but when I insert the field from the other table, all 20 entries dissapear from my report. You'll probably need more information, but it may be a simple fix. Any suggestions?

Thanks!

 

[synapsevampire]

Change the linking to a Left Outer and see if that resolves it.

-k

 

[Ngolem]

Crystal is smart enough not to get anymore data then it needs for the report. Since in the first case you don't use any fields from the second table, it just gets the data from the main table. When you add the other fields...now it makes the link and tries to make the appropriate records.

As SV says...check you links and play with the join. Is the linking field EXACTLY the same in both tables....sometimes there might be an empty space added to a character...In the Visual linking editor...browse the data of both fields and see they are what you expect.

Jim Broadbent