SSRS – User Domain\login does not have required permissions.

Verify that sufficient permission have been granted and Windows user account control (UAC) restriction has been addressed.

Resolution:
Start IE Administrator
Browse to SSRS reportserver (http://server/reports)
Click on the “Folder Settings” button.
Click on the “New Role Assignment” button.
Provide access to user

Cheers!
Sanjay

 


 

Auto grow text box info path web browser form

  1. Set the text box height to auto
  2. Set the table row hosting the text box height to auto
  3. Change the format of the form to InfoPath filler form
  4. Mark the display as multi line
  5. Un check page break option
  6. Set option to show and expand all text.
  7. Revert back the setting to web browser form

The text box should auto grow.

Cheers!
Sanjay

 

 

 

Correlation ID – Extract details using powershell

If 550ff19c-b7e8-7068-88c9-51917c1757cd is the correlation ID

get-splogevent | ?{$_.Correlation -eq "550ff19c-b7e8-7068-88c9-51917c1757cd"} | select Area, Category, Level, EventID, Message | Format-Lis

Takes for ever to finish and provide details of error message

Merge-SPLogFile -Path .\error.log -Correlation '550ff19c-b7e8-7068-88c9-51917c1757cd'

Takes relatively shorter time

Cheers!
Sanjay

Open sub report in new window from SSRS – SharePoint integrated mode

For the textbox field in SSRS Tablix set an action to go to URL with following Expression:

javascript:void(window.open(‘” & Globals!ReportServerUrl &“/Pages/ReportViewer.aspx?” & Globals!ReportFolder & “/PO_Lines.rdl&rc:Parameters=False&PONumber=”& Fields!PO_NUMBER.Value & “‘))

Where:

  1. PO_Lines.rdl is the sub report name
  2. PONumber is the Sub report parameter
  3. PO_NUMBER.Value is the main report field containing value for the sub report parameter.

Cheers!
Sanjay

 

 

 

 

 

 

SSIS Delete folder

Public Sub Main()
        Dim ParentFolder As String
        Dim RetentionPeriod As Integer
        RetentionPeriod = Convert.ToInt32(Dts.Variables("User::RetentionPeriodInDays").Value)
        ParentFolder = Dts.Variables("User::sTargetFolder").Value.ToString()
        Dim folders = New DirectoryInfo(ParentFolder).GetDirectories()
        Dim sArchiveFolder As String
        Dim dir As System.IO.DirectoryInfo
        For Each Folder In folders
            If Folder.CreationTime < DateTime.Today.AddDays(-RetentionPeriod) Then
                sArchiveFolder = ParentFolder & Folder.Name
                MessageBox.Show(sArchiveFolder)
                ClearFolder(sArchiveFolder)
                dir = New System.IO.DirectoryInfo(Folder.FullName)
                dir.Delete(True)
            End If
        Next
        Dts.TaskResult = ScriptResults.Success
    End Sub
    Private Sub ClearFolder(ByVal FolderName As String)
        Dim dir As New DirectoryInfo(FolderName)
        For Each fi As FileInfo In dir.GetFiles()
            fi.IsReadOnly = False
        Next

        For Each di As DirectoryInfo In dir.GetDirectories()
            ClearFolder(di.FullName)
        Next
    End Sub
End Class