Fileshare Data Driven subscription - Setting up report manager fil

I am trying set up a data driven subscription that will render reports as
PDFs to specific folders in Report Manager. I have setup a fileshare to which
I am pushing reports, but I am having trouble relating specific Report
Manager folders to the fileshares and there is little documentation about
this. Is there a simple way to push PDFs to Report Manager folders via
fileshare subscriptions?
Also, on a data driven subscription, I am setting up the table that will
read the specifications for the data driven subscription. How do a refer to
the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
something else? Also, what is the bit I should use to increment the file if
it already exists? The documentation on data driven subsciptions is really
not adequate to answer these questions.Incidentally, this question relates to Reporting Services 2005
"Mark" wrote:
> I am trying set up a data driven subscription that will render reports as
> PDFs to specific folders in Report Manager. I have setup a fileshare to which
> I am pushing reports, but I am having trouble relating specific Report
> Manager folders to the fileshares and there is little documentation about
> this. Is there a simple way to push PDFs to Report Manager folders via
> fileshare subscriptions?
> Also, on a data driven subscription, I am setting up the table that will
> read the specifications for the data driven subscription. How do a refer to
> the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
> something else? Also, what is the bit I should use to increment the file if
> it already exists? The documentation on data driven subsciptions is really
> not adequate to answer these questions.
>|||Hi Mark,
Not sure I understand third question, but you must provide a different
FileName paramter to the DDS for each report. Whatever logic you want.
Answer to second question is: PDF
As to the first question - I don't think that is possible. DDS can
output to fileshares, but the folders and files in those folders in RM
are controlledby the RS catalog and not accessible outside RM.
As a quick test, I uploaded a PDF file using RM and then searched the
RS Server for the pdf and it was not found. (So RS must be storing it
away somewhere on the server in a secured spot).
Are you sure you really want to do that anyway? The folders may get a
little crowded if you start storing PDF's there. You can, as another
option, store data with the report by using Snapshots.
If you do find a solution for stroing PDF's though, please post it!!
As a workaround, maybe|||Matt - Regarding your last comment, can I arrange the snapshots for the
reports into different folders? My understanding is that you can create a new
snapshot under the history tab for each report, but you cannot move the
history "snapshots" to other folders. Or can you?
"Matt" wrote:
> Hi Mark,
> Not sure I understand third question, but you must provide a different
> FileName paramter to the DDS for each report. Whatever logic you want.
>
> Answer to second question is: PDF
> As to the first question - I don't think that is possible. DDS can
> output to fileshares, but the folders and files in those folders in RM
> are controlledby the RS catalog and not accessible outside RM.
> As a quick test, I uploaded a PDF file using RM and then searched the
> RS Server for the pdf and it was not found. (So RS must be storing it
> away somewhere on the server in a secured spot).
> Are you sure you really want to do that anyway? The folders may get a
> little crowded if you start storing PDF's there. You can, as another
> option, store data with the report by using Snapshots.
> If you do find a solution for stroing PDF's though, please post it!!
> As a workaround, maybe
>

file share subscription problem

I've setup a file share subscription to render a report to an AS/400
file system, but it is failing with Logon failure: unknown user name
or bad password --> System.Runtime.InteropServices.COMException
(0x8007052E):
I'm supplying the correct username and password to access the
directory, and I'm specifying the unc path for the AS/400 correctly
(\\myas400\root\qdls\ftp). The reason I know this is because I am
able to go into Windows Explorer and type in the exact same UNC path,
then supply the username and password when prompted, and I can get in
just fine. I can also copy files back and forth, etc.
Any ideas? This looks like a possible bug to me. My guess is that
nobody's tried rendering a file share subscription to an AS/400
before, so it's probably never been tested.
I guess as a workaround I can render the report to a microsoft file
system and then ftp it over to the AS/400, but I really think this
should work as advertised. That's a lot of extra hoop jumping.This sounds like a security permission issue. Can you try the following: the
RS windows service is running under a certain account. Make sure this
account also has permissions to access the AS/400 network share.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"dcp" <dcp12345678@.yahoo.com> wrote in message
news:1b8617a8.0501041353.60da6aa0@.posting.google.com...
> I've setup a file share subscription to render a report to an AS/400
> file system, but it is failing with Logon failure: unknown user name
> or bad password --> System.Runtime.InteropServices.COMException
> (0x8007052E):
> I'm supplying the correct username and password to access the
> directory, and I'm specifying the unc path for the AS/400 correctly
> (\\myas400\root\qdls\ftp). The reason I know this is because I am
> able to go into Windows Explorer and type in the exact same UNC path,
> then supply the username and password when prompted, and I can get in
> just fine. I can also copy files back and forth, etc.
> Any ideas? This looks like a possible bug to me. My guess is that
> nobody's tried rendering a file share subscription to an AS/400
> before, so it's probably never been tested.
> I guess as a workaround I can render the report to a microsoft file
> system and then ftp it over to the AS/400, but I really think this
> should work as advertised. That's a lot of extra hoop jumping.

file share

hi
i do not get any errors, but i do not see my reports in the shared folder.
here is my configuraiton table
title ext folder render username pwd write
param1 param2
19051, pdf, \\sqlrpt2\krbi ,NULL ,kr_net\pfuller, rewt, NULL, 19051 ,
12/31/2005
18629 ,pdf ,\\sqlrpt2\krbi ,NULL, kr_net\pfuller ,rewt , NULL , 18629 ,
12/31/2005
writemode is static at overwrite
render is static at acrobati have some more informatino.
here is the log message...
"eportingServicesService!crypto!178c!02/01/2006-16:09:04:: e ERROR:
DBUnProtectData failed: System.FormatException: Invalid character in a
Base-64 string.
at System.Convert.FromBase64String(String s)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!178c!02/01/2006-16:09:04:: i INFO: Current
user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!notification!178c!02/01/2006-16:09:04:: e ERROR:
Error occured processing notification. Invalid character in a Base-64
string.
ReportingServicesService!library!178c!02/01/2006-16:09:04:: Data Driven
Notification for activation id ddbec942-54ac-4709-b7f9-3bc73952f662 was
saved.
ReportingServicesService!library!178c!02/01/2006-16:09:04:: Status: Invalid
character in a Base-64 string.
"
"Pete Fuller" <pfuller@.kirbyrisk.com> wrote in message
news:ekaFpY0JGHA.3144@.TK2MSFTNGP11.phx.gbl...
> hi
> i do not get any errors, but i do not see my reports in the shared folder.
> here is my configuraiton table
> title ext folder render username pwd write
> param1 param2
> 19051, pdf, \\sqlrpt2\krbi ,NULL ,kr_net\pfuller, rewt, NULL, 19051 ,
> 12/31/2005
> 18629 ,pdf ,\\sqlrpt2\krbi ,NULL, kr_net\pfuller ,rewt , NULL , 18629 ,
> 12/31/2005
> writemode is static at overwrite
> render is static at acrobat
>