Why some of columns Data is not displaying in SSRS report ?

Question

In my particular report storeprocedure is used for the data. Now the problem is some of the columns are not displayed in report even storeprocedure return all data correctly.

Manas Mohapatra · Answer

1. Please make sure that SSRS report is properly mapped with data retrieved from Stored procedure. 2. Please check if some column value is NULL. If NULL make it as empty string(ISNULL(col1 '')). Also Trim the column when you are binding to report. 3. Delete the .data file. Because when we create a SSRS report it creates .rdl and .data file. Sometimes .data don't work properly. So remove it and SSRS will generate it properly. If it doesn't resolve your problem provide the screen with error details.

Parinita Yadav · Answer

Problem is Store procedures column mapping was wrong. Thank you Manas