October 22, 2014 at 2:55 pm
I have noticed an irritating behavior in BIDS (Visual Studio) 2010 when developing Reporting Services reports, and I am not sure if it's specific to VS2010, or if it's specific to me, but wanted to see if anyone else here has seen it and may have a fix...
For example, I have a report that displays a list of orders with customers, and if you click on the one of the customer names it opens that customer in our Dynamics CRM environment. It does this via the Action property of the textbox, and goes to the following URL:
="http://CRMserver/MyCompany/main.aspx?etc=2&id=%7b" & CStr(Fields!CustomerID.Value) & "%7d&pagetype=entityrecord"
This works perfectly well.
However, if I copy that textbox and paste it either to another part of the table, or even into the same table, it gets converted to this in the new textbox:
="http://CRMserver/MyCompany/main.aspx?etc=2&id=%7b" & Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions.cstr(Fields!CustomerID.Value) & "%7d&pagetype=entityrecord"
Basically, it's adding the Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions. string of text. I wouldn't care, except that when I try running the report I get the following error:
[BC30456] 'RdlObjectModel' is not a member of 'ReportingServices'
At which point, I have to go in and delete that additional string. Easy enough, but it becomes annoying to have to do it every time, especially when there are a large number of them. It seems to happen any time I use any of the common functions -- "CSTR" for example.
So basically I would like to know, has anyone else seen this behavior in VS2010? And, more to the point, does anyone know of a way to prevent it from happening? Ideally, I'd like to prevent it from adding that bit of code; at the very least, I'd like that code to actually work when it's added.
Thanks in advance 🙂
October 23, 2014 at 12:54 am
This is a known bug:
Pasting objects with expressions pastes fully qualified functions
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 23, 2014 at 3:08 pm
Koen Verbeeck (10/23/2014)
This is a known bug:Pasting objects with expressions pastes fully qualified functions
Yeah, I saw that but that site is notorious for not following up on issues, and it was dated over a year ago... was hoping someone might have found something since then.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply