Wednesday, March 28, 2012
Load balancing and report servers
first web server always uses the first reporting server, and the second web
server the second reporting server. There is no shared state, and a given
user session always goes to the same web server. Report output is displayed
via a ReportViewer web control.
They'd like to move to true load balancing of the web servers, but don't
want to pay the extra for SQL Server Enterprise licenses that reporting
server farm require.
Looking at the HTTP traffic the ReportViewer sends request to the web server
to be handled by
/Reserved.ReportViewerWebControl.axd
...with some parameters, two of which...
?ReportSession=3dobaffxgmkaduj5rukvhxvy
&ControlID=841538b0792b4b27bf84e1da251a8d87
...look as though they would provide a key to some configuration information.
If we changed to shared state, and true load balancing (such that a request
could go to any web server), what would happen when the user chose to move to
the next page in a report or output a report to PDF?
Would the web server be able to find the correct session information and
forward the request to the reporting server that originally generated the
output?
Thanks,
DukeHello Duke,
According to the documents in BOL, we did not recommand customer to use
only one reporting services on the Load Balance Node.
I may consulting the internal member to check whether you could do this or
not. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
load balanced scale out deployment issues
I have a scale out deployment of Reporting Services consisting of 2 Report
Servers in a load balanced cluster using an F5 BigIP setup in RoundRobin
mode, and the report catalog db sits on on a separate sql server. We use a
vIP with a DNS name that hits the F5. The F5, in turn, is setup to "choose"
one of the 2 Report Servers using the machine name address. Note that this
is for an intranet.
We are not currently using HTTPS (SSL) in our environment, but eventually
we'll turn it on, so ignore that piece of the puzzle for this scenario.
When configuring the scale-out deployment, we followed the instructions on
the Books Online article "Configuring a Report Server Scale-out Deployment."
The last piece of this document instructs us to modify the
RSWebApplication.config file for all the servers in the scale out deployment,
setting the <ReportServerUrl> element to use the virtual server name (vIP
DNS, we assumed), instead of the machine name. However, this element did not
contain a value originally.
The next step was to modify the RSReportServer.config file, to set the
<UrlRoot> element with the virtual server name (again, vIP dns). UrlRoot's
original value as the url <servername>/reportserver.
Once this change was made, I reset IIS on both servers, and hit each
localhost's Report manager to fire up the applications. However, I received
the following error "ReportServerUrl Configuration element is not a valid
configuration..." on both Report Manager web apps.
Note that before we made the above change to ReportServerUrl and UrlRoot,
both servers worked fine. So, I went back in and removed the value from
ReportServerUrl, but left the UrlRoot with the vIP name. Reset IIS, and the
error went away!
I am a little confused as to what these two settings are used for, since the
original value of ReportServerUrl was blank (UrlRoot actually had the machine
name address).
Could someone explain the cause of this error, and suggest a best practice
for this scenario. I would like to use the most efficient configuration
between the Report Servers and the F5 load balancer, and what other changes
would we be looking at once we turn on SSL?
Thanks!
--
Regards,
Thiago Silvabtw, this is using SSRS 2005 (Enterprise Edition, of course, since it's a web
farm).
--
Regards,
"HC" wrote:
> Hello,
> I have a scale out deployment of Reporting Services consisting of 2 Report
> Servers in a load balanced cluster using an F5 BigIP setup in RoundRobin
> mode, and the report catalog db sits on on a separate sql server. We use a
> vIP with a DNS name that hits the F5. The F5, in turn, is setup to "choose"
> one of the 2 Report Servers using the machine name address. Note that this
> is for an intranet.
> We are not currently using HTTPS (SSL) in our environment, but eventually
> we'll turn it on, so ignore that piece of the puzzle for this scenario.
> When configuring the scale-out deployment, we followed the instructions on
> the Books Online article "Configuring a Report Server Scale-out Deployment."
> The last piece of this document instructs us to modify the
> RSWebApplication.config file for all the servers in the scale out deployment,
> setting the <ReportServerUrl> element to use the virtual server name (vIP
> DNS, we assumed), instead of the machine name. However, this element did not
> contain a value originally.
> The next step was to modify the RSReportServer.config file, to set the
> <UrlRoot> element with the virtual server name (again, vIP dns). UrlRoot's
> original value as the url <servername>/reportserver.
> Once this change was made, I reset IIS on both servers, and hit each
> localhost's Report manager to fire up the applications. However, I received
> the following error "ReportServerUrl Configuration element is not a valid
> configuration..." on both Report Manager web apps.
> Note that before we made the above change to ReportServerUrl and UrlRoot,
> both servers worked fine. So, I went back in and removed the value from
> ReportServerUrl, but left the UrlRoot with the vIP name. Reset IIS, and the
> error went away!
> I am a little confused as to what these two settings are used for, since the
> original value of ReportServerUrl was blank (UrlRoot actually had the machine
> name address).
> Could someone explain the cause of this error, and suggest a best practice
> for this scenario. I would like to use the most efficient configuration
> between the Report Servers and the F5 load balancer, and what other changes
> would we be looking at once we turn on SSL?
> Thanks!
> --
> Regards,
> Thiago Silva
Monday, March 26, 2012
Load a bitmap image into Reporting services
Reporting services and be able to edit it.
eg. lets say a portion of the document was
Name : _______________
Surname : _______________
ID No. : _______________
Now where the underlined parts are, can one then go and edit it and Add a
field from a dataset.
The reason I ask is that I have several 20 odd page documents to create in
reporting services.
We want to automate the process whereby the users capture the neccasary data
in our application and the report is generated from this.
Now it may take forever doing this manually because will have to worry about
whether each page fits properly,
formatting and as the report gets larger the response times in Visual studio
is horrendous.
So I was just wondering if this were possible.
Or if anyone else has any other suggestions. Am using VS2005.
Thanks
SanjeevYou can put the image using image control, but not possible to edit. What you
can do is to put the document images as background and align the textbox
exactly as a entry field just next to the fields which require a value. This
way you can try, but not sure you may face some problem when you export to
different formats.
Amarnath, MCTS
"Sanjeev Rampersad" wrote:
> After scanning a document, can one load the resultant bitmap image into
> Reporting services and be able to edit it.
> eg. lets say a portion of the document was
> Name : _______________
> Surname : _______________
> ID No. : _______________
> Now where the underlined parts are, can one then go and edit it and Add a
> field from a dataset.
> The reason I ask is that I have several 20 odd page documents to create in
> reporting services.
> We want to automate the process whereby the users capture the neccasary data
> in our application and the report is generated from this.
> Now it may take forever doing this manually because will have to worry about
> whether each page fits properly,
> formatting and as the report gets larger the response times in Visual studio
> is horrendous.
> So I was just wondering if this were possible.
> Or if anyone else has any other suggestions. Am using VS2005.
> Thanks
> Sanjeev
>
>|||Thanks. Its worth a shot.Will try it as a background.
I just have to worry about exporting only to pdf..
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:853A1C5B-39F5-4EBF-BBD0-BA59F92D46D0@.microsoft.com...
> You can put the image using image control, but not possible to edit. What
> you
> can do is to put the document images as background and align the textbox
> exactly as a entry field just next to the fields which require a value.
> This
> way you can try, but not sure you may face some problem when you export to
> different formats.
> Amarnath, MCTS
>
> "Sanjeev Rampersad" wrote:
>> After scanning a document, can one load the resultant bitmap image into
>> Reporting services and be able to edit it.
>> eg. lets say a portion of the document was
>> Name : _______________
>> Surname : _______________
>> ID No. : _______________
>> Now where the underlined parts are, can one then go and edit it and Add a
>> field from a dataset.
>> The reason I ask is that I have several 20 odd page documents to create
>> in
>> reporting services.
>> We want to automate the process whereby the users capture the neccasary
>> data
>> in our application and the report is generated from this.
>> Now it may take forever doing this manually because will have to worry
>> about
>> whether each page fits properly,
>> formatting and as the report gets larger the response times in Visual
>> studio
>> is horrendous.
>> So I was just wondering if this were possible.
>> Or if anyone else has any other suggestions. Am using VS2005.
>> Thanks
>> Sanjeev
>>|||on a PDF it works perfectly ok, if you include as a background image.
Amarnath, MCTS
"Sanjeev Rampersad" wrote:
> Thanks. Its worth a shot.Will try it as a background.
> I just have to worry about exporting only to pdf..
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:853A1C5B-39F5-4EBF-BBD0-BA59F92D46D0@.microsoft.com...
> > You can put the image using image control, but not possible to edit. What
> > you
> > can do is to put the document images as background and align the textbox
> > exactly as a entry field just next to the fields which require a value.
> > This
> > way you can try, but not sure you may face some problem when you export to
> > different formats.
> >
> > Amarnath, MCTS
> >
> >
> > "Sanjeev Rampersad" wrote:
> >
> >>
> >> After scanning a document, can one load the resultant bitmap image into
> >> Reporting services and be able to edit it.
> >>
> >> eg. lets say a portion of the document was
> >>
> >> Name : _______________
> >> Surname : _______________
> >> ID No. : _______________
> >>
> >> Now where the underlined parts are, can one then go and edit it and Add a
> >> field from a dataset.
> >> The reason I ask is that I have several 20 odd page documents to create
> >> in
> >> reporting services.
> >> We want to automate the process whereby the users capture the neccasary
> >> data
> >> in our application and the report is generated from this.
> >> Now it may take forever doing this manually because will have to worry
> >> about
> >> whether each page fits properly,
> >> formatting and as the report gets larger the response times in Visual
> >> studio
> >> is horrendous.
> >> So I was just wondering if this were possible.
> >> Or if anyone else has any other suggestions. Am using VS2005.
> >>
> >> Thanks
> >> Sanjeev
> >>
> >>
> >>
>
>
Friday, March 23, 2012
listingreports that user has access
the user is in windows server 2003 active directory.
reporting services 2000 is being used.
within the intranet there is a portal.
in the portal I want to list the available reports to the user
that he can access. I do not want to display all the reports to him and let
him choose. I want him to be able to see only the reports he is allowed to
see?
how can I do this using asp.net 1.1
thanx
rifatis it possible or not?
can someone answer please ?
thanx
rifatsql
Wednesday, March 21, 2012
Listing AD group members
I'd like to create a report in Reporting Services 2000 listing the
members of a given Active Directory group.
I found on the internet a vbs-script to retrieve the information
needed:
Set objGroup = GetObject("LDAP://CN=MyGroup,OU=MyOU,DC=MyDC")
For Each objUser in objGroup.Members
Wscript.Echo "Name: " & objUser.DisplayName
Next
This script works fine.
However, I'm not very familiar with VBS-programming (and not with
custom code in Reporting Services either...)
How do I create a report that presents the result from the query?
Any help would be greatly appreciated.
WillyI've been working on a solution, but I'm stuck
In the Report Properties window on the Code tab I've entered the
following code:
Shared Function GetMembersByGroupSQL As String
Dim objGroup As Object
Dim objUser As Object
Dim strQuery As String
objGroup = GetObject("LDAP://CN=MyGroup,OU=MyOU,DC=MyDC")
For Each objUser In objGroup.Members
strQuery = "SELECT Naam = '" & objUser.DisplayName & "'"
Next
Return strQuery
End Function
(I realize I have to alter the For Each construction, in the end I
need strQuery to be something like
SELECT Naam='John' UNION SELECT Naam='Mary' UNION...
For now, only the last row will be returned.)
I've created a new dataset with command type set to 'Text' and entered
the following
= Code.GetMembersByGroupSQL
I've also added a field called 'Naam'.
When I run a report based on this dataset displaying name I get the
following error:
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot set the command text for data set 'dsGebruikersPerGroep'.
(rsErrorSettingCommandText) Get Online Help
Error during processing of the CommandText expression of dataset
'dsGebruikersPerGroep'. (rsQueryCommandTextProcessingError) Get Online
Help
There's something wrong with my VB code, because when I replace the
existing code with the following, all works fine:
Shared Function GetMembersByGroupSQL As String
Dim strQuery As String
strQuery = "SELECT Naam = 'John'"
Return strQuery
End Function
It seems like the following line of code is the problem: objGroup =GetObject("LDAP://CN=MyGroup,OU=MyOU,DC=MyDC")
I've tested the code in a vbs-script and it worked fine. Do I need to
add references to assembly's and/or classes to make it work?
Kind regards, Willy
Monday, March 19, 2012
Listbox
I have a Stored Procedure and I'm passing 3 parameters. One of the
parameters is a listbox with several options. I want to automatically
populate those options from a database query. Problem is I am not sure
how to do this.
The report data is currently coming from a Stored Procedure that
returns a single dataset. Do I need to add another dataset or a
subreport? Need helpYou can handle this by creating a new dataset, which can either use a
stored proc that brings back the options you want in your listbox, or
manually typing in the query (dataset type of "Text").
Next, go to Report --> Parameters
Choose the parameter that you want a listbox for.
Under "Available Values," choose "From Query"
In the dataset field, select the new dataset you just created
In the "value field," choose the field from your dataset that holds the
"value" you want passed to the query that drives your report
In the "label field," choose the field from your dataset that you want
to display in the listbox.
John
melishbd wrote:
> I'm new to MS Reporting Services and I need help ....
> I have a Stored Procedure and I'm passing 3 parameters. One of the
> parameters is a listbox with several options. I want to automatically
> populate those options from a database query. Problem is I am not sure
> how to do this.
>
> The report data is currently coming from a Stored Procedure that
> returns a single dataset. Do I need to add another dataset or a
> subreport? Need help|||Sorry I had misunderstood...these guys seem to have you pointed in the
right direction now, anyway.
John
melishbd wrote:
> I'm new to MS Reporting Services and I need help ....
> I have a Stored Procedure and I'm passing 3 parameters. One of the
> parameters is a listbox with several options. I want to automatically
> populate those options from a database query. Problem is I am not sure
> how to do this.
>
> The report data is currently coming from a Stored Procedure that
> returns a single dataset. Do I need to add another dataset or a
> subreport? Need help
list with grouping loses space between records
I'm new to reporting services and have had a play with it but wonder if
I can get a quick answer here.
I have a dataset and want to show some details of the parent record
with some details of the child.
I have used a table and that is all ok except for the fact that on the
child record I have table headings (which I have put into the parent
grouping row). Now this row expands because of the data in the parent
record which means that the child record doesn't start until after the
parent record. I want the child record to show as a table with its
headers in line with the parent record i.e. the table headers will be
independent of the parent record - not growing.
So I decided to try and use a list. This works as I want except now, I
am not sure how to get a gap between the records. When there are no
child records I get a nice gap but if there are, say 3 child records,
then the gap between the last child record and the next parent record
is virtually non-existent. I have tried putting empty rectangles in and
even an empty textbox with a "CanShrink=False" to try and force a
certain gap between parent records but there's probably something
really basic I'm missing.
Thanks for any help
Philactually the list doesn't work as i want because each of the cells
grows independently of each other so the borders don't align - is there
a way round this?
List SSRS2005 items on treeview
Hi all,
I'm creating a Custom web interface for SQL Server reporting services 2005.
What I want to do is populate a "Navigation Treeview" component in asp.net 2. How would I get all the catalog items and items from the web API and populate my treeview?
Thanks
Hi Rudi,
You could use the SOAP API - ListChildren. Here is a link to defintion and code sample:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_2yt2.asp
|||Hi there Brad,
Thanks alot! I'm still having some trouble though...
I'm using this code to get the list:
Try
Dim P As New ReportingService
Dim RootList As CatalogItem = P.ListChildren("/", True)
LoadTree(RootList)
Catch ex As Exception
End Try
But this is returning the error:
\\Reportserver\NetReports\Admin\Default.aspx(1): Build (web): \\Reportserver\NetReports\MasterPage.master.vb(36): error BC30311: Value of type '1-dimensional array of ReportService.CatalogItem' cannot be converted to 'ReportService.CatalogItem'.
What am I doing wrong?
Thanks
|||Don't worry, I got it....
I didn't add the () in
Dim RootList As CatalogItem() = rs.ListChildren("/", True)
Thanks
|||Any chance you could provide the code used for LoadTree? I'm stuck trying to figure out how to programmatically build the nodes from the CatalogItem.
Thanks,
Kel
List SSRS2005 items on treeview
Hi all,
I'm creating a Custom web interface for SQL Server reporting services 2005.
What I want to do is populate a "Navigation Treeview" component in asp.net 2. How would I get all the catalog items and items from the web API and populate my treeview?
Thanks
Hi Rudi,
You could use the SOAP API - ListChildren. Here is a link to defintion and code sample:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_2yt2.asp
|||
Hi there Brad,
Thanks alot! I'm still having some trouble though...
I'm using this code to get the list:
Try
Dim P As New ReportingService
Dim RootList As CatalogItem = P.ListChildren("/", True)
LoadTree(RootList)
Catch ex As Exception
End Try
But this is returning the error:
\\Reportserver\NetReports\Admin\Default.aspx(1): Build (web): \\Reportserver\NetReports\MasterPage.master.vb(36): error BC30311: Value of type '1-dimensional array of ReportService.CatalogItem' cannot be converted to 'ReportService.CatalogItem'.
What am I doing wrong?
Thanks
|||Don't worry, I got it....
I didn't add the () in
Dim RootList As CatalogItem() = rs.ListChildren("/", True)
Thanks
|||Any chance you could provide the code used for LoadTree? I'm stuck trying to figure out how to programmatically build the nodes from the CatalogItem.
Thanks,
Kel
Friday, March 9, 2012
List Of Reports
I have created an application that uses reports published via SQL reporting services. I have a form with a report viewer control on it and above that I have a drop down list box. I want to fill the list box with available reports from the server and allow the user to select the report they wish to see. The report list could change so I don't want to hard code any report names in the list The problem I am having is that I can't figure out how to get a list of available reports from the server.
Thanks for any help offered.
Check out this article:
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listchildren.aspx
BobP
|||You may have to alter this for your system but you can try the query below.
selectdistinctnamefrom dbo.Catalog
where policyroot = 0
andpathnotlike'/Data Source%'
andpathnotlike'/Model%'
orderbyname
|||
Thanks to both of you, now I have options because I used both and they work (with slight modifications).
I modified the query as follows and it gives me just the reports
selectdistinctnamefrom dbo.Catalog
where policyroot = 0
andtype= 2
orderbyname
I just didn't realize it was in the Catalog table, I swore I looked but I guess not.
Thanks again
List of Procedures used in RDL on Production site
Reporting Services site? I am looking for what stored procedures are being
used on our production reporting site.
Any help would be appreciated.All the deployed reports are stored in a table called "catalog" you can get a
list by querying the table.
Amarnath
"LostinSpace" wrote:
> Is there a way to search all of the RDL's that have been deployed out to a
> Reporting Services site? I am looking for what stored procedures are being
> used on our production reporting site.
> Any help would be appreciated.|||I appreciate the response, but this is not what I am looking for.
I need to search the content inside every single rdl to see what stored
procedures are being used. If there isn't a way to do this in RS, is there a
way to do this from vss?
"Amarnath" wrote:
> All the deployed reports are stored in a table called "catalog" you can get a
> list by querying the table.
> Amarnath
> "LostinSpace" wrote:
> > Is there a way to search all of the RDL's that have been deployed out to a
> > Reporting Services site? I am looking for what stored procedures are being
> > used on our production reporting site.
> > Any help would be appreciated.|||OK You said "deployed" so I gave that answer...
You can search for "<CommandType>StoredProcedure</CommandType>" and the next
line will be the stored procedure name. and select look in "Current project"
from the find dialog box.
Hey this looks very basic, is this what you want ?
Amarnath
"LostinSpace" wrote:
> I appreciate the response, but this is not what I am looking for.
> I need to search the content inside every single rdl to see what stored
> procedures are being used. If there isn't a way to do this in RS, is there a
> way to do this from vss?
> "Amarnath" wrote:
> > All the deployed reports are stored in a table called "catalog" you can get a
> > list by querying the table.
> >
> > Amarnath
> >
> > "LostinSpace" wrote:
> >
> > > Is there a way to search all of the RDL's that have been deployed out to a
> > > Reporting Services site? I am looking for what stored procedures are being
> > > used on our production reporting site.
> > > Any help would be appreciated.|||Deployed is correct. I need to search every single rdl deployed to our RS site.
I need to find what stored procedures are used in each rdl. I do not seem to
be able to
do this from the ReportServer database. I know how to do this from the rdl
when in working with the rdl on its own in Visual Studio, but I have over 500
reports in RS. I need a quick and painless way to search all of the rdlâ's at
the same time to see their stored procedures.
I do appreciate the response, I just have a feeling this can not be done...
"Amarnath" wrote:
> OK You said "deployed" so I gave that answer...
> You can search for "<CommandType>StoredProcedure</CommandType>" and the next
> line will be the stored procedure name. and select look in "Current project"
> from the find dialog box.
> Hey this looks very basic, is this what you want ?
> Amarnath
>
> "LostinSpace" wrote:
> > I appreciate the response, but this is not what I am looking for.
> > I need to search the content inside every single rdl to see what stored
> > procedures are being used. If there isn't a way to do this in RS, is there a
> > way to do this from vss?
> >
> > "Amarnath" wrote:
> >
> > > All the deployed reports are stored in a table called "catalog" you can get a
> > > list by querying the table.
> > >
> > > Amarnath
> > >
> > > "LostinSpace" wrote:
> > >
> > > > Is there a way to search all of the RDL's that have been deployed out to a
> > > > Reporting Services site? I am looking for what stored procedures are being
> > > > used on our production reporting site.
> > > > Any help would be appreciated.
Wednesday, March 7, 2012
List of all folder permissions
are in the process of cleaning up two Reporting Services boxes that
have gotten way out of control, including permissions. Part of this
process is assigning users to roles, rather than individual permissions
on folders. But to do this, I need to see who is assigned to what
folder (and there are many). Any ideas?I think RS Scripter will help you in this.
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_introduction
Someone wrote an OLAP documenter as a Word macro. When opening the word doc
you could point it at a server and it would document all the cubes. Same
thing would be nice for RS.
Steve MunLeeuw
"madrigal" <nmadrigal@.att.net> wrote in message
news:1160661235.716193.208570@.i3g2000cwc.googlegroups.com...
> Is there a way to get a list of all folder permissions per folder? We
> are in the process of cleaning up two Reporting Services boxes that
> have gotten way out of control, including permissions. Part of this
> process is assigning users to roles, rather than individual permissions
> on folders. But to do this, I need to see who is assigned to what
> folder (and there are many). Any ideas?
>
Friday, February 24, 2012
List in list?
Hello everybody,
I am new to the whole reporting World and I was wondering if their is a solution for my problem. I searched for one and a half hour and I am getting desperate.
I need to repeat a report. So I thought: I can use a list for that. But when I placed all my objects in that list and linked it to a data source it gives an error at every object. I had this problem before and I made a work around so I did not solve it. I need a list in a list or a matrix in a list. I get the following errors:
Error 1 [rsDataRegionInDetailList] The list ‘list3’ is in a list that has no group expressions defined for it. To use a data region in a list, the list must have group expressions. c:\projecten\citrix\test\citrixusagedb\report\CitrixUsage.rdl 0 0
Error 2 [rsFieldReference] The Value expression for the textbox ‘textbox16’ refers to the field ‘USERNAME’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. c:\projecten\citrix\test\citrixusagedb\report\CitrixUsage.rdl 0 0
I hope you can help me, thanks in advance!
Yours,
Stef
I found the soluition!I had to use a subreport
Monday, February 20, 2012
List all subscriptions and recipients
I'm hoping this is an easy question.
Currently we have a large number of reports running on SQL Reporting
Services. The majority of them have subscriptions setup but we don't have
any details. Additionally, some of them are using a distribution list e-mail
and some have each recipient manually entered.
I want to take this opportunity to move as many of them as possible over to
distribution lists.
I would like to get a list of all reports with the following information:
*name of the schedule subscription is using
*how it is sent (e-mail or file)
*if file, i need: file name, path, render format, credentials, overwrite
options, parameters
*if e-mail, i need: recipients, subject, file and/or link, render format,
parameters
*date of last successful send
What is the easiest way of getting this information?
Thanks in advance for any help!
NancyYou should explore "Reportserver database" because it stores everything there
e.g.
catalog has all the report listing and their details, users all user
details, subscription etc...
Amarnath
"Nancy R" wrote:
> Hi all,
> I'm hoping this is an easy question.
> Currently we have a large number of reports running on SQL Reporting
> Services. The majority of them have subscriptions setup but we don't have
> any details. Additionally, some of them are using a distribution list e-mail
> and some have each recipient manually entered.
> I want to take this opportunity to move as many of them as possible over to
> distribution lists.
> I would like to get a list of all reports with the following information:
> *name of the schedule subscription is using
> *how it is sent (e-mail or file)
> *if file, i need: file name, path, render format, credentials, overwrite
> options, parameters
> *if e-mail, i need: recipients, subject, file and/or link, render format,
> parameters
> *date of last successful send
> What is the easiest way of getting this information?
> Thanks in advance for any help!
> Nancy|||Hi Amarnath,
I'm sorry I'm just responding now, we've had some pressing things come up
over the last few months and this got pushed to the back burner.
Where is the reportserver database? How do I access it?
I generally only deal with the "front end" administration, I haven't done
any of it on the back end.
Thanks,
Nancy
"Amarnath" wrote:
> You should explore "Reportserver database" because it stores everything there
> e.g.
> catalog has all the report listing and their details, users all user
> details, subscription etc...
> Amarnath
> "Nancy R" wrote:
> > Hi all,
> >
> > I'm hoping this is an easy question.
> >
> > Currently we have a large number of reports running on SQL Reporting
> > Services. The majority of them have subscriptions setup but we don't have
> > any details. Additionally, some of them are using a distribution list e-mail
> > and some have each recipient manually entered.
> >
> > I want to take this opportunity to move as many of them as possible over to
> > distribution lists.
> >
> > I would like to get a list of all reports with the following information:
> >
> > *name of the schedule subscription is using
> > *how it is sent (e-mail or file)
> > *if file, i need: file name, path, render format, credentials, overwrite
> > options, parameters
> > *if e-mail, i need: recipients, subject, file and/or link, render format,
> > parameters
> > *date of last successful send
> >
> > What is the easiest way of getting this information?
> >
> > Thanks in advance for any help!
> >
> > Nancy