I had an existing report that was just moved over from SSRS2005. I needed to add columns to this report. I'm adding this information into the table(tablix) control. I'm not summarzing anything at the moment. I changed the proc to include the new data & refreshed the fields in the Visual Studio. I added the new data into the table and this is the error i'm getting [rsInvalidExpressionDataType] The Value expression used in textrun ‘NetCreditsTotal.Paragraphs[0].TextRuns[0]’ returned a data type that is not valid. The data type of this new data is money, although i have other money fields in this report. This new data shows up in the visual studio query. When the data displays on the report is dispays as #ERROR Any help would be appreciated. ro

I have fixed this report by creating a new report - copying and pasting the exact controls from the old report to the new report. For some reason those new columns are now working the way I would have expected them to in the first place. If someone know a simplier remedy for this issue or knows what this error means i would still like to hear about it. Thank-you ro

A simpler and quicker fix for this is to delete the <ReportName>.rdl.data file from the file system. I'm guessing that the .rdl.data file is created as some kind of cached field lookup by the report designer, and although changing the fields in the designer updates the .rdl XML file, the .rdl.data file seems to easily fall out of sync with the fields in the .rdl file. Deleting the file seems to force the designer to requery the fields afresh and they then work.

I had this same exact problem. Deleting the report.rdl.data file did the trick, Thanks.-Erik