Post reply

SSRS Reports column all values not Displaying

  • November 6, 2015 at 10:52 pm

    #309554

    Hi, I am new in SSRS. I am fetching values from oracle database in my reports using stored procedure. It's an existing ssrs report where I have added two new columns. I have used join to fetch records from two table on the basis of ID. Report is displaying the fields but all the expected records are not coming, only few are displaying. When I am running procedure in the oracle. It is returning all values, but in report I am getting only few value. Can anyone help me how to resolve this issue.

  • November 9, 2015 at 11:05 am

    #1838632

    hard to tell from the limited description, but you may need to use an OUTER JOIN instead of an INNER in your query. INNER by definition is "lossy", so any records without a corresponding key value in the other table will be eliminated from the final result.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply