cant comm with RS

After installing SP1 Report Manager can't communicate with Report Server.
Error says...
Unable to communicate with report server. Please verify that the report
server is operational.
The report server service is running. I rebooted after installing sp1.
Any ideas?
Thanks,
GaryVerify that you can access http://<machinename>/ReportServer. If you can,
make sure this URL is specified in the config file of Report Manager
(RSWebApplication.config).
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Gary D." <Dean@.nospam.com> wrote in message
news:#IQgxtIhEHA.140@.TK2MSFTNGP12.phx.gbl...
> After installing SP1 Report Manager can't communicate with Report Server.
> Error says...
> Unable to communicate with report server. Please verify that the report
> server is operational.
> The report server service is running. I rebooted after installing sp1.
> Any ideas?
> Thanks,
> Gary
>

Can't close IDE, modal dialog, anyone know what's causing this?

I've only seen this happen when using the report designer, and I think only
when working with Dundas chart properties. I don't have a modal dialog
open, or at least not that I can find. I use alt-esc to loop through the
dialogs on the OS, nothing. Microsoft has an entry in support, it says it
usually happens when I try to shut down and have left a modal dialog
open...only there is no dialog to close. I end up ending the IDE process
tree. Anyone else getting this and/or know the cause?
Microsoft Visual Studio cannot shut down because a modal dialog is active.
Close the active dialog and try again.
Yes it's Friday the 13th :)
Steve MunLeeuwhttp://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
This is a lot better description, sorry for posting.
Steve MunLeeuw
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
> I've only seen this happen when using the report designer, and I think
> only when working with Dundas chart properties. I don't have a modal
> dialog open, or at least not that I can find. I use alt-esc to loop
> through the dialogs on the OS, nothing. Microsoft has an entry in
> support, it says it usually happens when I try to shut down and have left
> a modal dialog open...only there is no dialog to close. I end up ending
> the IDE process tree. Anyone else getting this and/or know the cause?
> Microsoft Visual Studio cannot shut down because a modal dialog is active.
> Close the active dialog and try again.
> Yes it's Friday the 13th :)
> Steve MunLeeuw
>|||If I've been working with the code view of reports, my VS 2005 doesn't close
like normal. I usually have to close it by killing the DevEnv.exe service in
Task Manager...
Not a very elegant solution, but it will close. ;)
Kaisa M. Lindahl Lervik
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:ekQn5Ty7GHA.3740@.TK2MSFTNGP05.phx.gbl...
> http://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
> This is a lot better description, sorry for posting.
> Steve MunLeeuw
> "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
>> I've only seen this happen when using the report designer, and I think
>> only when working with Dundas chart properties. I don't have a modal
>> dialog open, or at least not that I can find. I use alt-esc to loop
>> through the dialogs on the OS, nothing. Microsoft has an entry in
>> support, it says it usually happens when I try to shut down and have left
>> a modal dialog open...only there is no dialog to close. I end up ending
>> the IDE process tree. Anyone else getting this and/or know the cause?
>> Microsoft Visual Studio cannot shut down because a modal dialog is
>> active. Close the active dialog and try again.
>> Yes it's Friday the 13th :)
>> Steve MunLeeuw
>|||Kaisa M. Lindahl Lervik wrote:
> If I've been working with the code view of reports, my VS 2005 doesn't close
> like normal. I usually have to close it by killing the DevEnv.exe service in
> Task Manager...
> Not a very elegant solution, but it will close. ;)
> Kaisa M. Lindahl Lervik
>
> "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> news:ekQn5Ty7GHA.3740@.TK2MSFTNGP05.phx.gbl...
> > http://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
> >
> > This is a lot better description, sorry for posting.
> >
> > Steve MunLeeuw
> >
> > "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> > news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
> >> I've only seen this happen when using the report designer, and I think
> >> only when working with Dundas chart properties. I don't have a modal
> >> dialog open, or at least not that I can find. I use alt-esc to loop
> >> through the dialogs on the OS, nothing. Microsoft has an entry in
> >> support, it says it usually happens when I try to shut down and have left
> >> a modal dialog open...only there is no dialog to close. I end up ending
> >> the IDE process tree. Anyone else getting this and/or know the cause?
> >>
> >> Microsoft Visual Studio cannot shut down because a modal dialog is
> >> active. Close the active dialog and try again.
> >>
> >> Yes it's Friday the 13th :)
> >> Steve MunLeeuw
> >>
> >
> >
yes..this is happening to me quie a bit when writing a lot of reports
and changing a lot of charts...save soon save often....it looks like
the dundas dialogs and the vs dialogs get a bit confused...that is
all...
Peter
www.peternolan.com

Can't change name of report

Good Morning Guys,

Can anybody tell me how to change the name Property of a report on the Report Server?

When im using the standard Webpage, i can change all the properties i want.

But when i try the same in code. Changing the name property gets me a read-only exception.
The description does change but i actually want the name to change.

public string setProperties(string property,string value, string itemPath)
{
try
{
Property[] props = new Property[1];
Property setProp = new Property();
setProp.Name = property;
setProp.Value = value;
props[0] = setProp;
rpServer.SetProperties(itemPath, props);
}
catch (SoapException ex)
{
throw ex;
}
return "";
}

Is there an easy way around this, or do i have to solve it by creating a new report with a new name, and delete the old one?

Thanks in advance,

You need to call the MoveItem API.|||Tnx Teo,
I still think its strange to have a function to set properties.
And you cant set the most important property :)
Greetings
PS: the blond girl name was to draw attention, cause this issue was quite high prio. ;) Sorry for that.|||

The name isn’t really a property in that it changes the path in the namespace. For example, you can’t have two things with the same path, etc.

PS: How disappointing :-)

Can't Add or Delete new role for new users

I've tried to add or delete a user to read report by using report manager.
User Home -> Properties -> New Role Assignment
Then enter user's doman and id information and check the role. However, it
shows ERROR.
The error message:
"Can't find the role '?' (rsRoleNotFound).
When i tried to delete one of the current user, it shows the same error
message.
The error message:
"Can't find the role '?' (rsRoleNotFound).
However, in my roles table, all roles information are all complete and
correct.
Can anyone tell me what's wrong?"roles" here refers to active directory user. You must add user you want to
the active directory (using control panel->management tools->computer
management->users)
than you can use the user you have added in the service now
"Lisa" wrote:
> I've tried to add or delete a user to read report by using report manager.
> User Home -> Properties -> New Role Assignment
> Then enter user's doman and id information and check the role. However, it
> shows ERROR.
> The error message:
> "Can't find the role '?' (rsRoleNotFound).
> When i tried to delete one of the current user, it shows the same error
> message.
> The error message:
> "Can't find the role '?' (rsRoleNotFound).
> However, in my roles table, all roles information are all complete and
> correct.
> Can anyone tell me what's wrong?
>
>
>|||Hi,
The user i want to add has already added in the management tools.
Is there anyother possiblie way to fix this?
"yuanxm" <yuanxm@.discussions.microsoft.com> ¦b¶l¥ó
news:95A7D902-5815-4F26-8A75-FFB17C05C974@.microsoft.com ¤¤¼¶¼g...
> "roles" here refers to active directory user. You must add user you want
to
> the active directory (using control panel->management tools->computer
> management->users)
> than you can use the user you have added in the service now
> "Lisa" wrote:
> > I've tried to add or delete a user to read report by using report
manager.
> > User Home -> Properties -> New Role Assignment
> > Then enter user's doman and id information and check the role. However,
it
> > shows ERROR.
> > The error message:
> > "Can't find the role '?' (rsRoleNotFound).
> > When i tried to delete one of the current user, it shows the same error
> > message.
> > The error message:
> > "Can't find the role '?' (rsRoleNotFound).
> >
> > However, in my roles table, all roles information are all complete and
> > correct.
> >
> > Can anyone tell me what's wrong?
> >
> >
> >
> >
> >

Can't Add New Report

In Visual Studio when I create a new Report Project, once it's created I go
into Solution Explorer, right click on the "Reports" folder and select "Add
New Report", and I get the following error:
Exception from HRESULT: 0x8013141A
I've re-installed Visual Studio, the .NET framework, and Reporting Services,
and after all that it still gives me the error.
Any suggestions?
Michael BodnarSome DLL is failing to load. The only sure way to diagnose the problem is
to attach a debugger and see what exceptions it's throwing.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>|||Can you dump out a list of DLLs that are loaded into the VS process when the
error occurs? You can either use a tool like procexp.exe
(http://www.sysinternals.com/ntw2k/freeware/procexp.shtml) or attach another
instance of VS as a debugger. Using VS, display the Modules window, select
all rows, copy, and paste into a text file.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>|||The whole problem was I was trying to install it off a network drive. It
must not have been seeing some files over the network or something, or maybe
some files got corrupt. I installed it with the CD and it works fine now.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>

can't access report through report manager...

Here is what is happening.
I have a working project PROG created using VS.Net. I create a new
project for reports RPTPROJ under PROJ.
I create several reports RPT1.RDL, RPT2.RDL under the new project
RPTPROJ.
Now I start the REPORT MANAGER and create a new folder (MYREPORTS) and
upload all my reports (RDLs) into this new folder. Now when I click on
any of the reports from here, it doesn't show up. Only shows up an
"Action Canceled" message.
Here is the URL, it generates for one of the reports:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fRPTPROJ%2fRPT1
But when I goto,
http://localhost/reportserver?%2fPROJ%2fRPTPROJ
I can see all my reports and run them.
Please can someone explain what I should do to run them from the
report manager?
ThanksWhen you publish to the report server in Report Designer, in the project
properties dialog (where you set your URL to the report server), there is a
target folder property. Set that to MYREPORTS. By default it is the
project name, which is why you're getting link s containing /RPTPROJ/RPT1
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roy" <nroy@.iastate.edu> wrote in message
news:ad20302f.0408091310.6e20c373@.posting.google.com...
> Here is what is happening.
> I have a working project PROG created using VS.Net. I create a new
> project for reports RPTPROJ under PROJ.
> I create several reports RPT1.RDL, RPT2.RDL under the new project
> RPTPROJ.
> Now I start the REPORT MANAGER and create a new folder (MYREPORTS) and
> upload all my reports (RDLs) into this new folder. Now when I click on
> any of the reports from here, it doesn't show up. Only shows up an
> "Action Canceled" message.
> Here is the URL, it generates for one of the reports:
> http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fRPTPROJ%2fRPT1
> But when I goto,
> http://localhost/reportserver?%2fPROJ%2fRPTPROJ
> I can see all my reports and run them.
> Please can someone explain what I should do to run them from the
> report manager?
> Thanks|||Lukasz,
I made the changes suggested by you but still the same problem. The URL it shows is:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fMYREPORTS%2fRPT1
What am I doing wrong?
nroy@.iastate.edu (Roy) wrote in message news:<ad20302f.0408091310.6e20c373@.posting.google.com>...
> Here is what is happening.
> I have a working project PROG created using VS.Net. I create a new
> project for reports RPTPROJ under PROJ.
> I create several reports RPT1.RDL, RPT2.RDL under the new project
> RPTPROJ.
> Now I start the REPORT MANAGER and create a new folder (MYREPORTS) and
> upload all my reports (RDLs) into this new folder. Now when I click on
> any of the reports from here, it doesn't show up. Only shows up an
> "Action Canceled" message.
> Here is the URL, it generates for one of the reports:
> http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fRPTPROJ%2fRPT1
> But when I goto,
> http://localhost/reportserver?%2fPROJ%2fRPTPROJ
> I can see all my reports and run them.
> Please can someone explain what I should do to run them from the
> report manager?
> Thanks

cant access report manager page

Hi friends
suddenly today i cant access my report manager page. i get error "request timed out". it worked nicely yesterday.
any ideas on how to troubleshoot this one.

am running sql server 2005 on xp professional machine.
ThanksMake sure IIS is running and security hasn't change. Has anything changed on machine since last working (e.g. new software, service packs)?|||

Yes Philip

i tried to uninstall sqlexpress but had issues with it. but finally i managed to uninstall successfully and after restarting my machine i can access report manager page.

Thanks

|||Excellent result!

cant access report manager options

Hi friends
i installed sql server 2005 standard edi with reporting services on win2003 server.
i can open report manager page in IE but i cant access anything i mean report builder,upload file link option etc., they are disabled for some reason.

Yes i went to site settings(interestingly i can access this !!) and gave all rights i see there to the user but no avail.

interestingly i can access all options from IIS manager !
any ideas how to fix this ?
am using IIS6its still a problem !!
any help much appreciated. Thanks|||Does giving yourself Local Administrator on the server machine help?
Or Domain Administrator

By default you should be

BUILTIN\Administrators Content Manager

|||

Hi Jerry

Actually i logged in as domain administrator. what i dont understand is i cant access any options on report manager page (except site settings) in IE but i can access everything in IIS's management console!!

i even tried deleting virtual directories and reconfigured reporting services still made no difference.!

|||finally got it working
i added relevant user on "properties" page that we see reportmanager home page. everything fine now :)

cant access report manager options

Hi friends
i installed sql server 2005 standard edi with reporting services on win2003 server.
i can open report manager page in IE but i cant access anything i mean report builder,upload file link option etc., they are disabled for some reason.

Yes i went to site settings(interestingly i can access this !!) and gave all rights i see there to the user but no avail.

interestingly i can access all options from IIS manager !
any ideas how to fix this ?
am using IIS6its still a problem !!
any help much appreciated. Thanks|||Does giving yourself Local Administrator on the server machine help?
Or Domain Administrator

By default you should be

BUILTIN\Administrators Content Manager

|||

Hi Jerry

Actually i logged in as domain administrator. what i dont understand is i cant access any options on report manager page (except site settings) in IE but i can access everything in IIS's management console!!

i even tried deleting virtual directories and reconfigured reporting services still made no difference.!

|||finally got it working
i added relevant user on "properties" page that we see reportmanager home page. everything fine now :)

Can't access Report Manager on another computer

I have Reporting Services for SQL Server 2005 (beta 2) installed on 2
Windows XP Pro boxes that are part of the same Windows workgroup. I
need to deploy reports from one box to the other, but I can't see the
Report Manager on the opposing machine, even though I can see it
locally on the respective machine.
I know we're talking beta here, but I need to give a coworker a way to
have access to all our reports on his laptop. Since Reporting
Services for SQL 2000 requires a server, the only way he and I can
have the reports locally on Win XP Pro is via Reporting Services 2005.
Any idea how I can get access to his Report Manager? When I go to
Report Manager on my machine, I go to
"http://MyComputerName/Reports$2005", which works fine. When I'm on
his machine and go to Report Manager, I go to
"http://HisComputerName/Reports$2005" and that works fine. When I try
the same path from my computer, I get a "page not found" error.
I am a local administrator on his machine and have full directory
access (e.g. //ComputerName/C$). I checked the IIS permissions for
his Reports$2005 virtual directory and the Directory Security
authentication method is set to Integrated Windows authentication. I
tried Anonymous access, but that didn't help. Any ideas?I figured it out. Service Pack 2 for Win XP Pro was installed on the
remote machine, so the firewall was preventing me from getting to the
Report Server. I simply disabled the firewall temporarily so I could
deploy my reports. I didn't know how to configure the firewall to
allow me to access the computer, so I found that disabling the
firewall was the best method.
Anyway, that solved my problem.
steve.pantazis@.gmail.com (Steve Pantazis) wrote in message news:<437b6286.0409250937.485cb6ac@.posting.google.com>...
> I have Reporting Services for SQL Server 2005 (beta 2) installed on 2
> Windows XP Pro boxes that are part of the same Windows workgroup. I
> need to deploy reports from one box to the other, but I can't see the
> Report Manager on the opposing machine, even though I can see it
> locally on the respective machine.
> I know we're talking beta here, but I need to give a coworker a way to
> have access to all our reports on his laptop. Since Reporting
> Services for SQL 2000 requires a server, the only way he and I can
> have the reports locally on Win XP Pro is via Reporting Services 2005.
> Any idea how I can get access to his Report Manager? When I go to
> Report Manager on my machine, I go to
> "http://MyComputerName/Reports$2005", which works fine. When I'm on
> his machine and go to Report Manager, I go to
> "http://HisComputerName/Reports$2005" and that works fine. When I try
> the same path from my computer, I get a "page not found" error.
> I am a local administrator on his machine and have full directory
> access (e.g. //ComputerName/C$). I checked the IIS permissions for
> his Reports$2005 virtual directory and the Directory Security
> authentication method is set to Integrated Windows authentication. I
> tried Anonymous access, but that didn't help. Any ideas?sql

Can't access Report Manager -> Http status 401: Unauthorized

I've been struggeling with this problem on and off for a few weeks now.
I can't access the Report Manager, but I can access Report Server.
The server: Windows 2003 Standard Edition, no SP.
It runs SQL Server Enterprise Edition sp 3 and Analysis Services sp 3.
I've installed Reporting Services Ent. Edition, sp 1.
I can access http://machinename/reportserver but not
http://machinename/reports. I get the login box, but I get this error
message when "logged in":
The request failed with HTTP status 401: Unauthorized.
Both Vdirs have Integrated Windows Authentication and not enabled Anonymous
Access.
I've tried logging in with 3 different users, but they all fail.
All help appreciated for getting this to work!
Kaisa M. LindahlI have the identical problem, but the login provided has the necessary rights
and Admin in both the Domain and local Builtin Admin groups.
--
Keith Powers, MCDBA
"David Siebert" wrote:
> What rights do the logins you used have for the server on which RS is located?
> "Kaisa M. Lindahl" wrote:
> > I've been struggeling with this problem on and off for a few weeks now.
> > I can't access the Report Manager, but I can access Report Server.
> >
> > The server: Windows 2003 Standard Edition, no SP.
> > It runs SQL Server Enterprise Edition sp 3 and Analysis Services sp 3.
> > I've installed Reporting Services Ent. Edition, sp 1.
> >
> > I can access http://machinename/reportserver but not
> > http://machinename/reports. I get the login box, but I get this error
> > message when "logged in":
> > The request failed with HTTP status 401: Unauthorized.
> >
> > Both Vdirs have Integrated Windows Authentication and not enabled Anonymous
> > Access.
> > I've tried logging in with 3 different users, but they all fail.
> >
> > All help appreciated for getting this to work!
> >
> > Kaisa M. Lindahl
> >
> >
> >

Can't access my own report

I am trying to access my report from my laptop. Both development computer
and a laptop are on the network with DC. I am using http://devcompip/reports
but I am getting prompted for the network password. I am trying to enter it
but it keeps prompting.
What's a problem?
Thanks for help.On Jun 22, 4:32 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> I am trying to access my report from my laptop. Both development computer
> and a laptop are on the network with DC. I am usinghttp://devcompip/reports
> but I am getting prompted for the network password. I am trying to enter it
> but it keeps prompting.
> What's a problem?
> Thanks for help.
The most common reasons are:
- If you are using a non-IE browser, this may cause the problem.
- If you have the anonymous permissions setup on either the Reports or
ReportServer virtual directory in IIS. You may want to set up Windows
Authentication w/the standard IUSR_MachineName user and allow IIS to
control the password.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I once had another problem. My server was using DHCP and I had this happen
to me. I changed to a fixed IP address and everything was fine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182576182.834732.295990@.m36g2000hse.googlegroups.com...
> On Jun 22, 4:32 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> I am trying to access my report from my laptop. Both development computer
>> and a laptop are on the network with DC. I am
>> usinghttp://devcompip/reports
>> but I am getting prompted for the network password. I am trying to enter
>> it
>> but it keeps prompting.
>> What's a problem?
>> Thanks for help.
>
> The most common reasons are:
> - If you are using a non-IE browser, this may cause the problem.
> - If you have the anonymous permissions setup on either the Reports or
> ReportServer virtual directory in IIS. You may want to set up Windows
> Authentication w/the standard IUSR_MachineName user and allow IIS to
> control the password.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

CanShrink Question

Hello all,

I have a report with a dataset similar to this:

description0 35
description1 0
description2 0
description3 0
description4 0
description5 45
description6 0
description7 0
description8 50
description9 10
.....

I don't care to see the records with a zero numeric value so I've configured the two text boxes the list box to set their values to "nothing" if the numeric value is 0. I've also configured both text boxes canshrink property to true.

When the report renders, I get this:

desc. header numeric header
--
description0 35

description5 45

description8 50
description9 10
....

I get one blank line where the grouping of 0 valued numeric records are. That tells me the canshrink is working, somewhat. What I'm confused about is why the blank line and what I need to stuff into the text box value.

In this particular case, I can go back to the db stored proc and just omit the 0 valued records. But, that doesn't help me if I run into a situation where I don't have that option.

Any help would be appreciated,

Thanks in advance,

Greg Wilkerson

Well, I need to add something. I deployed this report and the can shrink does not work in the deployed version. Through BIDS, it works as described above.

Greg

|||Hi Greg.

I didn't fully understand the question but from what I understod - may be instead of changing the "canshrink" property you should try and change the "visibility" property if the value is zero (Also, you can try and change the width or height of the cells).

Good luck,
Roy.|||

Roy,

You understood things fine. The visibility settings did work out fine, and is a pretty clean implementation. I thought I had tried that in an earlier attempt but I guess didn't get something right. I'm going to have to figure out the intracacies of this canshrink property. And, this rendering differently in BIDS vs. the deployed report is troublesome.

But, I'll figure it out.

Thanks.

Cannot View Reports in Report Manager

Alrighty... This has been a bugger of a pain all day.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.

Cannot View Report Manager

OK.. I'm stumped.
My IE 7 is working fine. I can access any websites I want with one
exception. What is this exception?
I recently installed MS Reporting Services 2000 on this computer. All went
well.
When I try to access the http:// site where all of my reports have been
deployed, IE 7 shows a blank page with the message:
"Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
during the DNS lookup. Contact your system administrator if the problem is
not found by retrying the URL.
I have tried using another Browser (Firefox) on this computer and it
accesses the page just fine. I have even went one step further by trying to
access the http site
from another computer (also using IE7) via an Intranet. It works fine.
This is the only webpage that is not working.
Where can I make changes? It is not asking me for a password. It is not
even partially bringing up the webpage.
I have tried clearing all history inside IE7. I have tried to check the
settings in
the IIS section. I have updated my IE7. I have even uninstalled IE7 and
tried to use IE6 but to no avail. I am using XP Professional.
I don't know where to look next! Is it a Reporting Services issue? IIS
issue? IE7 issue?
Any suggestions would be welcomed.
PatOn Jun 26, 6:30 pm, Pat (Disciple of Aloof-ism)
<PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> OK.. I'm stumped.
> My IE 7 is working fine. I can access any websites I want with one
> exception. What is this exception?
> I recently installed MS Reporting Services 2000 on this computer. All went
> well.
> When I try to access the http:// site where all of my reports have been
> deployed, IE 7 shows a blank page with the message:
> "Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
> during the DNS lookup. Contact your system administrator if the problem is
> not found by retrying the URL.
> I have tried using another Browser (Firefox) on this computer and it
> accesses the page just fine. I have even went one step further by trying to
> access the http site
> from another computer (also using IE7) via an Intranet. It works fine.
> This is the only webpage that is not working.
> Where can I make changes? It is not asking me for a password. It is not
> even partially bringing up the webpage.
> I have tried clearing all history inside IE7. I have tried to check the
> settings in
> the IIS section. I have updated my IE7. I have even uninstalled IE7 and
> tried to use IE6 but to no avail. I am using XP Professional.
> I don't know where to look next! Is it a Reporting Services issue? IIS
> issue? IE7 issue?
> Any suggestions would be welcomed.
> Pat
This link might be helpful.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=842755&SiteID=1
Regards,
Enrique Martinez
Sr. Software Consultant|||Yes... your suggestion worked like a charm. I made the adjustment in IE7.
While I believe that this approach did solve the problem, I cannot say that
it was the exclusive controlling factor. You see, I also un-installed RS
2000 and re-installed it again. My belief is that your recommendation was
the determining factor and not the reinstall of RS 2000.
Thank you.
Pat
"EMartinez" wrote:
> On Jun 26, 6:30 pm, Pat (Disciple of Aloof-ism)
> <PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> > OK.. I'm stumped.
> >
> > My IE 7 is working fine. I can access any websites I want with one
> > exception. What is this exception?
> >
> > I recently installed MS Reporting Services 2000 on this computer. All went
> > well.
> > When I try to access the http:// site where all of my reports have been
> > deployed, IE 7 shows a blank page with the message:
> >
> > "Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
> > during the DNS lookup. Contact your system administrator if the problem is
> > not found by retrying the URL.
> >
> > I have tried using another Browser (Firefox) on this computer and it
> > accesses the page just fine. I have even went one step further by trying to
> > access the http site
> > from another computer (also using IE7) via an Intranet. It works fine.
> > This is the only webpage that is not working.
> >
> > Where can I make changes? It is not asking me for a password. It is not
> > even partially bringing up the webpage.
> >
> > I have tried clearing all history inside IE7. I have tried to check the
> > settings in
> > the IIS section. I have updated my IE7. I have even uninstalled IE7 and
> > tried to use IE6 but to no avail. I am using XP Professional.
> >
> > I don't know where to look next! Is it a Reporting Services issue? IIS
> > issue? IE7 issue?
> >
> > Any suggestions would be welcomed.
> >
> > Pat
>
> This link might be helpful.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=842755&SiteID=1
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 27, 12:34 am, Pat (Disciple of Aloof-ism)
<PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> Yes... your suggestion worked like a charm. I made the adjustment in IE7.
> While I believe that this approach did solve the problem, I cannot say that
> it was the exclusive controlling factor. You see, I also un-installed RS
> 2000 and re-installed it again. My belief is that your recommendation was
> the determining factor and not the reinstall of RS 2000.
> Thank you.
> Pat
> "EMartinez" wrote:
> > On Jun 26, 6:30 pm, Pat (Disciple of Aloof-ism)
> > <PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> > > OK.. I'm stumped.
> > > My IE 7 is working fine. I can access any websites I want with one
> > > exception. What is this exception?
> > > I recently installed MS Reporting Services 2000 on this computer. All went
> > > well.
> > > When I try to access the http:// site where all of my reports have been
> > > deployed, IE 7 shows a blank page with the message:
> > > "Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
> > > during the DNS lookup. Contact your system administrator if the problem is
> > > not found by retrying the URL.
> > > I have tried using another Browser (Firefox) on this computer and it
> > > accesses the page just fine. I have even went one step further by trying to
> > > access the http site
> > > from another computer (also using IE7) via an Intranet. It works fine.
> > > This is the only webpage that is not working.
> > > Where can I make changes? It is not asking me for a password. It is not
> > > even partially bringing up the webpage.
> > > I have tried clearing all history inside IE7. I have tried to check the
> > > settings in
> > > the IIS section. I have updated my IE7. I have even uninstalled IE7 and
> > > tried to use IE6 but to no avail. I am using XP Professional.
> > > I don't know where to look next! Is it a Reporting Services issue? IIS
> > > issue? IE7 issue?
> > > Any suggestions would be welcomed.
> > > Pat
> > This link might be helpful.
> >http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=842755&SiteID=1
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Cannot view actual report

Hi,

I am using the reportviewer control the following way

<%@. Page Language="C#" AutoEventWireup="true" CodeFile="RenderReport.aspx.cs" Inherits="pages_RenderReport" Title="View Report"%>

<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<html runat="server">

<head runat=server></head>

<body>

<form runat=server>

<table width="100%" cellpadding=0 cellspacing=0 border=0>

<tr>

<td valign="top" id="report" width="100%" style="height: 104%">

<rsweb:ReportViewer ID="reportViewer" runat="server" Width=100% SizeToReportContent=false BorderWidth="1pt" ExportContentDisposition="AlwaysInline" AsyncRendering="False" Height="600px" Font-Size=Small ShowParameterPrompts=true ShowPageNavigationControls=true ProcessingMode="Remote">

</rsweb:ReportViewer>

</td>

</tr>

</table>

</form>

</body>

</html>

I cannot see the report at all?..All i see is the parameters area.

thanks.

It doesn't appear that you specified a report to render. The Report Viewer control won't render anything unless it's given a report.

-Albert

|||

Actually i had set the report in the code. I should have included that code in this forum. I however figured out the problem.

Thanks.

Cannot view actual report

Hi,

I am using the reportviewer control the following way

<%@. Page Language="C#" AutoEventWireup="true" CodeFile="RenderReport.aspx.cs" Inherits="pages_RenderReport" Title="View Report"%>

<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<html runat="server">

<head runat=server></head>

<body>

<form runat=server>

<table width="100%" cellpadding=0 cellspacing=0 border=0>

<tr>

<td valign="top" id="report" width="100%" style="height: 104%">

<rsweb:ReportViewer ID="reportViewer" runat="server" Width=100% SizeToReportContent=false BorderWidth="1pt" ExportContentDisposition="AlwaysInline" AsyncRendering="False" Height="600px" Font-Size=Small ShowParameterPrompts=true ShowPageNavigationControls=true ProcessingMode="Remote">

</rsweb:ReportViewer>

</td>

</tr>

</table>

</form>

</body>

</html>

I cannot see the report at all?..All i see is the parameters area.

thanks.

It doesn't appear that you specified a report to render. The Report Viewer control won't render anything unless it's given a report.

-Albert

|||

Actually i had set the report in the code. I should have included that code in this forum. I however figured out the problem.

Thanks.

Cannot Summerize a formula

Hi

I have a report that has 2 levels of grouping
Group 1 - Date
Group 2 - Customer Ref
This shows for every month how many customers contacted me

I then insert a simple if then formula within the Group 2 line returning me back 1 or 0 if a condition is met.

The problem is, I cannot then sum all the 1's

I will be grateful for any helpInstead of using the formulas and trying to count them you could use a running total that is evaluated whenever the condition is met. In Crystal Reports (http://www.saveonsupport.com) this can be achieved using the formula button in the evaluate on section of the running total.|||Hi

r u sure that the 0 & 1 is in a numeric format, when it is in character format it will not allow to add,

type cast it using 'cDbl' and summerize

Cannot subscribe report

Has anybody experienced this strange problem? I can create a e-mail
subscription in Management Studio. However, when I am in web based
subscription, type in the entries and click "OK", the next screen asks me to
"specify options for report delivery" again. No matter what I choose ("Report
Server E-mail" or "Report Server File Share"), it prompt back to the same
screen.
Any tip or help is very much appreciated.Hello Jason,
I would like to know have you applied SP1 on your reporting services?
Also, if you created a subscription in the Management Studio and then try
to modify the subscription in the web site, do you still get this issue?
And if you tested on other client, does this issue still occur?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||yes, I did apply sp1. and yes, I get the same issue when I try to modify the
subscription. I tested on both my machine (xp) and the server itself, same
thing happens. Thank you for any troubleshooting clues.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> I would like to know have you applied SP1 on your reporting services?
> Also, if you created a subscription in the Management Studio and then try
> to modify the subscription in the web site, do you still get this issue?
> And if you tested on other client, does this issue still occur?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Jason,
Have you seen any error message in the Report Log?
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please check and let me know are there any related error in the log.
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.|||Thank you for the help. I checked the WebApp log, the following looks
suspicious:
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
No idea what does the above mean.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> 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.
>|||Actually, the report subscription is working and the email is delivered after
I set it up in Management Studio. My problem is I can not use Management
Studio to set up other reports which requires parameters. If I understand
right, those reports subscription has to be done through report server web
interface. That is why I am having the problem. Please help.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> 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.
>|||Hello Jason,
I would like to get all the Report Error log.
Also, please check your rsReportServer.config file and make sure the smtp
server name is correct.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you, my direct email address is
weilu@.ONLINE.microsoft.com ( Please remove ONLINE when you send the email
), you may send the file to me directly and I will keep it secure..
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Cannot start the Reporting Service

I am currently working on a windows 2003 server with SQL2000 (developers edition). My Sqlserver and Report Server are on two different machines.

This was working yesterday but frustratingly not this morning.

Everytime I try to start the Reporting Server service, it gives me the following message:

"The Report Server service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

Is there a way around this? - any help would be greatly appreciated .

Anyone?|||If you are still seeing this issue...I found a solution for a similiar error (a different service, but the same error). Had to clear out the Application log in Event Viewer. See if that helps.|||Possibly best not to delete the contents of the event logs, as this may provide a pointer towards solving your problem. Open the eventlogs, then start the service, find the error that is logged for it. If you post that here it may give more of an idea.
|||

I'm facing a very similar problem. I've installed, uninstalled and reinstalled SQL server 2005 Developer Edition twice now. In each case Report Server can't be started. I've looked in the logs and the pertinent errors seem to be the following:

ReportingServicesService!library!4!6/16/2006-15:28:33:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!6/16/2006-15:28:33:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'E1705\ASPNET' is not recognized.

In the other log file is the following error:

ReportingServicesService!library!8!6/16/2006-15:28:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info:

Looking at the time stamp, I believe the later is just a result of the UnknownUserNameException:

SQL Server works fine, I can work with the database in the Management Studio and access them through ASP.NET without a problem (or at least I could before I uninstalled a couple of times!!)

.Net framework 2.0 is installed. I have a Gig of RAM, plenty of hard disk and XP Prof Ed SP 2.

I'm at a total loss on how to get it to work on this machine. Any help would be greatly appreciated!!

Bob O'Dell

|||

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

|||

ASPNET user did appear as a user and I tried different permissions to no avail. What finally worked was to uninstall Report Services (actually I uninstalled ALL of SQL server) and then reinstalled the .NET framework. After that I reinstalled SQL Server and Report Services. Everything seemed to work after that. I'm not sure what was wrong, but I'm off and running now!

Thanks for the help

|||

James Wu - MSFT wrote:

The problem seems to be that the default ASP.NET user is not present. Are you able to find ASPNET user on your local machine E1705? Re-registering asp.net might help.

aspnet_regiis.exe -i -enable

This was the 'trick' I was looking for. Now I'm able to start the Reporting Service. Many thanks!!