Officewriter Excel Report - bc30277 Type character '!' does not match

Question

Hi guys,

i have an officewriter report that i am trying to publish to SQL Reporting services through excel. This is a parameterized report with just 1 input parameter. When i click on 'Publish' in officewriter toolbar, there is an error.

It says 'the value expression for the query parameter '@test' contains an error: [bc30277] Type character '!' does not match declared data type 'Microsoft.ReportingServices.....'.

any ideas?

should i be deploying this from visual studio instead?

TIA

Answer 1

Fixed it!

It turns out officewriter or maybe ms-excel adds an '@' character in the .rdl file upon saving the report.

before: [email protected]

after: =Parameters!test.Value