SSRS 2008 - add column to table and get error
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
March 16th, 2011 4:48pm

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
Free Windows Admin Tool Kit Click here and download it now
March 16th, 2011 5:26pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics