Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS report splitting Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 1:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 18, 2014 12:09 PM
Points: 257, Visits: 437
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.
Post #1473219
Posted Monday, July 15, 2013 8:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 6:16 AM
Points: 25, Visits: 180
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
Post #1473664
Posted Monday, July 15, 2013 10:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 18, 2014 12:09 PM
Points: 257, Visits: 437
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.
Post #1473755
Posted Monday, July 15, 2013 12:01 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 18, 2014 12:09 PM
Points: 257, Visits: 437
I got it resolved. Thanks for the help.
Post #1473825
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse