Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2011

Conditionally summing up values in a dataset in SSRS

Recently I had situation wherein I had to conditionally sum up a data set and display the value in a text box.

The value in the dataset looked like

In this case, for example, I had to sum up ”VwCount” for FYMonth  = 6. So I came up with an… Read more

2 comments, 2,916 reads

Posted in What I Learnt @ Work on 22 July 2011

Send SSRS subscription files to (Secured FTP) SFTP

We have set up subscription for customer which used to send mails to the customers periodically. Recently one of the customer requested us to upload the reports in secured FTP instead of sending it thru mail.

We had to look around for options to achieve this as SSRS does not… Read more

0 comments, 1,316 reads

Posted in What I Learnt @ Work on 14 July 2011