Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







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.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
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
My Data-Driven Subscriptions(DDS) Don't Want To Work Although I Can View My Reports
 

Hi

I have been asked to move our entire system over from SQL2000 to SQL2005, i eventually got our database and Cubes over to 2005 and converted all my reports to 2005 and deployed them successfully on RS2005

All the subscriptions have been made and they seem to work when i click to view them. Although when i create a DDS for all my reports to run then they fail. Now i've got over 5000 reports to build and i'm definately not going to create each report manually. My SQL Reports huild successfully, it just seems to be the MDX Reports with a problem, i;ve checked my stored procs and they seem fine, i've even seen the [Clients].&[All.Clients] difference from SQL2005                                                                                                                     ---->&<------ that is not in SQL2000.

If someone has, or has had the same problem before would you please help me. Any advice or suggestions would be more than welcome.

 

Kind Regards

Eagle

View Replies !   View Related
Cannot View SSRS Reports On Internet In MOSS 2007
Hi All,
 
I am having multiple URL in multiple zones for my site.I am not able to view SSRS reports on Internet which is in Internet zone where as i can view the same reports on Intranet site having URL in default zone.
I m getting the following Error while accessing reports over internet:
 
" Unable to connect to the remote server.No connection to be made because target machine actively refused."
 
It would be great help if any one can solve this problem.
 
Thanks in Advance.
 

View Replies !   View Related
Cannot View Reports With Moss 2007 Installed On Same Site
 

hello when i try to view reports in reports manage i get the following error
 
The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found

Source Error:





The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

  <%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
   <system.web>
       <compilation debug="true"/>
   </system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:





[InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found]
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded() +212
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance() +17
Microsoft.Reporting.WebForms.LocalizationHelper.Microsoft.Reporting.WebForms.IReportViewerMessages.get_ProgressText() +42
Microsoft.Reporting.WebForms.WaitControl.CreateChildControls() +210
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +7248
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +213
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.pages_report_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64




Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

View Replies !   View Related
Icon/View Reports Not Working When Accessing Via URL \servernameReportServer?%reportname
 

The forward/back/firstpage/last page, Find, Next, Export, Show/Hide parameters, print icons all appear as dim outline of a square with a dot in the center.  The "View Report" button appears fine but the report does not render when user clicks the button.
 
The same reports renders correctly when deployed to a different reporting server. 
 
Any suggestions?

View Replies !   View Related
View Report From Report Viewer Control
I have created several reports using report builder. I can view these reports from the report server homepage but i can't view them from my windows forms app. The structure is such that my report url should be

 

http://localhost/reportserver/myFolder/myReport

 

however if i browse to my report in the report server home page the url looks more like

 

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fMYFOLDER%2fMYREPORT&rs:Command=Render

 

if i type the first url into a browser, I see a directory listing.

 

Setting the ReportPath property for my report viewer control to either

 

/myFolder/myReport

 

or

 

Pages/ReportViewer.aspx?%2fMYFOLDER%2fMYREPORT&rs:Command=Render

 

does not result in my report being displayed. Can anybody tell me what is wrong with my setup.

 

 

View Replies !   View Related
Can Not View The Report Embeded In Report Viewer
Hi,
 
I added a page to exsisting web site. Then I used report viewer to show a report. But when I try to view it in the browser, I get the following error message.
 
 
Server Error in '/Website' Application.


The type CustomReportServerConnection, APP_CODE does not implement IReportServerConnection or could not be found Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type CustomReportServerConnection, APP_CODE does not implement IReportServerConnection or could not be found

Source Error:





Line 272: <asp:View ID="vwWARRatingChangeReport" runat="server">
Line 273: <aspanel ID="pnlWARRatingChangeReport" runat="server" Width="683px">
Line 274: <rsweb:ReportViewer ID="rvWARRatingChageReport" runat="server" Font-Names="Verdana" Font-Size="8pt"
Line 275: Height="100%" ProcessingMode="Remote" Width="100%">
Line 276: <ServerReport ReportPath="/CRMReportsQA/ORA/WARRatingsChange" ReportServerUrl="http://wiismab00035038:8095/Reportserver" />


Source File: c:Dev EnvironmentWebsiteApplicationsORAPDCRD.aspx    Line: 274

Stack Trace:

 
But I created another website using visaul studio in my local machine and then used report viewer to disaply the same report. Its in server mode same as earlier. This one can be viewed without any trouble.
 
I'm not familiar with ASP.NET thing. Can anyone help me to resolve this one?
 
Thanks

View Replies !   View Related
&&<Default Web Site&&>/Reports Produces &&"The Report Server Is Not Responding...&&"
 
Situation:
 
Report Server 2005
 
Formerly working fine.
 
Reports themselves can be accessed just fine from the /ReportServer site, but the Report design web interface, under /Reports will not launch.   The error is:
 










The report server is not responding. Verify that the report server is running and can be accessed from this computer.
 
 
Here is the ReportServerWebApp log:
 
 
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Pacific Standard Time</TimeZone>
  <Path>c:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__01_15_2008_11_39_01.log</Path>
  <SystemName>EKENSQLDEV5</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
  <OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing ReportBuilderTrustLevel to '0'  as specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing ProcessRecycleOptions to default value of '0'  because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing WatsonFlags to default value of '1064'  because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing SecureConnectionLevel to default value of '1'  because it was not specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!1!1/15/2008-11:39:02:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False'  because it was not specified in Configuration file.
w3wp!ui!1!1/15/2008-11:39:09:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!1!1/15/2008-11:39:09:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!1/15/2008-11:39:10:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

View Replies !   View Related
Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options
Hello SQL Server Experts, Data Analysts, and Report Writers et al:

re: Reporting Options with SQL Server

I wanted to propose an offshoot to the pryor thread:

Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?

I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?

Thank you to all, and I hope this is a beneficial discussion to others.

Hal1490



Hal9000

View Replies !   View Related
Report Viewer Control (web) - Enter Button Doesn't Cause &&"view Report&&" Event If Only One Parameter
Having a weird issue. 

I'm using Report Viewer control in ASP app
Accessing a server report
If report has more than one parameter, hitting "Enter" in the last parameter causes the report to get generated.
If the report has ONLY ONE parameter, hitting "Enter" does NOT generate the report....You have to click the "View Report" button.

Not sure if this is a bug.

 

I have all the latest SPs, etc. on my server, development machine, etc.  I'm using IE7 if that makes any difference.

View Replies !   View Related
Remove All Reports ( Not Data Sources) From Reports Server
Hi does anyone know how to do the above with out going through reportserver url?

Preferably by using a cmd tool ? such rs.exe

or through the backend in the reportserver DB?

Thanks

Dave

 

View Replies !   View Related
Initial Load Of Report. Wait For And Trap &&"View Report&&" Button
I have some date criterias on my report that default and so I would like for the report not to display until the user clicks on the "view report" button.

Also, I would like to trap that button to send my own internal parameters to the report. How and where would I do that.

I'm running the report through report viewer and I have a subroutine that would refresh the report with my desired internal parameters. I just need to hook it up.

Thanks for any help or information.

View Replies !   View Related
Double Click On The &&"View Report&&" Button To Get The Report To Render.
I've got a SQL Reporting Server 2000 SP2 report that takes 3 parameters. FromDT, ToDT, and LocationCD. The first two parameters are free form text fields that expect a date. The last one is a drop down box. For some reason, when I'm viewing the report through the standard reports folder on the report server I have to click the "View Report" button two times to get the report to render. Clicking it just once, doesn't seem to do anything. The report is a line graph.
 
There are default values in the FromDT and ToDT parameter fields.
 
Anyone have any ideas what would be causing the need for the second click?

View Replies !   View Related
Reports Sub Report Parameters
I get this error when a report renders that has a sub report on it. An error occurred while executing the subreport €˜subreport1€™: One or more parameters required to run the report have not been specified. It renders fine when the report itself is ran, but when trying to render it on another report it states the params are missing. How can I add the parameters from. Both of these reports have their own datasources, and they are cubes. Is there a way to do this, I tried setting theparameters by going to the sub reports (right click) properties> parameters> ... but the parameters this report needs are not there. Any help would be greatly appreciated.

View Replies !   View Related
Report Builder-Ad Hoc Reports
 
Here is one scenario. There is Department X which has subdepartments A,B,C,D. A has 5 members and B has some 7 products, C 5 members and D has some 12 members. My problem is I need create a Report model where is if we select X
all the list of subdepartments and their members should be displayed. I.e if we select X then
A
1

2
3

4
5
B
1
2
3
4
5
C and so on..........every thing should be displayed that are under department, i.e subdepartments under that department and the members under each subdepartment of that Department.
 
The problem here is all those departments and subdepartments are in same table which has columns like,
"DeptId" and "Dept Reporting to" and "EmplID.
When we select "Dept Reporting to" = X, we need to get the result as I specified above
 
Can anyone please help me out to create a Report Model to generate ad hoc reports

View Replies !   View Related
Export All Reports Into One Report
Hi, we have a web page that renders multiple reports on it, each report coming from a rsweb:ReportViewer control. Is there a way to export all those reports into one report?

View Replies !   View Related
Report On Users Accessing Reports
All,

I would like a report to display the number of users and the reports accessed for a certain duration of time[being able to go back and check for previous years as well].

I read on the msdn that 60 days worth of report log is kept,and the rest gets wipped off.Any suggestions on how I would be able to get user access list for the past year as well.

View Replies !   View Related
Open Reports With Report Builder
Hi!

We have a "folder hiriarchy" in reporting services with permission for different users to only create reports in their own folder. However, it would be nice if they (in report builder) could open eachothers reports, modify them and then save them in theri own folder. In this case, if they find a useful report that someone else has created, they could just make their own small modifications and save it in their own folder.

The problem is that I cant't seem to find a securitysetting that allow this. Either they can create/modify/delete the reports in a "folder" or they can't even open them in report builder...

Is there a solution to my problem?

regards Andreas

View Replies !   View Related
Reports Sorting On Report Manager
Hi, there,
 
The default reports sorting is based on the report name. Is it possible to sort reports according to the report description?
 
Thank you.
 
Regards,
Yong Hwee

View Replies !   View Related
Using Report Viewer For Viewing AS Reports
We currently use the Report Viewer inside our application in local mode to successfully view and render all sorts of RDL reports including those with paramters and subreports. We are now trying to use the Report Viewer inside our application to view Analysis Services reports containing MDX and extended field properties. We are having issues in that there is no way to indicate to the Report Viewer which DPE to use. As such when dealing with extended field properties such as UniqueName, LevelNumber and BackgroundColor we are unable to get valid info displayed. It appears the viewer does not know how to handle it but instead returns nothing. In addition without being able to call back to a DPE the Aggregate function "Aggregate" is pretty much useless.
 
So questions:
1) When using Report Viewer in Local mode is it possible to indicate to the Viewer a DPE to callback to?
2) Does the Report Viewer ever call back for anything other than the documented public subreport event?
3) Is there any way which I am not seeing to make this work?

4) To accomplish what I am trying to do am I going to be forced to write my own viewer?
 

View Replies !   View Related
Can A Report Model Have Reports Included In It?
Hi All

I have created reports in 'Projects'. What I would like to know is that if can transfer these reports into a report model?

As per my knowledge, a report model contains datasources, datasource views, report models itself and doesn't allow to transfer reports. Please , let me know if my understanding is correct?

Cheers

Preps.

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved