Multiple Questions on deploying a bulk insertion script file for inserting
reports into reporting services. The script provided by MSDN PublishReports
is really straight forward with some exceptions or at least for me.
How can I ensure that the Data connection that is added in the script gets
added to each report that gets published in the script?
I am recieving an error that states the data set 'Default' refers to a
shared data source 'Default', which is not published on the report server
when I run my script. However the dataconnection that I specified in the
script gets created by the script and works perfectly.
How can I specify a Published Name that is different than the Report.rdl
Name in the scrtipt at the time of insertion? Basically just as if you were
to do the publishing of a report one at a time through the manager and after
uploading the file you can change the name of the Report. How can I do that
in the script?
Thank you for the assitance!
Bradd
please email me @. the following address if you need further clarification to
help my stupid mind. bradd.schick@.fnf.com Thank youSorry the Data Connection taht I am creating in the script is not called
default it is named something different. Just incase anyone neede to know
that.
So Why am I getting an error on Default?
Thanks again
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Alright I got my head out of you know where and I have solved the first
question of the data connection's. The person writing the report (rdl) file
screwed up. I still need help on the second question of the report name.
Thanks
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Try this snippet in your script:
' Create an array representing the files in the specified directory.
Dim di As New DirectoryInfo(strPathName)
Dim fi As FileInfo() = di.GetFiles()
' Optional to echo to console
Console.WriteLine("The following files exist in the current
directory:")
' Iterate through the names of the files in the current directory.
Dim fiTemp As FileInfo
For Each fiTemp In fi
strReportName = Path.GetFileNameWithoutExtension(fiTemp.Name)
PublishReport(strReportName)
Next fiTemp
Just a bit of those new VB .NET methods.
--
Brian J. Matuschak
brian@.electronic-atlas.com
"Bradd Schick" wrote:
> Alright I got my head out of you know where and I have solved the first
> question of the data connection's. The person writing the report (rdl) file
> screwed up. I still need help on the second question of the report name.
> Thanks
> "Bradd Schick" wrote:
> > Multiple Questions on deploying a bulk insertion script file for inserting
> > reports into reporting services. The script provided by MSDN PublishReports
> > is really straight forward with some exceptions or at least for me.
> >
> > How can I ensure that the Data connection that is added in the script gets
> > added to each report that gets published in the script?
> > I am recieving an error that states the data set 'Default' refers to a
> > shared data source 'Default', which is not published on the report server
> > when I run my script. However the dataconnection that I specified in the
> > script gets created by the script and works perfectly.
> >
> > How can I specify a Published Name that is different than the Report.rdl
> > Name in the scrtipt at the time of insertion? Basically just as if you were
> > to do the publishing of a report one at a time through the manager and after
> > uploading the file you can change the name of the Report. How can I do that
> > in the script?
> >
> > Thank you for the assitance!
> >
> > Bradd
> > please email me @. the following address if you need further clarification to
> > help my stupid mind. bradd.schick@.fnf.com Thank you
Tuesday, March 20, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment