April 17, 2015 at 5:22 am
Hi All,
I have spent a lot of time doing SSRS development and across projects I have done the deployment directly from BIDS/SSDT or through report manager and also in Sharepoint.
I was aware that there is a much better of doing the same using RS utility tool. While trying hands on it I found that the file needed to be deployed is a .rss file. But I have no clue how this file is created?
BINGing (:-)) around wasn't of much help either.
Every article that I have seen directly assumes that you have a .rss file created from God knows where.:w00t:
Can anyone point a step by step approach how to create it from scratch ? Thanks a lot in advance.
November 3, 2015 at 10:57 am
Not sure if this helps or not but basically an rss file consists of a few basic "chunks":
1. Declarations
2. Parameters Collection
Full Rss File Example:
'Report Config Parameters
Dim format as string = "HTML4.0"
Dim fileName as String = pFilename
Dim reportPath as String = pReportPath
'report parameters
Dim AcctID as String = pAcctID
Public Sub Main()
' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string = Nothing
Dim mimeType as string = Nothing
Dim extension as string = "htm"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim parameters(0) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "AcctID"
parameters(0).Value = AcctID
Dim execHeader AS New ExecutionHeader()
Dim rpt AS New ExecutionInfo
rpt = rs.LoadReport(reportPath, Nothing)
rs.SetExecutionParameters(parameters, "en-us")
rs.ExecutionHeaderValue = execHeader
rs.ExecutionHeaderValue.ExecutionID = rpt.ExecutionID
results = rs.Render(format, deviceInfo, extension, mimeType, encoding, warnings, streamIDs)
' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()
End Sub
And simple way to call it:
D-ECLARE @cmdrun varchar(750)
SET @cmdRun = '
rs.e-x-e -e Exec2005 -s http://SERVERNAME/reportserver/ -i '
+ '"C:\RssFiles\YourRssFile.rss"'
+ ' -v vFilename=C:\Reports\MyReport.htm -v vReportPath=/ReportServerReportFolder/ -v pParam1="1" -t -l0'
EXECUTE xp_cmdshell @cmdRun
* Note * "declare" misspelled on purpose to get around our company's incredibly touchy proxy server
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy