Subscribe to this blog
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
0 comments, 627 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, 708 reads
Posted in What I Learnt @ Work on 14 July 2011