Crystal Reports - Certain Output From Sql Not Displaying

I'm currently attempting to fix an issue with a Crystal Report/SQL stored procedure related to certain rows returned from a stored procedure not displaying. A little background: A

Solution 1:

are the tables correctly linked? Sounds like this could be a INNER JOIN vs OUTER JOIN issue.

the part about restricting a result from within crystal - If I understand this correctly you need to use the select expert. Choose the field in question and choose something like "is not equal to" and put the value in.

Solution 2:

since you can see the records returned from stored procedure... below are few points that will help you:

1. select expert in crystal report works as where clause... So if you want the limit the data to the report then you can place your conditions in select expert.
2. If you are using parameters in the report and value in parameter is not matching with the data returned by stored procedure then also CR will be blank.
3. Check the database connection to crystal report whether you are connecting to correct database or not.