saving exported xls reports on server

Hi all
I have a bunch of reports that I would like to save (the exce
exported version) on the server without user intervention.
Is there anyway to do that automatically?
When I use the render method, I always get the save/open/cancel dialo
bo
Cheers
KriHave you tried file share subscriptions?
"kiryan" wrote:
> Hi all,
> I have a bunch of reports that I would like to save (the excel
> exported version) on the server without user intervention.
> Is there anyway to do that automatically?
> When I use the render method, I always get the save/open/cancel dialog
> box
> Cheers,
> Kris
>|||Just to be more accurate, it is not that many reports, just|||I am affraid this does not work. All my reports use client generate
parameters, and it seems File Share will only accept this with
default value. But these default values are no use to me..
I would need something that would do something like this
ReportServer/test/Report3&rs:ClearSession=true&rs:Command=Render&rs:Format=EXCEL&rc:OmitFormulas=true
rs:Saveto=c:/test/file1.xl
Thank|||Do rs -i "C:\RS Script\MyScript.rss" -s http://myserver/reportserver
where the .rss file does something like this:
Public Sub Main()
Dim format as string = "EXCEL"
Dim fileName as String = "C:\LOT.xls"
Dim reportPath as String = "/foldername/reportname"
'rs -i "C:\RS Script\MyScript.rss" -s http://myserver/reportserver
' 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
Dim mimeType as string
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
' result = rs.Render(reportName, "PDF", historyID, devInfo, parameters,
credentials, showHideToggle, encoding, mimeType, reportHistoryParameters,
warnings, streamIDs)
results = rs.Render(reportPath, format, _
Nothing, Nothing, Nothing, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, 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
--
"Everyone knows something you don't know"
"kiryan" wrote:
> I am affraid this does not work. All my reports use client generated
> parameters, and it seems File Share will only accept this with a
> default value. But these default values are no use to me...
> I would need something that would do something like this:
> ReportServer/test/Report3&rs:ClearSession=true&rs:Command=Render&rs:Format=EXCEL&rc:OmitFormulas=true"
> +
> rs:Saveto=c:/test/file1.xls
> Thanks
>