Post reply

SSRS report splitting

  • July 12, 2013 at 1:11 pm

    #280233

    Hi,

    I am trying to acheive the following code in SSRS report:

    /*

    create Proc Rpt_FV_Consent_Daily_ByDay_final as

    Declare @a datetime= CONVERT(VARCHAR(10),getdate()-17, 101)

    --select @a

    While(@a< CONVERT(VARCHAR(10),getdate(), 101))

    Begin

    exec Rpt_FV_Consent_Daily_ByDay @a

    Set @a=@a+1

    Continue

    End

    */

    While I run the report, it is giving only first picked @a from the stored procedure. And not going into the loop. Can any body throw light what i am missing?

    Thanks.

  • July 15, 2013 at 8:04 am

    #1632476

    Are you adding it to a table if you only ad the field on to the the body you will only get the first value returned

  • July 15, 2013 at 10:10 am

    #1632553

    All the records should be taken to a table ? Is there a way to read each loop from ssrs report?

    my sql provided is working fine in SSMS, where it is giving all the results i wanted. The results are thrown in different windows though. Need to do this in SSRS.

    Thanks.

  • July 15, 2013 at 12:01 pm

    #1632616

    I got it resolved. Thanks for the help.

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

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