report when was last used the stored procedure/view- in a DB

hello,
is there a possibilitie to get the date when a stored procedure / view was
used
The problem is that in a database there are a lot of views - which where
created in a period of last 2 years from diffren user which had access to th
e
database. Now i want to have a kind of report for all views / stored
procedures from a database - to see if this where used in the last 3 month.
If no we can than make a backap and delete this.
best regardsYou could do the stored procedures by either using Profiler and auditing
whats executed against the SQL Server and then pull out the procs used, or
you could write into each stored procedure a write to an audit table
something like...
insert sp_run_log ( procname ) values ( 'myprocname' )
Then you can check through the log after a period of time - you would need
to run every piece of logic in yoru application though.
I can't think of anyway you could do a view, you could perhaps trap the SQL
again using profiler at the statement level and do string searches for them.
Hope that helps.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Xavier" <Xavier@.discussions.microsoft.com> wrote in message
news:07E773A8-9A95-4CB5-B839-72AA796BF2CE@.microsoft.com...
> hello,
> is there a possibilitie to get the date when a stored procedure / view
> was
> used
> The problem is that in a database there are a lot of views - which where
> created in a period of last 2 years from diffren user which had access to
> the
> database. Now i want to have a kind of report for all views / stored
> procedures from a database - to see if this where used in the last 3
> month.
> If no we can than make a backap and delete this.
> best regards|||hello Tony,
thanks for yur help, the idea to write in a audit table is great.
For the view ..... have you any link / information / step by step .. how
to realize the " trap the SQL using profiler at the statement level ..."
thanks
"Tony Rogerson" wrote:

> You could do the stored procedures by either using Profiler and auditing
> whats executed against the SQL Server and then pull out the procs used, or
> you could write into each stored procedure a write to an audit table
> something like...
> insert sp_run_log ( procname ) values ( 'myprocname' )
> Then you can check through the log after a period of time - you would need
> to run every piece of logic in yoru application though.
> I can't think of anyway you could do a view, you could perhaps trap the SQ
L
> again using profiler at the statement level and do string searches for the
m.
> Hope that helps.
> Tony.
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "Xavier" <Xavier@.discussions.microsoft.com> wrote in message
> news:07E773A8-9A95-4CB5-B839-72AA796BF2CE@.microsoft.com...
>
>

Report Viewer Web Part Title wont save

In shared view when i save a report viewer web part title & then go & select
another report viewer web part title on the same page the title then defaults
back to report viewer [1] & report viewer [2].
the same happens when i clock off the page & back to it.
thanksAny ideas Microsoft '
Thanks
"Tango" wrote:
> In shared view when i save a report viewer web part title & then go & select
> another report viewer web part title on the same page the title then defaults
> back to report viewer [1] & report viewer [2].
> the same happens when i clock off the page & back to it.
> thanks

Report viewer send print job with a large memory

i am using reporting service 2005 and report viewer from vs.net 2005.

when i send a print job from report view to HP Laserjet 1320, there print job is actually abt 20MB for 20 pages.

it happends that the printer will hav problem printing the print job or just hang there..

is there any way to resolve it?

There was an issue with 2005 that the print control did not get updated correctly if you had the 2000 print control. Is it possible that you have the 2000 print control on the client? If so, you can clear the control from the client by going to Tools->Internet Options->Settings->View Objects in IE, then delete the RSPrintControl. The next time you go to use the print control a new one should be downloaded.

Report Viewer dlls on web server

I need to get the report viewer files onto my production web box. I know I can run the report view install to get the files registered in the GAL. Unfortunately running an install on a 'productionalized' box will be a big to do for the administrators in my company. Can this issue be resolved simply by copying out the files to the bin directory of the site in question? Are there any pro/cons to doing it this way (other than I'd have to do this for every site that needs reporting).

thanks,

MP

Keep the dlls local to your project by putting them in the bin folder. This should not have any negative effects. I have a report app accessing the dlls way. Cheers!

report viewer control wont display report !

Hi friends
am trying to display reports from my report server in report view controls. following is my code in a button click

reportviewer1.ServerReport.ReportServerUrl = {http://localhost/reportserver};
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();

its not giving my any error not displays any report!!
but if i set same info in design mode to report viewer control it works nicely!
whats missing here ?
Thanks for your help.finally figured out .following is what needs to be done

reportviewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportviewer1.ServerReport.ReportServerUrl = new System.Uri(@."http://localhost/reportserver");
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();

Report Viewer control ignores parameters

I have a Report Viewer control on an asp.net page. The report shows the
parameters. When I choose a value from the drop down and then click on "View
report", the screen gets refreshed and the parameters are reset. It's like
no parameters have been selected from the drop down and no data is shown. If
I run the same report from report manager, or from VS, everything works. Has
anybody had this issue?
Thanks,
GilgameshOn Aug 28, 4:27 pm, "Gilgamesh" <gilgamesh4e...@.aol.com> wrote:
> I have a Report Viewer control on an asp.net page. The report shows the
> parameters. When I choose a value from the drop down and then click on "View
> report", the screen gets refreshed and the parameters are reset. It's like
> no parameters have been selected from the drop down and no data is shown. If
> I run the same report from report manager, or from VS, everything works. Has
> anybody had this issue?
> Thanks,
> Gilgamesh
You might want to check your parameter mappings to the main
datasource. It sounds like there's a breakdown there somewhere. Also,
make sure that you are not receiving an error in the database
connection string, etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Report Viewer Control + shared hosting

Hi all,

I have a question regarding the report view control and shared hosting. What I need to do is generate a .pdf report dynamically in my ASP.NET web-app using the aforementioned control. What I'm wondering is if this will be do-able on most shared hosts. For example, I know that most (if not all) shared hosts will not allow you to use Crystal Reports because it needs to be installed onto the server rather than on your slice of the server. Is there any installation required to use the report viewer? Conversely, if someone knows of a cheap ($10 - $20/mo) host that allows crystal report use that would be extremely helpful, since I've already done it in crystal reports :(.

Thanks in advance!

Mike

Hello,

You need to have a licensed SQL Server, for using SSRS. You do not require to install any thing on the server.

Please see the links below and select the one with Reporting services,

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Thanks,

Deepesh Verma

|||

Thanks for your reply. However, I am still a bit confused, as I'm not sure which row in the tables I need. Is it report server under business intelligence? If so, it appears I can get that w/ SQL Express, which is what I'm currently using. Any more feedback you can give would be appreciated.

|||

Yes for personal development you can use SQL Express. But if you want for commercial use then you have to go for any other option then Express.

Thanks

report viewer conrtol problem

alslamo alikom...

Hi all...i have a problem with the report viewer control in visual studio 2005 ...i use the control to view a local report file (.rdlc)...and when i change the corresponding xml file (.rdlc) for example using the notepad...and then clicking refresh in the report viewer no thing happens and the new changes done to the report viewer doesn't appear....i have to close the whole application and run it again....so the new changes appear in the viewer....or i tried to remove the control from the form and construct a new one at run time viewing the same .rdlc file and add the new coonstructed viewer to the form and it viewed the new changes done to the .rdlc file...so the question is :

is there any way to refresh the report viewer...making it connect again to the .rdlc file and redraw it with the new changes...?

happy to communicate with u....wish u all a happy life...and thx for ur concern....

Clicking the refresh button will only reload the data for a report, not the report definition itself. To reload the definition, call ReportViewer.Reset(), and set the necessary properties on ReportViewer.LocalReport.|||

alslamo alikom....

thx alot brian...u were very helpfull....

Report Viewer alternative

Hi,
I am using VS 2005 and sql reporting services 2000. I created the
reports, uploaded in the server and now, i need to view the reports
through a web application.
I tried using report viewer in 2005 but figured that report viewer
works with only RS 2005. how do i connect to RS 2000 Server remotely?..
Any insights,snippets is really appreciated.
Thanks,
SankarYou can use web services but the easiest is to embed and IE control and use
URL integration.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sankar07@.gmail.com> wrote in message
news:1162582272.198380.173130@.b28g2000cwb.googlegroups.com...
> Hi,
> I am using VS 2005 and sql reporting services 2000. I created the
> reports, uploaded in the server and now, i need to view the reports
> through a web application.
> I tried using report viewer in 2005 but figured that report viewer
> works with only RS 2005. how do i connect to RS 2000 Server remotely?..
> Any insights,snippets is really appreciated.
> Thanks,
> Sankar
>|||Thanks for the reply. I am sorry, but could you explain a little bit
more on how to
"embed and IE Control"..I didnt quite get it.
Thanks,
Bruce L-C [MVP] wrote:
> You can use web services but the easiest is to embed and IE control and use
> URL integration.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <sankar07@.gmail.com> wrote in message
> news:1162582272.198380.173130@.b28g2000cwb.googlegroups.com...
> > Hi,
> >
> > I am using VS 2005 and sql reporting services 2000. I created the
> > reports, uploaded in the server and now, i need to view the reports
> > through a web application.
> > I tried using report viewer in 2005 but figured that report viewer
> > works with only RS 2005. how do i connect to RS 2000 Server remotely?..
> > Any insights,snippets is really appreciated.
> >
> > Thanks,
> > Sankar
> >|||Sorry, is this a winform application or a webform application? If webform
then URL integration is the easiest to do, you can also do web services
though. If winform then look up on how to embed an IE control (this is very
common thing to do, IE is componetized and the control that actually does
the work in IE is a control that you can put on your form. It has properties
(like URL) that you can set.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sankar" <sankar07@.gmail.com> wrote in message
news:1162589861.063103.302450@.m73g2000cwd.googlegroups.com...
> Thanks for the reply. I am sorry, but could you explain a little bit
> more on how to
> "embed and IE Control"..I didnt quite get it.
> Thanks,
> Bruce L-C [MVP] wrote:
>> You can use web services but the easiest is to embed and IE control and
>> use
>> URL integration.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <sankar07@.gmail.com> wrote in message
>> news:1162582272.198380.173130@.b28g2000cwb.googlegroups.com...
>> > Hi,
>> >
>> > I am using VS 2005 and sql reporting services 2000. I created the
>> > reports, uploaded in the server and now, i need to view the reports
>> > through a web application.
>> > I tried using report viewer in 2005 but figured that report viewer
>> > works with only RS 2005. how do i connect to RS 2000 Server remotely?..
>> > Any insights,snippets is really appreciated.
>> >
>> > Thanks,
>> > Sankar
>> >
>|||it is a webform. by url integration you mean to say , passing it as a
query string right.
I thought about it, but was wondering if there is a control like
"Report viewer" to do it. thanks for your time.
Regards,
Bruce L-C [MVP] wrote:
> Sorry, is this a winform application or a webform application? If webform
> then URL integration is the easiest to do, you can also do web services
> though. If winform then look up on how to embed an IE control (this is very
> common thing to do, IE is componetized and the control that actually does
> the work in IE is a control that you can put on your form. It has properties
> (like URL) that you can set.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sankar" <sankar07@.gmail.com> wrote in message
> news:1162589861.063103.302450@.m73g2000cwd.googlegroups.com...
> > Thanks for the reply. I am sorry, but could you explain a little bit
> > more on how to
> > "embed and IE Control"..I didnt quite get it.
> >
> > Thanks,
> >
> > Bruce L-C [MVP] wrote:
> >> You can use web services but the easiest is to embed and IE control and
> >> use
> >> URL integration.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <sankar07@.gmail.com> wrote in message
> >> news:1162582272.198380.173130@.b28g2000cwb.googlegroups.com...
> >> > Hi,
> >> >
> >> > I am using VS 2005 and sql reporting services 2000. I created the
> >> > reports, uploaded in the server and now, i need to view the reports
> >> > through a web application.
> >> > I tried using report viewer in 2005 but figured that report viewer
> >> > works with only RS 2005. how do i connect to RS 2000 Server remotely?..
> >> > Any insights,snippets is really appreciated.
> >> >
> >> > Thanks,
> >> > Sankar
> >> >
> >|||It is not a query string. It is a URL that calls the asp.net application
(reportserver) with the parameters, rendering format, etc.
There is a report viewer control (I believe it is more of a sample but many
people use it). However, this is a 1.1 framework app. If you are using VS
2005 then your app is a 2.0 framework. So, your choices are to roll your own
using web services or to use URL integration.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sankar" <sankar07@.gmail.com> wrote in message
news:1162592106.368210.252580@.h54g2000cwb.googlegroups.com...
> it is a webform. by url integration you mean to say , passing it as a
> query string right.
> I thought about it, but was wondering if there is a control like
> "Report viewer" to do it. thanks for your time.
> Regards,
> Bruce L-C [MVP] wrote:
>> Sorry, is this a winform application or a webform application? If webform
>> then URL integration is the easiest to do, you can also do web services
>> though. If winform then look up on how to embed an IE control (this is
>> very
>> common thing to do, IE is componetized and the control that actually does
>> the work in IE is a control that you can put on your form. It has
>> properties
>> (like URL) that you can set.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "sankar" <sankar07@.gmail.com> wrote in message
>> news:1162589861.063103.302450@.m73g2000cwd.googlegroups.com...
>> > Thanks for the reply. I am sorry, but could you explain a little bit
>> > more on how to
>> > "embed and IE Control"..I didnt quite get it.
>> >
>> > Thanks,
>> >
>> > Bruce L-C [MVP] wrote:
>> >> You can use web services but the easiest is to embed and IE control
>> >> and
>> >> use
>> >> URL integration.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <sankar07@.gmail.com> wrote in message
>> >> news:1162582272.198380.173130@.b28g2000cwb.googlegroups.com...
>> >> > Hi,
>> >> >
>> >> > I am using VS 2005 and sql reporting services 2000. I created the
>> >> > reports, uploaded in the server and now, i need to view the reports
>> >> > through a web application.
>> >> > I tried using report viewer in 2005 but figured that report viewer
>> >> > works with only RS 2005. how do i connect to RS 2000 Server
>> >> > remotely?..
>> >> > Any insights,snippets is really appreciated.
>> >> >
>> >> > Thanks,
>> >> > Sankar
>> >> >
>> >
>|||Hi,
Sorry. Do you mean to say like the one in this article:
http://msdn2.microsoft.com/en-us/library/aa237743(SQL.80).aspx
Thanks,
Sankar
Bruce L-C [MVP] wrote:
> It is not a query string. It is a URL that calls the asp.net application
> (reportserver) with the parameters, rendering format, etc.
> There is a report viewer control (I believe it is more of a sample but many
> people use it). However, this is a 1.1 framework app. If you are using VS
> 2005 then your app is a 2.0 framework. So, your choices are to roll your own
> using web services or to use URL integration.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "sankar" <sankar07@.gmail.com> wrote in message
> news:1162592106.368210.252580@.h54g2000cwb.googlegroups.com...
> > it is a webform. by url integration you mean to say , passing it as a
> > query string right.
> > I thought about it, but was wondering if there is a control like
> > "Report viewer" to do it. thanks for your time.
> > Regards,
> >
> > Bruce L-C [MVP] wrote:
> >> Sorry, is this a winform application or a webform application? If webform
> >> then URL integration is the easiest to do, you can also do web services
> >> though. If winform then look up on how to embed an IE control (this is
> >> very
> >> common thing to do, IE is componetized and the control that actually does
> >> the work in IE is a control that you can put on your form. It has
> >> properties
> >> (like URL) that you can set.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "sankar" <sankar07@.gmail.com> wrote in message
> >> news:1162589861.063103.302450@.m73g2000cwd.googlegroups.com...
> >> > Thanks for the reply. I am sorry, but could you explain a little bit
> >> > more on how to
> >> > "embed and IE Control"..I didnt quite get it.
> >> >
> >> > Thanks,
> >> >
> >> > Bruce L-C [MVP] wrote:
> >> >> You can use web services but the easiest is to embed and IE control
> >> >> and
> >> >> use
> >> >> URL integration.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> <sankar07@.gmail.com> wrote in message
> >> >> news:1162582272.198380.173130@.b28g2000cwb.googlegroups.com...
> >> >> > Hi,
> >> >> >
> >> >> > I am using VS 2005 and sql reporting services 2000. I created the
> >> >> > reports, uploaded in the server and now, i need to view the reports
> >> >> > through a web application.
> >> >> > I tried using report viewer in 2005 but figured that report viewer
> >> >> > works with only RS 2005. how do i connect to RS 2000 Server
> >> >> > remotely?..
> >> >> > Any insights,snippets is really appreciated.
> >> >> >
> >> >> > Thanks,
> >> >> > Sankar
> >> >> >
> >> >
> >|||Exactly. Books OnLine has lots more documentation on how to compose the URL.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sankar" <sankar07@.gmail.com> wrote in message
news:1162593591.403012.212510@.e3g2000cwe.googlegroups.com...
> Hi,
> Sorry. Do you mean to say like the one in this article:
> http://msdn2.microsoft.com/en-us/library/aa237743(SQL.80).aspx
> Thanks,
> Sankar
> Bruce L-C [MVP] wrote:
>> It is not a query string. It is a URL that calls the asp.net application
>> (reportserver) with the parameters, rendering format, etc.
>> There is a report viewer control (I believe it is more of a sample but
>> many
>> people use it). However, this is a 1.1 framework app. If you are using VS
>> 2005 then your app is a 2.0 framework. So, your choices are to roll your
>> own
>> using web services or to use URL integration.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "sankar" <sankar07@.gmail.com> wrote in message
>> news:1162592106.368210.252580@.h54g2000cwb.googlegroups.com...
>> > it is a webform. by url integration you mean to say , passing it as a
>> > query string right.
>> > I thought about it, but was wondering if there is a control like
>> > "Report viewer" to do it. thanks for your time.
>> > Regards,
>> >
>> > Bruce L-C [MVP] wrote:
>> >> Sorry, is this a winform application or a webform application? If
>> >> webform
>> >> then URL integration is the easiest to do, you can also do web
>> >> services
>> >> though. If winform then look up on how to embed an IE control (this is
>> >> very
>> >> common thing to do, IE is componetized and the control that actually
>> >> does
>> >> the work in IE is a control that you can put on your form. It has
>> >> properties
>> >> (like URL) that you can set.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "sankar" <sankar07@.gmail.com> wrote in message
>> >> news:1162589861.063103.302450@.m73g2000cwd.googlegroups.com...
>> >> > Thanks for the reply. I am sorry, but could you explain a little bit
>> >> > more on how to
>> >> > "embed and IE Control"..I didnt quite get it.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Bruce L-C [MVP] wrote:
>> >> >> You can use web services but the easiest is to embed and IE control
>> >> >> and
>> >> >> use
>> >> >> URL integration.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> <sankar07@.gmail.com> wrote in message
>> >> >> news:1162582272.198380.173130@.b28g2000cwb.googlegroups.com...
>> >> >> > Hi,
>> >> >> >
>> >> >> > I am using VS 2005 and sql reporting services 2000. I created the
>> >> >> > reports, uploaded in the server and now, i need to view the
>> >> >> > reports
>> >> >> > through a web application.
>> >> >> > I tried using report viewer in 2005 but figured that report
>> >> >> > viewer
>> >> >> > works with only RS 2005. how do i connect to RS 2000 Server
>> >> >> > remotely?..
>> >> >> > Any insights,snippets is really appreciated.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Sankar
>> >> >> >
>> >> >
>> >
>

Report Viewer

I am trying to view my reports using the Report Viewer control. Here is my code :

<rsweb:ReportViewerID="ReportViewer1"runat="server"Font-Names="Verdana"Font-Size="8pt"Height="400px"ProcessingMode="Remote"Width="400px">

<ServerReportReportPath="https://ReportServer/Reports/Pages/Report.aspx?ItemPath=%2flovelyjubb%2fReports%2fQBRatings"ReportServerUrl="https://ReportServer/reports/Pages/Folder.aspx"/></rsweb:ReportViewer>

But when I run the code I get the error :

'The request fails with HTTP status 401 : unauthorized'

How do I prevent this error?

Thanks,

Mike

Does your server requires any authentication? If it does you can set the report programmatically from the code behind.

Here is some example i've used some time ago, it should still works :)

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
deimosReportViewer.Visible = false;
// Create a Web service proxy object and set credentials
ReportingService rs = new ReportingService();

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

// Return a list of catalog items in the report server database
CatalogItem[] items = rs.ListChildren("/", true);

// For each report, display the path of the report in a Listbox
foreach (CatalogItem ci in items)
{
if (ci.Type == ItemTypeEnum.Report)
catalogListBox.Items.Add(ci.Path);
}
}
}
protected void loadBtn_Click(object sender, EventArgs e)
{
string catalogItemPath = catalogListBox.SelectedItem.Text;

// Create a Web service proxy object and set credentials
ReportingService rs = new ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

deimosReportViewer.Visible = true;
Uri reportServerUrl = new Uri("http://deimos/reportserver");
deimosReportViewer.ServerReport.ReportServerUrl = reportServerUrl;
deimosReportViewer.ServerReport.ReportPath = catalogItemPath;
}

Cheers,

Yani

|||Your code is similar to the code I used to use for RS 2000, but now I have switched to RS 2005 I have been advised to use the Report Viewer rather than code.sql

Report Viewer

I need to view reports from my application using a report viewer component
(specifically with the AxSHDocVw.AxWebBrowser component). which appears in
the toolbox.
how do i add this component to the toolbox?
Thanks
SanjeevIf you have the Dll... Right click inside the tools box in the dev
environment and choose add/remove items... I dialog box will pop up allowing
you to make the reference to your dll...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:uIl2Yh$EFHA.560@.TK2MSFTNGP15.phx.gbl...
>I need to view reports from my application using a report viewer component
>(specifically with the AxSHDocVw.AxWebBrowser component). which appears in
>the toolbox.
> how do i add this component to the toolbox?
> Thanks
> Sanjeev
>

Report Viewable by everyone on network

I have a report that I want everyone who has credentials on the network to be able to view.

We use Active Directory, (I am not an AD administrator), so I *assume* there is an active directory security group that everyone belongs to. If so, then making this report avaiable to everyone should be as simple as granting the *everyone* security group "browse" rights on the folder containg the report.
Is there another way to set such a low level of security in Reporting Services?

Thanks in advance

Doug

www.cooltimbers.com

"Art for your soul!"

You should be able to use the "Everyone" SG. I don't know of any other easy way to do this.sql

report usage...

I have 300 odd reports on my sql 2k server, is there a way to track and view
the usage for the reports?Take a look into the the ExecutionLog table in ReportServer database of your
Reporting Service installation.
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:AF1FB30C-340B-46BF-961A-AF74FD974D46@.microsoft.com...
>I have 300 odd reports on my sql 2k server, is there a way to track and
>view
> the usage for the reports?|||Thanks for the help...Is there a way to relate the reportID back to a report
name?
"Oleg Yevteyev" wrote:
> Take a look into the the ExecutionLog table in ReportServer database of your
> Reporting Service installation.
>
> "beeyule" <beeyule@.discussions.microsoft.com> wrote in message
> news:AF1FB30C-340B-46BF-961A-AF74FD974D46@.microsoft.com...
> >I have 300 odd reports on my sql 2k server, is there a way to track and
> >view
> > the usage for the reports?
>
>|||Querying and Reporting on Report Execution Log Data
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:6803F321-0CF1-403C-86D9-A8A73C5C8A17@.microsoft.com...
> Thanks for the help...Is there a way to relate the reportID back to a
> report
> name?
>
> "Oleg Yevteyev" wrote:
>> Take a look into the the ExecutionLog table in ReportServer database of
>> your
>> Reporting Service installation.
>>
>> "beeyule" <beeyule@.discussions.microsoft.com> wrote in message
>> news:AF1FB30C-340B-46BF-961A-AF74FD974D46@.microsoft.com...
>> >I have 300 odd reports on my sql 2k server, is there a way to track and
>> >view
>> > the usage for the reports?
>>

Report Timeout Issue

I have a report timeout issue when I view the reports from report manager.
According to execution logs my report ran in about 8 minutes. However,
during the execution the report manager times out after the first minute and
displays action canceled. (The task bar changes from long report link to
"connecting to server bla bla bla". After that, in a few seconds, the error
message pops up.)
While digging through the list, I have found these as possible causes.
1. Set the http connection timeout in IIS where reporting server is
installed.
2. Set Query timeout in RDL
3. Set Web service client timeout.
4. Set reportProcessingTimeout as system level property or report level
property.
In config IIS and RDL time out are set to 600 and 1800 secs respectively.
How can I check web service client timeout and how can I set
reportProcessingTimeout? Are there any other settings I should check for
this issue?
Thanks.
CDIt tooks exactly 60 seconds to RS time out. First the task bar changes from
the address to connecting to server bla bla bla after another minute, Action
Cancelled message popsup.
I was playing with RSReportServer.config file. I changed a few parameters,
which didn't help of course. Is it sufficient to restart RS services and www
service on win 2003 machine to apply the new config settings or do I have to
do something else?
Thanks a lot
CD
"DC" <DC@.yahoo.com> wrote in message
news:u9d2WCBnEHA.1800@.TK2MSFTNGP15.phx.gbl...
> I have a report timeout issue when I view the reports from report manager.
> According to execution logs my report ran in about 8 minutes. However,
> during the execution the report manager times out after the first minute
and
> displays action canceled. (The task bar changes from long report link to
> "connecting to server bla bla bla". After that, in a few seconds, the
error
> message pops up.)
> While digging through the list, I have found these as possible causes.
> 1. Set the http connection timeout in IIS where reporting server is
> installed.
> 2. Set Query timeout in RDL
> 3. Set Web service client timeout.
> 4. Set reportProcessingTimeout as system level property or report level
> property.
> In config IIS and RDL time out are set to 600 and 1800 secs respectively.
> How can I check web service client timeout and how can I set
> reportProcessingTimeout? Are there any other settings I should check for
> this issue?
> Thanks.
> CD
>|||Some more info about my timeout issue. When I run the report from VS,
without restricting parameters, I receive outofmemory error after 10
minutes. If I run the query with a few restricting parameters, the report
shows up properly after 4 minutes, which doesn't happen on report manager.
Here are my config and log files - another wierd thing I realize in my log
files is WebApp log says DatabaseQueryTimeout is not set so default to 30
sec. The other hand report server log file says DatabaseQueryTimeout is set
to '1200' as specified at config file. Any help would be really appriciated.
Thanks.
CD
<Configuration>
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAUgBlAHA
AbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAO8FzVdcu5BIKubzECnNHiIAAAAA
BIAAAKAAAAAQAAAABnuEnlJ6HCYNdxFNukwafSgBAACS3ffr9Zc2xw/odaxolOYJPVwbU4ypb4/5
gcU64sVF2JxKZtWkmLOZmNQhLimhxd2/rG1O2Cki3apdyDqTkhgrzMRhypP3S8lOY/4Q5Oy2u4RG
ZhMkw/XLkU9qXA5hY6hpOqjIq2B+7gQ2nApDxLhJ/Hxy8SBVqGX/tx5PesCH07v3XAJR0No9Sf0Q
SrvaQMcms1dQ8R+5tPi8yeshK1m0YlFGtFE7AzN9HSQehPC9K5BOZdngTLVgFiYnUq6yFZzChfK0
DafRrp31cMRQoP/lDN0qKg+76OfqyHGQ7dX3Nq3wF+l5x0TbhseBdHYInFHMGTfCO+50yWHPZFJh
QROOcN6dIHOyxdbOlDaVfmqAHW9RWyQo1QaTbYpESZ8yGAuoNcct+MRzYBQAAAD2NINjB49+UjeL
TM/32cM+tm2Efw==</Dsn>
<ConnectionType>Impersonate</ConnectionType>
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAU
gBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAOINUpgdIZeEXU3n8qnQYtcAAAAA
BIAAAKAAAAAQAAAAsbOR9m0262nd6XCybTV/AiAAAABvYXDGqkvg5P2Zd55SPP6heZyNvw+jyQ+r
Lx6Qmhy7nhQAAAAEvamqoaAIum7GC7mn2c3IiMcUtA==</LogonUser>
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAA
AUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAEj5jp/Vyo7KnomNyHH0VwMAAAAA
BIAAAKAAAAAQAAAAuHejR1tO5W9Gf4JKYmy+dRAAAAAQ73ovMYnFVRfG5zOoUQfJFAAAAFuQzeMP
ZLNXEZQEpCbBr6McvXyD
</LogonDomain>
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAU
gBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAFEWJL8iLEIAFj7aVXNTX5wAAAAA
BIAAAKAAAAAQAAAAToDz75beiDZy9QrFubtrjiAAAADLxPycsLUM9WpDvQhs1fpBWiy9U2RD2eNh
gDQnPgdzfhQAAAC5rw7ykRDPFF4023KVrSatgcBgfQ==</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{7a490394-c71b-41a1-982b-c4ad17dc026a}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="600"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="1200"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://10.1.1.61/ReportServer2</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvide
r,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,Report
ingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>10.1.1.245</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>cem@.hirzel.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,Reportin
gServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Mi
crosoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsof
t.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.
ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Micros
oft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsof
t.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExte
nsion,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExte
nsion,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExten
sion,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
osoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExt
ension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx<
/OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDown
loadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.asp
x</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.asp
x</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</
OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</O
WCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,Repo
rtingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,Reporting
ServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEvent
Handler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
----
--
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__09_17_2004_10_24_27.log</Path>
<SystemName>DELL04-02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!bac!9/17/2004-10:24:27:: i INFO: Reporting Web Server started
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing ConnectionType to
'1' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
DatabaseQueryTimeout to '1200' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was
not specified in Configuration file.
w3wp!resourceutilities!bac!9/17/2004-10:24:27:: i INFO: Running on 1
physical processors, 2 logical processors
w3wp!resourceutilities!bac!9/17/2004-10:24:27:: i INFO: Reporting Services
starting SKU: Developer
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Running Requests Scavenger
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!c84!09/17/2004-10:24:31:: i INFO: Call to GetPermissions:/
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Exporting public key
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Performing sku validation
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Importing existing encryption
key
w3wp!library!c84!09/17/2004-10:24:32:: i INFO: Call to GetSystemPermissions
w3wp!library!c84!09/17/2004-10:24:37:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!c84!09/17/2004-10:24:37:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesCaseAvgPrice
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
w3wp!library!c84!09/17/2004-10:24:45:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Initializing
ResponseBufferSizeKb to default value of '64' KB because it was not
specified in Server system properties.
w3wp!library!bac!09/17/2004-10:24:46:: i INFO: Initializing
UseSessionCookies to 'True' as specified in Server system properties.
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Initializing SessionTimeout
to '600' second(s) as specified in Server system properties.
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Initializing
SessionAccessTimeout to default value of '600' seconds because it was not
specified in Server system properties.
w3wp!session!fa4!09/17/2004-10:24:47:: i INFO: LoadSnapshot: Item with
session: rvoibn45odxph345gud0ok2d, reportPath:
/SalesReport/BrokerSalesCaseAvgPrice, userName: HIRZEL\cem not found in the
database
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!fa4!09/17/2004-10:24:48:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-10:24:57:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!bac!09/17/2004-10:24:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!runningjobs!c84!9/17/2004-10:25:27:: i INFO: Adding: 2 running jobs to
the database
w3wp!library!c84!09/17/2004-10:25:58:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!c84!09/17/2004-10:25:59:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!9/17/2004-10:26:49:: i INFO: Initializing
SqlStreamingBufferSize to default value of '64640' Bytes because it was not
specified in Server system properties.
w3wp!library!bac!9/17/2004-10:26:49:: i INFO: Initializing
SnapshotCompression to 'SQL' as specified in Server system properties.
w3wp!library!bac!09/17/2004-10:26:51:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-10:26:51:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!runningjobs!434!9/17/2004-10:27:27:: i INFO: Adding: 1 running jobs to
the database
w3wp!library!c84!09/17/2004-10:28:12:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!c84!09/17/2004-10:28:12:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!library!fa4!09/17/2004-10:34:26:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!fa4!09/17/2004-10:34:27:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!library!bac!9/17/2004-10:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-10:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-10:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-11:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-11:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!09/17/2004-11:18:56:: i INFO: Call to GetPermissions:/
w3wp!library!c84!09/17/2004-11:18:56:: i INFO: Call to GetSystemPermissions
w3wp!library!c84!9/17/2004-11:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-12:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-12:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-12:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-13:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-13:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!09/17/2004-13:22:31:: i INFO: Call to GetPermissions:/
w3wp!library!fa4!09/17/2004-13:22:31:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:22:38:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:22:38:: i INFO: Call to GetSystemPermissions
w3wp!library!fa4!09/17/2004-13:22:43:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesCaseAvgPrice
w3wp!library!fa4!09/17/2004-13:22:43:: i INFO: Call to GetSystemPermissions
w3wp!library!fa4!09/17/2004-13:22:47:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!fa4!09/17/2004-13:22:47:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:22:55:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!bac!09/17/2004-13:22:55:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:23:07:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:23:07:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!webserver!bac!09/17/2004-13:23:08:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='b6e1061c-d8bd-46da-a12f-bc592acf8a64'
w3wp!webserver!8c!09/17/2004-13:23:09:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='ad1c7113-7c0f-4fe4-9cbe-c8cc01f79e68'
w3wp!webserver!8c!09/17/2004-13:23:09:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='ad1c7113-7c0f-4fe4-9cbe-c8cc01f79e68'
w3wp!library!bac!09/17/2004-13:23:16:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:23:16:: i INFO: Call to GetSystemPermissions
w3wp!library!8c!09/17/2004-13:23:18:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesInCases
w3wp!library!8c!09/17/2004-13:23:19:: i INFO: Call to GetSystemPermissions
w3wp!library!8c!09/17/2004-13:23:27:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesInCases' )
w3wp!runningjobs!bac!9/17/2004-13:23:27:: i INFO: Adding: 1 running jobs to
the database
w3wp!library!8c!09/17/2004-13:23:28:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!8c!09/17/2004-13:23:33:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!8c!09/17/2004-13:23:33:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!bac!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:38:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:38:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:38:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!bac!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!8c!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:40:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:40:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:40:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!bac!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:42:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:43:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!bac!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!bac!09/17/2004-13:23:49:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:23:50:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:23:52:: i INFO: Call to
GetPermissions:/SalesReport/CustomerSalesByBillingAccount
w3wp!library!bac!09/17/2004-13:23:53:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:24:07:: i INFO: Call to RenderFirst(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!library!bac!09/17/2004-13:24:08:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:24:19:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!8c!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!bac!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!8c!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!934!09/17/2004-13:24:22:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!cache!934!09/17/2004-13:24:22:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!934!09/17/2004-13:24:22:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!bac!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!934!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!bac!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!934!9/17/2004-13:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!09/17/2004-13:24:53:: i INFO: Call to RenderFirst(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!library!bac!09/17/2004-13:24:54:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:25:03:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!934!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!bac!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!934!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!8c!09/17/2004-13:25:08:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!cache!8c!09/17/2004-13:25:08:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!8c!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!8c!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!bac!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!8c!09/17/2004-13:25:09:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!8c!09/17/2004-13:25:15:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!chunks!8c!09/17/2004-13:25:15:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=4a2b5a60-bf8e-4e04-8652-7435411127e1
w3wp!cache!8c!09/17/2004-13:25:19:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!8c!09/17/2004-13:25:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!library!8c!09/17/2004-13:32:59:: i INFO: Call to CreateReport(
'CustomerSalesByBillingAccount', '/SalesReport', def)
w3wp!library!8c!09/17/2004-13:32:59:: i INFO: Call to SetReportDefinition(
'/SalesReport/CustomerSalesByBillingAccount', def )
w3wp!library!8c!9/17/2004-13:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
---
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__09_17_2004_10_24_17.log</Path>
<SystemName>DELL04-02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was
not specified in Configuration file.|||Check the IIS timeout for the Report Manager website.

Report subscriptions

Is there a way to either query the ReportServer database or view a report within Reporting Services to show all the subscriptions and their next run time? The "My Subscriptions" area only shows when a report was last run for subscriptions I created. Since we'll end up moving dozens of reports from Crystal to SSRS and multiple people will be creating schedules, it'd be handy to have a nice list displaying exactly what's scheduled and when they'll run next.

Any ideas are greatly appreciated.

Thanks

You would have to create an user interface to pull the data from the SQL Server Agent for this.

HTH, Jens Suessmyer.

http://www.sqlserver2005.de|||

For subscriptions, you can also pull the data from the Subscriptions table in the ReportServer DB.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Report subscriptions

Is there a way to either query the ReportServer database or view a report within Reporting Services to show all the subscriptions and their next run time? The "My Subscriptions" area only shows when a report was last run for subscriptions I created. Since we'll end up moving dozens of reports from Crystal to SSRS and multiple people will be creating schedules, it'd be handy to have a nice list displaying exactly what's scheduled and when they'll run next.

Any ideas are greatly appreciated.

Thanks

You would have to create an user interface to pull the data from the SQL Server Agent for this.

HTH, Jens Suessmyer.

http://www.sqlserver2005.de
|||

For subscriptions, you can also pull the data from the Subscriptions table in the ReportServer DB.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Report Sub Totals

I've been banging my head for a view days on this and I'm ready for a little
humility. :)
Here is the simplified recordset:
Field1 Field2 Field3 Field4
AAAAA 11111 bat1 3
AAAAA 11111 bat2 4
AAAAA 22222 bat1 0
AAAAA 22222 bat2 2
BBBBB 33333 bat1 1
BBBBB 33333 bat2 3
BBBBB 44444 bat1 1
BBBBB 44444 bat2 3
And the report is supposed to look like this:
AAAAA 11111 bat1 3
bat2 4
22222 bat1 0
bat2 2
AAAAA Subtotal: bat1 3
bat2 6
BBBBB 33333 bat1 1
bat2 3
44444 bat1 1
bat2 3
BBBBB Subtotal: bat1 2
bat2 6
Totals: bat1 5
bat2 12
For the life of me I can't figure out how to make the subtotal include both
types of Field3. I'm sure it's possible...I just don't know where to look
for how. So I'm turning to the collective wisdom of the Internet.
Regards,
David GardnerWhat are you lookin for , is it the sum of al field 4 in relation to
the type in field 3.|||You are correct. The only thing I would add is that it needs to be
sub-totaled by Field1. So in summary:
I need the sum of Field4 in relation to Field3 sub-totaled/grouped by
Field1. Does that make sense?
Dave
"Ivan" wrote:
> What are you lookin for , is it the sum of al field 4 in relation to
> the type in field 3.
>|||Try a UNION query along the lines of:
SELECT Field1, Field2, Field3, Field4
FROM Table1
UNION
SELECT Field1, 'SubTotal' AS Field2, Field3, Sum(Field4) AS Field4
FROM Table1
GROUP BY Field1, 'SubTotal' AS Field2, Field3
ORDER BY 1, 2, 3
This should give you the dataset needed for the report.
GeoSynch
"David Gardner" <David.Gardner-Logan@.REMOVECAPSrrd.com> wrote in message
news:A3F5D991-6C7E-479A-A4D0-A3C0B605B9CF@.microsoft.com...
> I've been banging my head for a view days on this and I'm ready for a little
> humility. :)
> Here is the simplified recordset:
> Field1 Field2 Field3 Field4
> AAAAA 11111 bat1 3
> AAAAA 11111 bat2 4
> AAAAA 22222 bat1 0
> AAAAA 22222 bat2 2
> BBBBB 33333 bat1 1
> BBBBB 33333 bat2 3
> BBBBB 44444 bat1 1
> BBBBB 44444 bat2 3
> And the report is supposed to look like this:
> AAAAA 11111 bat1 3
> bat2 4
> 22222 bat1 0
> bat2 2
> AAAAA Subtotal: bat1 3
> bat2 6
> BBBBB 33333 bat1 1
> bat2 3
> 44444 bat1 1
> bat2 3
> BBBBB Subtotal: bat1 2
> bat2 6
> Totals: bat1 5
> bat2 12
>
> For the life of me I can't figure out how to make the subtotal include both
> types of Field3. I'm sure it's possible...I just don't know where to look
> for how. So I'm turning to the collective wisdom of the Internet.
> Regards,
> David Gardner
>|||"GeoSynch" wrote:
> Try a UNION query along the lines of:
> SELECT Field1, Field2, Field3, Field4
> FROM Table1
> UNION
> SELECT Field1, 'SubTotal' AS Field2, Field3, Sum(Field4) AS Field4
> FROM Table1
> GROUP BY Field1, 'SubTotal' AS Field2, Field3
> ORDER BY 1, 2, 3
> This should give you the dataset needed for the report.
>
> GeoSynch
>
So I can assume by your response that you don't believe I can build the
report based on what the dataset looks like now? That makes me feel a little
better in that I'm not that dumb. :) Still it would be nice if there were a
way to build a report like that.
Regards,
David Gardner|||David Gardner wrote:
> "GeoSynch" wrote:
>> Try a UNION query along the lines of:
>> SELECT Field1, Field2, Field3, Field4
>> FROM Table1
>> UNION
>> SELECT Field1, 'SubTotal' AS Field2, Field3, Sum(Field4) AS Field4
>> FROM Table1
>> GROUP BY Field1, 'SubTotal' AS Field2, Field3
>> ORDER BY 1, 2, 3
>> This should give you the dataset needed for the report.
> So I can assume by your response that you don't believe I can build the
> report based on what the dataset looks like now? That makes me feel a little
> better in that I'm not that dumb. :) Still it would be nice if there were a
> way to build a report like that.
An alternate approach "based on what the dataset looks like now" would be
to encapsulate a LIST table object and a LIST subtotal object within a
parent LIST object. This may be more elegant but UNION is easier and
results are all that matter, unless you've got lot's of time on your hands.
GeoSynch|||> An alternate approach "based on what the dataset looks like now" would be
> to encapsulate a LIST table object and a LIST subtotal object within a
> parent LIST object. This may be more elegant but UNION is easier and
> results are all that matter, unless you've got lot's of time on your hands.
>
> GeoSynch
Your parent LIST/subtotal LIST option sounded interesting and I do wish I
had a little more time to explore. However, I went with a modification of
what the recordset looked like. That did, in fact, turn out to be the more
efficient way to handle the formatting of the report. I appreciate
everyone's input!
Regards,
David Gardner

Report Server Organization

I have several sub reports and some graphics I don't necessarily want the users to see or open. Is there a way to hide items from view but still have them available for execution? I tried creating a sub folder and moving the sub reports but the calling reports couldn't find them.

Thanks!

Since you can't have folders in VS.NET, you need to adjust the report paths to the subreports manually in the master report definition. Also, there is Hide in list view report property you can enable to hide the report in the default view in the Report Manager, assuming that the end users will use the Report Manager to view reports.

Report server asking for credentials again and again (3 times)

I am trying to access reports using custom web application. This application will run under user who have permission to view the reports. When multiple users are accessing reports, if we try to open any report from web application, after some time (around 7-8 mins.) report server is popping up credentials window and if we provide credentials, it is again giving credentials pop up after 5 mins. and after retrying 3 times like this, reports throws error saying 'You are not authorized to view page'. Is there any time out period specified for reports?

As per my investigation, report server default timeout is '30' minutes. I have not changed any values in Report server config files(rsreportserver.config). Nowhere I found that after 5 mins. the credentials pop up should opened?

Any help in this regard, greatly appreciated.

This doesn't sound like a timeout related issue but a security problem. The credentials window will pop up when the server tells the browser that it doesn't have authorization, and the browser gives you three changes to enter the proper credentials. I'm not sure why this would work when the application starts and then start failing after a period of time. If you go directly to the report on the reportserver, do you have the same problem?

|||

For queries which takes less time, reports are running fine. But for long running queries, after 5 mins. around, it is prompting for credentials. This prompting will continue for 2-3 times and atlast page throws message 'You are not authorized to view this page'.

I checked in IIS application pool properties, under which reporting services runs. I found 'TimeSetting Period' under Health tab as 5 mins. Is this the one caused to prompt for credentials for every 5 mins?

Configuration: Sql 2005 Reporting Services, IIS 6.0, Windows 2003

|||

We could able to find the reason why this is happening. We have 2 web servers for Reporting and these 2 boxes runs under Load balancer with BIG-IP. There is timeout value set at TCP Profiler in VIP. Now this has been changed and every thing is running fine.

Report Security: CAnt view report

Hi,
We have some websites. We want to attch a link on each wrbsite which would
take the users to a different reports. Please suggest what will be the best
security mechansism for this scenario..
Also, I was trying to implement the simplest security mechansim,i.e I craetd
a user called User1 and created a Group called Group1. I added the User1 to
be a member of Group1. Now from Reports Manager, I assigned the Browser role
to the Group1. Also, in the virtual directory for Reports & Report Server, I
enabled Integrated Windows Authentication. Now, when I try to view the
report, I get a prompt for username & passowrd. So when I type User1 as
username & the password asscoated with the user, i cant view the report. I
get the error : The Page cant be dispalyed. Also when i click a the link
Reports.com because that is the domain we are using for our Reports.I
get...You are not authorized to viw the reports...
Plz help with this issue.
--
pmudHi,
I still need your suggestion about which security mechansim should be used
in our scenario but I figured out the second question of my previous post,
which is the basic sercuirty mechansim for a report. It was not displaying
the report coz for the user account in Local Users I had checked the check
box, "User should change password on next logon". When I cleared that check
boz and didnt check any of the check boxes, i was able to view the reports.
Any suggestion would be helpful about which security mechansim should be
used.
Thanks
"pmud" wrote:
> Hi,
> We have some websites. We want to attch a link on each wrbsite which would
> take the users to a different reports. Please suggest what will be the best
> security mechansism for this scenario..
> Also, I was trying to implement the simplest security mechansim,i.e I craetd
> a user called User1 and created a Group called Group1. I added the User1 to
> be a member of Group1. Now from Reports Manager, I assigned the Browser role
> to the Group1. Also, in the virtual directory for Reports & Report Server, I
> enabled Integrated Windows Authentication. Now, when I try to view the
> report, I get a prompt for username & passowrd. So when I type User1 as
> username & the password asscoated with the user, i cant view the report. I
> get the error : The Page cant be dispalyed. Also when i click a the link
> Reports.com because that is the domain we are using for our Reports.I
> get...You are not authorized to viw the reports...
> Plz help with this issue.
> --
> pmud