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

I have a report server in domain â'Aâ' that through a data driven subscription
tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
driven subscriptionâ' wizard, you are asked to provide a username and
password. If I supply domain credentials from domain A (A\UserName), the
subscription appears to run but the report output does not appear in the file
share on domain B. If I supply domain credentials for domain B (B\username),
the subscription fails to run.
Iâ'm assuming that the credentials asked for in the wizard are those used to
access the file share, but it seems as if they also have some bearing on the
running of the subscription (report) itself.
Is there a way I can accomplish what I desire?Check and make sure that your domains have a two way trust between them since
this can cause authentication issues.
Also, make sure that the file share is not set to Read Only and that the
NTFS permissions on the folder do not prevent that user from writing to it.
--
SQL Server Developer Support Engineer
"Herman K" wrote:
> I have a report server in domain â'Aâ' that through a data driven subscription
> tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> driven subscriptionâ' wizard, you are asked to provide a username and
> password. If I supply domain credentials from domain A (A\UserName), the
> subscription appears to run but the report output does not appear in the file
> share on domain B. If I supply domain credentials for domain B (B\username),
> the subscription fails to run.
> Iâ'm assuming that the credentials asked for in the wizard are those used to
> access the file share, but it seems as if they also have some bearing on the
> running of the subscription (report) itself.
> Is there a way I can accomplish what I desire?
>|||Thanks Chris.
Ah. We do not (and cannot) have trusted domains due to security issues. I
ended up placing the subscription on a report server in domain B.
"Chris Alton [MS]" wrote:
> Check and make sure that your domains have a two way trust between them since
> this can cause authentication issues.
> Also, make sure that the file share is not set to Read Only and that the
> NTFS permissions on the folder do not prevent that user from writing to it.
> --
> SQL Server Developer Support Engineer
>
> "Herman K" wrote:
> > I have a report server in domain â'Aâ' that through a data driven subscription
> > tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> > driven subscriptionâ' wizard, you are asked to provide a username and
> > password. If I supply domain credentials from domain A (A\UserName), the
> > subscription appears to run but the report output does not appear in the file
> > share on domain B. If I supply domain credentials for domain B (B\username),
> > the subscription fails to run.
> >
> > Iâ'm assuming that the credentials asked for in the wizard are those used to
> > access the file share, but it seems as if they also have some bearing on the
> > running of the subscription (report) itself.
> >
> > Is there a way I can accomplish what I desire?
> >