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

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

Jedi, thanks much. I thought I was going insane until I blew that damn file away.jpshahan

Thank you so much! Just thought I'd mention that it works better if you close VS first and reopen after deleting the .rdl.data file, that's what worked for me. Apparently, doing this ALSO cleared up the 'attempting to write to corrupt memory' error that I kept getting. So thank you thank you thank you! Finally someone on these forums with a proper answer that works. I'm really tired of mediators spouting crap and then marking it themselves as the answer!

*SALUTE* Thankyou Jedi - this is a most annoying bug.Josh Ash

I still get a warning regarding this field even though it is no longer referenced anywhere in the RDL...Josh Ash

Hi Josh Thanks for your posting. Did you try to right click on you RDL and click on View code and try to search the Report xml if you find anything(Reference) Many Thanks Syed Qazafi Anjum

Hi Josh Thanks for your posting. Did you try to right click on you RDL and click on View code and try to search the Report xml if you find anything(Reference) Many Thanks Syed Qazafi Anjum Yes, the only place it is referenced is the field list. Josh Ash