Post reply

Using Exec & Code area method in Data Tab

  • December 27, 2007 at 2:17 am

    #181468

    Hi, i'm new to reporting services, rather new to heavy processing in reporting services. i have scenario

    for which i need your help. so here it goes,

    i have a method in Code area of the report, i'm passing parameter values to it. the method willl return me a swl query in string format. i need to execute it in data tab area. the codei have used in data tab is as below. please let me know. wat to do to make it right. thx

    EXEC ('Code.Main(Parameters!Param1)' +

    UNION

    + 'Code.Main(Parameters!Param2) ' +

    UNION ALL

    + 'Code.Main(Parameters!Param3)')

    Thx again

    Ps:- i need to get this report done really soon for my bos.. cud u please let me know if u have any idea thx

  • December 28, 2007 at 3:15 am

    #763199

    off the top of my head I'd suspect that you can't create the entire exec string during execution, you must create the entire string before the exec statement and then pass that string for execution.

    so concatenate your params first into a variable and then execute the variable

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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