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.
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':
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.
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
I have my reporting server set up at the following location on my dev server
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.
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.
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?
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?
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?
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.
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.
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 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
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.
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.
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.
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
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 .
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.
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?
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()
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
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.
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...
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..
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.