Post reply

CLR stored procedure not visible in crystal reports

  • March 6, 2009 at 2:19 am

    #200571

    I have created a CLR stored procedure .I'm able to execute the sp from sql server express but the CLR SP is not visible in crystal reports version 10

    Sql server SP I'm able to access it in crystal reports but CLR SP its not visible .Are there any permissions to be enabled or is that a limitation for sql server express ?

  • March 6, 2009 at 5:01 am

    #954763

    Try wrapping it in a SQL Stored Procedure.

    I am not sure if that is necessary, but I am pretty sure that it will work.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • March 7, 2009 at 3:19 pm

    #955579

    That's the first time I've heard of someone writing a CLR stored procedure and I'm curious... what does it do?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply