开发者

Reporting services and custom library

开发者 https://www.devze.com 2022-12-30 18:45 出处:网络
Greetings, In my Reporting Services report I\'ve added reference to my custom library. It works fine. I can display the string which is returned from my custom library method as follows:

Greetings, In my Reporting Services report I've added reference to my custom library. It works fine. I can display the string which is returned from my custom library method as follows:

=ClassLibrary1.MyClass.Parse("harry potter")

Above code works fine - it should return SQL query based on passed parameters. My question is, how can I use this code in my DataSource. I'm trying to do something like this:

SELECT * FROM =ClassLibrary1.MyClass.Parse(@searchedPhrase)

But the above cod开发者_Python百科e does not work and the error is returned :"Incorrect syntax near ="


finally I made it. I've assigned this method to hidden field as follows =Code.MyClass.Parse(Parameters!queryParameter.Value)

then in my DataSource I created a parameter which references to this hidden field. I little bit tricky but it fulfill its role

0

精彩评论

暂无评论...
验证码 换一张
取 消