SSRS report splitting

  • 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.

  • 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

  • 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.

  • 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