cindyfiller
asked on
push pdf's out to SSRS Report Server
I have some pdf's that are not part of SSRS, but I would like to display them on the Report Server web site. I was hoping I could automatically ftp them each night, but so far I haven't been able to properly connect to the report server. I also know there is an upload button, but can't find a way to automate that either.
Does anyone know if this can be done?
Does anyone know if this can be done?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You deserve a million points for this.
That would be awesome! ;)
That would be awesome! ;)
ASKER
I'm sorry for the long delay in testing this out - I had a critical project that was due. I have followed your instructions and am getting an error. I think I changed the specifics that need changing, but I'm not understanding this log well enough to fix it.
Starting deployment at Thu 03/27/2014 8:55:20.14
SCRIPTLOCATION = scripts
REPORTSERVER = http://bbre2/ReportServer
TIMEOUT = 60
ENDPOINT = "Mgmt2010"
COMPUTERNAME = BBRE2
RS = "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\RS.E XE"
The specified script failed to compile with the following errors:
E:\Business Intelligence\PDFDeployment Project> "C:\WINDOWS\Microsoft.NET\ Framework\ v2.0.50727 \vbc.exe" /t:exe /main:MainModule /utf8output /R:"System.dll" /R:"System.Xml.dll" /R:"System.Web.Services.dl l" /R:"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\rs.e xe" /out:"C:\Documents and Settings\Administrator.UND ALUMNI\Loc al Settings\Temp\1\z5atsfwx.e xe" /debug- "C:\Documents and Settings\Administrator.UND ALUMNI\Loc al Settings\Temp\1\z5atsfwx.0 .vb" "C:\Documents and Settings\Administrator.UND ALUMNI\Loc al Settings\Temp\1\z5atsfwx.1 .vb"
Microsoft (R) Visual Basic Compiler version 8.0.50727.3053
for Microsoft (R) .NET Framework version 2.0.50727.3649
Copyright (c) Microsoft Corporation. All rights reserved.
C:\Documents and Settings\Administrator.UND ALUMNI\Loc al Settings\Temp\1\z5atsfwx.1 .vb(44) : error BC30451: Name 'reportFile' is not declared.
Dim stream As FileStream = File.OpenRead(reportFile)
~~~~~~~~~~
Finished deployment at Thu 03/27/2014 8:55:22.85
Starting deployment at Thu 03/27/2014 8:55:20.14
SCRIPTLOCATION = scripts
REPORTSERVER = http://bbre2/ReportServer
TIMEOUT = 60
ENDPOINT = "Mgmt2010"
COMPUTERNAME = BBRE2
RS = "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\RS.E
The specified script failed to compile with the following errors:
E:\Business Intelligence\PDFDeployment
Microsoft (R) Visual Basic Compiler version 8.0.50727.3053
for Microsoft (R) .NET Framework version 2.0.50727.3649
Copyright (c) Microsoft Corporation. All rights reserved.
C:\Documents and Settings\Administrator.UND
Dim stream As FileStream = File.OpenRead(reportFile)
~~~~~~~~~~
Finished deployment at Thu 03/27/2014 8:55:22.85
ASKER
BTW, the RSS script I started at the Public Sub Main and did not include this section at the top. That may be part of the problem.
'The following global variables need to be passed in through the rs command:
'Dim name As String = "CatalogItem.pdf"
'Dim parent As String = "/Test"
Dim reportFile As String = "scripts\resources\" & name
'The following global variables need to be passed in through the rs command:
'Dim name As String = "CatalogItem.pdf"
'Dim parent As String = "/Test"
Dim reportFile As String = "scripts\resources\" & name
ASKER
I added the dim reporfile as string and THIS NOW WORKS BEAUTIFULLY!
Thank you again for your wonderful code above. I still wish I could give you the trillion points.
Thank you again for your wonderful code above. I still wish I could give you the trillion points.
ASKER
This was by far one of the best answers I've ever received. It was above and beyond - provided me with the scripts needed to accomplish this!!!
ASKER