SSRS Reporting Subscription Issue : Unresolved

SSRS Reporting Subscription Issue: Failure sending mail: The server rejected the sender address. The server response was: 530 5.7.0 Must issue a STARTTLS command first.

Problem Description:

Trying to set up SSRS Reporting Subscription using GMAIL account.

SSRS Subscription raises error mentioned above.

Solution available online:

1. Make Gmail to always send email using Secured connection:  http://www.quickonlinetips.com/archives/2008/07/secure-https-gmail/

2. Changing in reporting manager configuration file: http://sqldbastuff.blogspot.in/2010/06/email-configuration-for-ssrs.html

tried both.. No luck yet :(

Raised issue: http://www.sqlservercentral.com/Forums/Topic1308102-162-1.aspx

Any help would be highly appriciated.

Expand Collapse Group Functionality in SSRS Reports

http://www.sqlchick.com/entries/2010/9/19/expand-or-collapse-all-grouped-items-on-ssrs-report.html

Must read!!!

Copy previous cell data in Excel - Excel Macro

Let's say you have a list of entries in column A, similar to the above example, and within the list you have many blank cells.
Here is a quick and easy way to fill those blanks with the value of the cell above.
Using VBA Macro:

[code]
Sub FillBlanks()
Dim rRange1 As Range, rRange2 As Range
Dim iReply As Integer
If Selection.Cells.Count = 1 Then
MsgBox "You must select your list and include the blank cells", vbInformation
Exit Sub

ElseIf Selection.Columns.Count > 1 Then
MsgBox "You must select only one column", vbInformation
Exit Sub
End If

Set rRange1 = Range(Selection.Cells(1, 1), Cells(65536, Selection.Column).End(xlUp))

On Error Resume Next
Set rRange2 = rRange1.SpecialCells(xlCellTypeBlanks)
On Error GoTo 0

If rRange2 Is Nothing Then
MsgBox "No blank cells Found", vbInformation
Exit Sub
End If

rRange2.FormulaR1C1 = "=R[-1]C"

iReply = MsgBox("Cells copied", vbYesNo + vbQuestion)
If iReply = vbYes Then rRange1 = rRange1.Value

End Sub

[/code]