Not Able To View Reports On Report Server

 

I'm able to preview my report in Visual Studio and once I'm deploying it, it is getting deployed also on the Local server but when I'm using browser and trying to view the report, it is showing me following error message:
 

Unable to connect to the remote server


The attempted operation is not supported for the type of object referenced







 




 



I'm using Win XP Pro with a developer edition of Sql Server 2005 and administrator of computer. Not able to understand why in browser I'm not able to view reports.



 



Kindly help.



ADVERTISEMENT

Restrict Users To View Reports And Also Folders In Report Manager

 

Hi,
 
I would like to restrict users to allow to view related reports only...
like i have 2 users..with 4 reports
 
1 user can see only two reports
2 user can see only another two reports
 
how can i do this by SSRS???
Can i do by using Configure item-level role definitions in seetings link..
or is thr any another way to do this?
 
Pls reply back
 
Regards,
Maruthi..

 
 

View Replies View Related

Unable To View Reports On Report Viewer After Publishing ASP.NET Web Site

Hi,
 
I have couple of Web pages linking to my RDLs using report viewer Web controls. I have no problem running and viewing them in VS2005 debug mode and report manager until I published them to local folder and set the local folder as an application on my IIS7. When running the published version of the Web pages, all my calendar image buttons (which happen to be part of the report parameter fields) turned to red 'X':
 
http://dyzimw.bay.livefilestore.com/y1pwxE9mLpX4JV7e438WA4DeGwu6YHQOkRoC20r_EhQ5uoXkt15dqs99LmiDSTauSvUCno9HnOwYKR34rPpFYA_lQ/ssrs.jpg
 
When clicking the View Report button, the animated progress icon not appearing at all. Before the occurance of this problem, I did face the problem whereby the 'NT AUTHORITYNETWORK SERVICE' does not have enough permission to view the report. After referring to some threads, I finally be able to get rid of this error by assigning Browser role to 'NT AUTHORITYNETWORK SERVICE' from the report manager. I wonder could this solution be related to the problem that I'm facing now. Any help would be appreciated.
 
Thank you.
 
Regards,
Antonio

View Replies View Related

URGENT: REPORTS Not Working In SQL Report Srvr && Crystal Reports (moved Server)

 
Reports not working at all:
Need to move full ASp.Net application(VS.Net 2003) /SQL Server 2000 DB to another machine. The Web application & its SQL Database is successfully moved and functioning but am unable to access any of the reports from within it. The
 
reports are in: A) SQL server report server & B) Crystal reports
 
For A)-SQL SRVR-RPT SRVR: Installed SQL Server2005  Express version- with reporting srvr (advance mgt). The report server is working well- from IIS i can open both http://..reports and http://...reportserver links without error.
But when i click on a link in the ASP.Net application it gives error: /HRNE_REPORTS/rpt_employees does not exist( rsitemnotfound) .
1.In http://..reports configration I have made a folder HRNET_REPORTS. But how do i put the individual reports? There is no .RDL file in the application folder only .aspx files for the reports exist.
 
2.Do i need to restore the two reporting server databases from the old machine to the new one and have this new 2005 reporting server use these 2 databases instead? If YES  - then i hope sql express' reporting server will be able to point to the OLD (sql 2000) database (restored with replace option)??
 
For B)- CRYSTAL REPORTS: Have not installed anything special on the new machine.
The reports give some key problem (Crystal decisions...key..)- I can tell u later the exact error.
Since i dont have VS.Net and crystal reports 9 softwares but i think i can have 'Busines Objects XI software' - Will installing the latest 'Business Objects- Crystal reports' solve this??NEW MACHINE: windows XP-professional(so could'nt install sql 2000).; SQL express 2005

View Replies View Related

Cannot View Reports On My Dev Server

Hi all,

I have my reporting server set up at the following location on my dev server

 

http://192.168.2.10/ReportingServer3

 

it all works well.  I have published 3 reports to it and the associated data sets.

Problem is when i go to that url i cannot see anything.  I get a "directory listing denied" or if i allow directory browsing i see just whats in the folder.  But not the reports or my "report folder" specified in VS 2003 properties.

 

However if i use "anypage.aspx" after ReportingServer3 then all of a sudden i only see the "report folders" and the reports.  However the reports NEVER render, they just always say "Generating Report" with that  animated .gif.  And in Firefox it doesn't even do that much, it just goes back to the root folder.

 

This also happens when trying to view it through ReportManager web interface.

 

As i said, the whole project deploys from VS 2003 fine and i can preview the reports in vs 2003.  But it seems the web interface for the reporting server is not working correctly.   Whats more, i cannot find the .rdl files on the server (where i deploy to) anywhere.  Do these files ACTUALLY get sent to the server when you deploy from VS 2003? Where would they go? i have no folder structure created in my reportingserver directories.

 

TIA,

mcm

View Replies View Related

Vista Browser Error On Http://localhost/Reports - &&"The Report Server Is Not Responding. Verify That The Report Server...&&"

Hi -

  I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports". 

  I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.

 

Thanks,

Mike

View Replies View Related

Report Server Reports Authorization

I am in the planning phase of building a Form Authenication Report Server project. The database contains the Role information for each report and for each user. The objective is to authenicate and authorize user so that only the authorized reports are available for the current user to view.

Base on my research these are my plans.

1. Deploy Reports onto the Report Server
2. Put Reports in folders to group different types of report (I am not sure is it possible to only the display authorized reports for the current user)
3. Design the custom Security extension to authenicate and authorize using the database


1. Is it possible to only display authorized reports for the current user to view by doing custom security extension?

View Replies View Related

Reports / Report Server Default Settings

Hi,

i have installed SQL RS and have a directory listing in the Reports directory via my browser. CAn anyone tell me which file / setting needs tweaking please?

thanks

View Replies View Related

Moving Report Builder Reports To New Server

I have a development server setup with Report Builder that our users have been testing out.  They have a number of reports that they have created on this dev server.

 

We now have our live environment all setup and I'd like to move their Report Builder reports to the new server for them so they don't have to recreate them.

 

Is this possible?  If so, how?

 

Thanks.

View Replies View Related

Use Report Server Project To Connect To Report Model Project Data Source View?

Hello,
I've created a Report Model Project that can be used by Report Builder to generate ad-hoc reports.  I'm trying to create a connection string in my Report Server Project that points to the Report Model Project data source view. 
 
All I can do is create a regular datasource, which bypasses the metadata contained in the Data Source View.
 
Basically I want my Report Server Project and my Report Builder reports to leverage the same metadata.  Is this possible?  If so how do I get the connection string?
 
Thanks!!
-Matt

View Replies View Related

SQL Server Report Server Runningjob Table --reports Failed To Run Because Of The Following Issue..

 

Hello,
 
I am getting below error, need information on below error to resolve the issue, I am unable to find article on this if this has been fixed in SP2.
 
e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_RunningJobs'. Cannot insert duplicate key in object 'dbo.RunningJobs'.
The statement has been terminated.
 
Can you please update what is the impact if such errors happened in the error log?
Is it resolvable?
Is there any Orphan running job causing this problem?
How we can ensure orphan job will not be running?
 
Thank you,
Mogalappa Adaki
 

View Replies View Related

VS2003 - Deploying Reports - No Report Server Was Found At

Hi all,

We have many domain users who develop/deploy reports using VS2003 to our remote server at https://server/reportserver with no problems at all.

A single workstation on the domain that been used to develop reports cannot deploy though. The message looks fairly simple to diagnose "no report server was found at https://server/reportserver". I have checked dns and the servername resolves no problem. I have manaully edited and added the server to the hosts file also. I have updated and service packed all VS elements (VS2003 7.1.6030).

The server is contactable in all ways on this workstation, all ip/dns settings are the same as other domain workstations.

Can anyone point me in the direction of log files to look at, or if i am missing any basic options in VS. I have checked all deployment settings from other workstations.

 

Many Thanks!

Alex

View Replies View Related

Query Report Server Database To Determine Permissions For Reports

Anyone know of a way to do this? I'm looking over the tables and it's not obvious to me how to list the AD groups I've authorized for reporting services. And then to list per group which reports they have access to.

View Replies View Related

Reports Are When Printed SQL Server Report Is Printing Extra Pages

 

Hi ,
 
I have developed some report in Sql Server Reporting services my Page orientation is portrait that is report height and width  are 8.5 and 11 respectively and margins are set to 0.3 in when it is printed the pages are printed more that actually viewed Pages.
 
I need help from someone.
 
Thanks,
 
Nikhil
response2nikhil@hotmail.com  

View Replies View Related

Why Did MS Give Access To Reports Thru Both Reporting Manager And Report Server?

what is MS's strategy for having two off the shelf ways of getting at reports?  In a typical company, is the average non administrator type user getting at his reports via one, the other, both? 

View Replies View Related

Unable To Display Server Reports In Report Viewer Control

 
Hi all,
 
I have been using the reportviewer control to display my ssrs reports. However, i'm facing issues in displaying Server reports in the control. The  following error show up whenevr i click on View Report.

Execution 'aaxe3ke5k34l5355qbup0rvo' cannot be found
 
 

Please help if anyone has come across something similar

View Replies View Related

Unable To View Field On Report Server

Hello All,

can anyone tell me why I am not able to view a field in the report server whereas it works fine in the design preview of BI studio. This field's visibility is dependent on a boolean parameter. When it's set to yes, the field appears in the report else not. In the report server I dont see this field at all.

 

Thanks in advance!


Rashi

View Replies View Related

Can Not View The Report From SQL Server Management Studio

After install SQL Server 2005, then run it sampel for report. Using VS2005 to deploy the report to report server.
The report can be previewed in VS2005.

After deploying, open SQL Server Management Studio.
1. Add local user  Administrator to database AdventureWorks
2. Pick up one sample report Company Sales from AdventureWorks(Home-->AdventureWorks-->Company Sales), then go to
DataSource-->AdventureWorks, the setting for this datasource  as below:

Data Source=localhost;Initial Catalog=AdventureWorks;Integrated Security=True

Select "Credentials stored securely on the report server" with following setting:
  Login name: Administrator
  Password: (right password here)

Checked for "Use as Windows credentials when connectiing to the data source"

3. Then right on ths report (Company Sales), from popup menu-->View Report
Then in browser, it ask for user name and password, input as:
User name: Administrator
Password: (right password here)

Get infomation as:
You are not authorized to view this page

The URL is: http://localhost/reportserver/?/AdventureWorks%20Sample%20Reports/Company%20Sales&rs:Command=Render

Then try a different setting, use different user account in Database, same error message.

What's wrong with it? How to solve this issue?

View Replies View Related

Setting Reports Parameters In Querystring For Team Foundation Server (TFS)report

I would like to set the parameters of the TFS report Remaining Work from the querystring. The syntax seems to be http://server/ReportServer/Pages/ReportViewer.aspx?/ProjectName/Remaining+Work&WorkItemTypeParam=xxx where xxx should be the value to preset the Work item type dropdown.

I just can't seem to get the parameter right. What should the url look like if I want to filter the report to show only Tasks and Bugs?

The report also has filter Area, the name of the parameter is AreaParam. Where do I find the values for the areas? If I try http://finnctfsdb/ReportServer/Pages/ReportViewer.aspx?/ProjectName/Remaining+Work&AreaParam=ProjectName/Area1
or similar the area dropdown is empty, i.e. it has connected the querystring parameter and the field but the value is wrong.

If have also posted this to MSDN Forums » Visual Studio Team System » Team Foundation Server - Reporting & Warehouse.


Regards,

Mathias

View Replies View Related

I Can't View My Reports!

I can browse my subfolders containing reports in Home, but Internet Explorer displays error message when I press a report.

I can use Properties, History and the other tabs, but when I press "View" tab I can only see error message.

I have to use external IP address (217.x.x.x/Reports) so I tried to set this IP in ReportManagerRSWebAppConfig file:

<UI> 
  <ReportServerUrl>http://217.x.x.x/ReportServer</ReportServerUrl>
</UI>

But when I try to use local IP address (10.x.x.x/Reports) in my local net, I can't connect to the report server.

When I change this to <ReportServerUrl>http://10.x.x.x/ReportServer</ReportServerUrl>

I can't view my reports from external host using external IP (217.x.x.x/Reports) because local IP is used when I press "View" tab.

I don't know if there are other files that should be changed? Can somebody tell me how to solve this problem?

Best regards,

Chris

View Replies View Related

Viewing Ssrs Reports In Report Viewer Web Part(report Manager Url?)

i m using SQL Server 2005 Reporting services, sharepoint 2007, SQL Server SP2 and Sharepoint technologies ADD-IN tool.

i hav configured the reporting services to sharepoint integration mode. Also i hav deployed my SSRS reports to sharepoint report library.

now i want to show these reports in the report viewer and report explorer web parts. These web parts are successfully deployed.

Can someone tell me what should be the report manager url and start path in the properties of these web parts?

View Replies View Related

A New User Cannot View Reports

 

Hi,
i have a prob;lem while using report manager.when i login As "administrator" to the report manager i can see all the folders and i can check also reports. when i create new users with some role and i login as new user i can see the specified folder and report but when i click to see the report this message appear:
" Your browser does not support scripts or has been configured not to allow scripts".
Note that these same reports i can check them when i login as administrator
 
i am using sql server 2005
 
please it's important to resolve this problem as soos as possible
thx
labiba

View Replies View Related

SQL Server Stored Procedure Resultset Unable To View In Crystal Report 5.0

hi
I am trying to get the resultset of a table in StoredProcedure
in Cyrstal Report 5.0 , MS Sql Server 6.5 is the Backend
THere is a main Stored Procedure SP1 which is populatingthe
Main Table say T1 . This SP1 is calling another SP say SP2
which is populating table T2 . A cursor is then set on table T2and
based on certain conditions the main table T1 is populated .
Our problem is that this entire thing goes fine at the ISQL
Level . But when the same SP SP1 is getting called by CrystalReport
then the data inserted in SP SP2 is not visible at all . Itseems that
somehow the data is geting lost thro ODBC etc.
We tried all combinations of T1 and T2 making thempermanent and
temporary . But each way there are some or the other problem .Many
times we are getting `Cursor already exists ` with temp. tables. or
table T2 is already existing .

PLease reply soon ,

TIA
Pankaj

View Replies View Related

View Reports Using C# In VS 2008 Beta 2

 
I need to connect to a reporting service and to see all avaliable reports. This code is from VS 2005 (it is working), but i needed this in VS 2008.

try

{

comboBox1.Items.Clear();

ReportingService _rs = new ReportingService();

_rs.Url = textBox1.Text + "/ReportService.asmx";

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

CatalogItem[] items;

items = _rs.ListChildren("/", true);

foreach (CatalogItem item in items)


if (item.Type == ItemTypeEnum.Report)


comboBox1.Items.Add(new ReportItem(item.Name, item.Path));

comboBox1.DisplayMember = "Name";

comboBox1.ValueMember = "Path";

MessageBox.Show("Reports updated.");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

 
But in VS 2008 ReportingService class is not defined (or i can't find it), so i changed the code:
 

try

{

comboBox1.Items.Clear();

ReportingServiceSoapClient _rs = new ReportingServiceSoapClient();

_rs.Endpoint.Address = new System.ServiceModel.EndpointAddress(textBox1.Text + "/ReportService.asmx");

_rs.ClientCredentials.Windows.ClientCredential = new System.Net.NetworkCredential(username, password, doamin);

CatalogItem[] items;

ServerInfoHeader header = _rs.ListChildren("/", true, out items);

foreach (CatalogItem item in items)


if (item.Type == ItemTypeEnum.Report)


comboBox1.Items.Add(new ReportItem(item.Name, item.Path));

comboBox1.DisplayMember = "Name";

comboBox1.ValueMember = "Path";

MessageBox.Show("Reports updated.");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}
 
And I always get the following exception:"The HTTP request is unautorized with client autentication scheme 'Anonymus'. The autentication header received from server was ('Negotiate', NTLM).".

 
The following code also does the same:
 


try

{

comboBox1.Items.Clear();

ReportingServiceSoap s = new ReportingServiceSoapClient("ReportingServiceSoap1", textBox1.Text + "/ReportService.asmx");



ListChildrenResponse response = s.ListChildren(new ListChildrenRequest("/", true));



CatalogItem[] items;

items = response.CatalogItems;

foreach (CatalogItem item in items)


if (item.Type == ItemTypeEnum.Report)


comboBox1.Items.Add(new ReportItem(item.Name, item.Path));
comboBox1.DisplayMember = "Name";
comboBox1.ValueMember = "Path";
MessageBox.Show("Reports updated.");
}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}
 
I have no idea what to do. Maybe something is wrong with reporting service configuration? Or with IIS? But still, everything is working in VS 2005.

View Replies View Related

Users Cannot View Reports That I (=creator) Can

Hello colleagues,

I am trying to create some reports in VS.NET for our Microsoft CRM3.0.

I am using a SQL query like this:

SELECT  CRMAF_Account.Name, CRMAF_Account.primarycontactidName, CRMAF_Account.address1_line1, CRMAF_Account.address1_line2, CRMAF_Account.address1_city, ActivityPointer.scheduledstart, ActivityPointer.subject, ActivityPointer.description
FROM ActivityPointer, FilteredAccount CRMAF_Account INNER JOIN FilteredSystemUser FSU ON CRMAF_Account.ownerid = FSU.systemuserid
WHERE ActivityPointer.regardingobjectid = CRMAF_Account.accountID AND FSU.Domainname = SYSTEM_USER
ORDER BY Datum DESC

When I run this query, I get the desired result (I am the database dbo), but when any user tries doing the same, they get an error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Query execution failed for data set '[DatabaseName]'. (rsErrorExecutingCommand) Get Online Help

SELECT permission denied on object 'ActivityPointer', database '[DatabaseName]', owner 'dbo'.

I desperately need to know which user rights are missing and where are they missing - I do not suppose that the rights are expected to be assigned directly to the database tables

Any quick help would be highly appreciated. I would also appreciate any articles with examples how to use parameters, filters and subreports.

Thank you very much.

Marek Hlavac.

 

View Replies View Related

Permission To View The Posted Reports

Hi,
This is regarding the SQL 2005 Report Manager (http://localhost/Reports) page. I have posted the reports, the reports run fine, buttons like new folder, new data source, etc... are visible (lets call this machine as A). The problem is when my machine is accessed from a nearby computer on the same network as http://machineA/Reports, the Report manager Home page appears with limited or no buttons. The reports are also not visible in the browser of machine B. How do I make the reports visible to users (grant permission) for them to run and view those reports?
 
In a nutshell, how the posted reports be accessed by users?
 
Thanks,
Raj

View Replies View Related

SSRS : User Unable To View Any Reports

Hi,

I have couple of reports deployed on my dev server and my User is
unable to see any of those reports unless he is an ADMIN on the box.


I have added the user to ReportManager and ReportServer,
also added him to the Content Manager role in the concerned folder.
But still all he can see is HOME folder on the web page.


How do I solve this....

View Replies View Related

Cannot View Reports After Upgrading To SSRS 2005

Hello,
 
We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.
 
After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)
 
We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.
 
When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:
















An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
 
When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.
 
aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()
 
We welcome any suggestions.
 
 

View Replies View Related

Externally Accessing Localmachine To View Reports

How is it possible for others to browse to my localmachine and view the reports?
They tried browsing to http://machinename/reports
and http://10.1.3.123/reports

But the message the users get is: You are not authorized to view this page.

Then In my localmachine, I changed the IIS setting for the Reports and ReportServer to allow anonymous access. Then the users were able to see the Home page of the reports but not the reports themselves to click on for viewing. Any thoughts please?
Thanks

View Replies View Related

Visual Studio Report View Establish Report Path

I am having a hard time finding the report path for the web report Viewer in visual studio 2005.  I have tried entering the absoute path to the folder containing the reports.  this gave the error that the path is invalid. I have also tried reletive paths using / and // in the front of the name for each report. these all fail.  could someone please assist with finding the path to the reports?  the reports reside on another server away from the one being used for development of the web site.
 
thanks
 
Kof

View Replies View Related

By Default ALL Should Be Selected But On Clicking VIEW REPORT Only The Report Should Be Shown

 

Hi..
 
Iam using MATRIX format and i have 12 parameters with multiselection....now my problem is its very difficult to select each and every parameter every time..so i need to show all the parameters as DEFAULT ALL selected ..and at the same time i dont want to show the report when i click on preview....simply to say by default ALL should be selected but on clicking VIEW REPORT only the report should be shown...
 
Help me pls...
 
Roopesh Babu V
 
 

View Replies View Related

Printing Remote Ssrs Report From Report View Does Not Work

Hi,
 
It appears to work fine on my end however on my clients end, whenever they try to print a report that displays perfectly within the report viewer to their printer by selecting the printer button in the report it never ends up printing.., however if they go into printer setup and change the page range to print from all pages to just maybe one page and then select the print button it seems to print fine..
 
The printer seems to receive the information as the light flashes but no page kick out when all pages is selected to print..
 
Any help would be greatly appreciated..
 

View Replies View Related

How Do You Allow Users To View Reports Without Having To Enter User/password?

Ideally, I'd like to have the reports use windows authentication, ie grab current user/password so long as user does not have to enter it manually.  If that is not possible, then how do I make it so user does not have to enter this info manually?  My theory is that I have IIS set up incorrectly for doing this, but I'm not familiar enough with either reporting services or IIS to find out.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved