I have a report with multiple datasets for an existing report. I am adding a field to one of these datasets (Monthly Summary) titled BonusYTD. When I run the sp in the SSRS query designer it shows that the field BonusYTD is populated but when I place the field in the table it shows nothing. I have checked the textbox to see if it had an hidden properties and even went to a different textbox that was displaying data and changed the field to BonusYTD and it still didn't show up. I checked my connection to ensure I was previewing the report on the correct development server and refreshed the fields again in the dataset. I am not understanding why the field BonusYTD is showing up in the list of available fields for this dataset yet the textbox that I put it in is not displaying any data. Please help.

Hi, Could you please perform below steps and let me know if this works ? 1. Refresh the data set and check for all required field once. 2. Drag and drop only the required field (single field) on the data region and execute the report. 3. If it doesnt work, please remove the table altogether and create a new table with relevant fields. 4. If it doesnt work, replace the dataset with new one and try again by binding the latest dataset with the table. Regards, Niraj

Hi There Normally when we preview a report the data for the report is cached to a file on the local computer. When we preview the report again using the same query, parameters, and credentials, Report Designer retrieves the cached copy rather than running the query. The data file is normally saved as <yourreportname>.rdl.data in the directory as the report definition file save. Normally the cached file doesnt work once we modify the query. At this time, I can suggest that you please delete the cached .rdl.data file and then check the problem again. If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.