Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Passing dataset as parameter to custom assembly in SSRS 208 R2

Answered Passing dataset as parameter to custom assembly in SSRS 208 R2

  • Thursday, May 10, 2012 5:09 AM
     
     
    Sign In to Vote
    0

    Hi,


    I have one requirement to create dynamic image in SSRS. In my report I have the required data in dataset and one custom assembly to draw the image. But problem is I am unable pass the dataset as parameter to assembly.
    I am using SQL 2008 R2 and VS 2008.

    =Code.MyCustomClass.Returnimage(Dataset1)

    Regards,

    MVA.Raju

    Raju Malla

     

All Replies

  • Thursday, May 10, 2012 5:19 AM
     
     
    Sign In to Vote
    0

    Passing image as parameter from the client 

    Dim FileImage As String = "file:" & GeneralParams.PersonalPicPath & picname & ".jpg"


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

     
  • Thursday, May 10, 2012 6:32 AM
     
     
    Sign In to Vote
    0

    Below is my custom code function. Using this function I need to pass dataset to custom assembly.

    =Code.MyClass.DsTest(Dim dsdata As DataSet="DataSet1")

    Is it possible to pass dataset as parameter in SSRS 2008 R2?

    Regards,

    MVA.Raju.

    Raju Malla

     
  • Thursday, May 10, 2012 6:34 AM
     
     
    Sign In to Vote
    0
    I do not think so, but sorry cannot test it right now

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

     
  • Tuesday, May 15, 2012 8:26 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello Raju,

    We cannot pass the dataset name as a parameter into the report's custom code. For more information, please refer to the related thread below:
    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/a7d59224-0ee5-491e-883b-2e5fcb3edeab/

    Regards,
    Bin Long

    Bin Long

    TechNet Community Support