I have a masterpage that has no doctype, because I want to have a table with some fixed height TDs and some variable height TDs (this kind of table only seems to be possible in quirks mode, with no doctype). My problem is the SSRS web part, it has the web part title, but the actual report is not there! as soon as i put in the doctype, it renders normally.
Is there any way to have a reporting services web part render a report without a doctype?
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.
we have Reporting services and Office Sharepoint on the same server, but the reporting services website is on default website and won't start because MOSS is already using the port. can i just change SSRS website port ?
Is anyone attempting or has anyone successfully deployed MOSS2007 with a SQL 2005 Database Mirror on the backend? We are doing it in our lab with the automatic failover (principal, mirror & witness) and the SQL portion works great. The only issue is we have is that we have to manually switch MOSS over (via Sharepoint 3.0 Central Admin or stsadm) to the new content database on the other server. Thank you
We have reviewed the White Paper that Microsoft offered with no help to our issue.
I wonder if anyone can help me save the few remaining hairs on my head? I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any. I have the Reporting Services database set up to use Windows credentials and my Domain adminstrator account so I presume that this is user that I should be providing when prompted when deploying.
We are reporting from a custom list in MOSS 2007 using SSRS. When we try to report on a set of data from the list we receive 1;# in front of the returned data in SQL. How do i get rid of this or stop it from showing?
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:
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:
I am experiencing a problem integrating Reporting Services in MOSS 2007.
I tell you:
When i am in Reporting Services -> Aplications Administration, i click to set the default server settings and this error appears (it's in spanish, i try to translate below)
Error inesperado durante la conexión al servidor de informes. Compruebe que el servidor de informes está disponible y configurado para el modo integrado de SharePoint. --> El servidor no puede procesar la solicitud. ---> El cliente encontró el tipo de contenido de respuesta 'text/html; charset=utf-8', pero se esperaba 'text/xml'. Error de la solicitud con el mensaje de error:
Unexpected error while conecting to the report server. Check that the server is online and configured for the integrated Sharepoint mode. --> Server can precess the request ---> The client found the content response type 'text/html; charset=utf-8', but expected 'text/xml'.
I have watched into the report server, and it appears as integrated in Sharepoint.
If someone knows how to fix this, it would be very helpful.
I have just installed RS and SP2 on a server running a MOSS 2007 (with SSL using an internal certificate) and configured RS to work on Sharepoint Integrated Mode. Then I went to Sharepoint to configure RS options, but when I tried to set up the Set Servers Defaults I receive the following error:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure.
Also, when I try to deploy a report from SQL BI Development Studio to Sharepoint, I receive the error:
A connection could not be made to the report server https://myserver.mycompany.com.br/Reports/Site. (Microsoft Report Designer)
Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure. (System.Web.Services)
I have created a web part in ASP.Net. this web part is extracting data from the sql server database and displaying it on the web part page. This web part is working fine with asp.net application, but when i deploy it with MOSS. it is reaising security exception error like.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I have made the entry under the safe control list of web.config file. but still i am getting error any suggestion wud be highly appreciable..
We're currently having a great deal of difficulty getting our MOSS/SSRS integration configured. In short, we're getting "A connection to the computer cannot be established." message in the Grant Database Access page of the Reporting Services Integration settings.
A few more points:
We have two servers:
Server A: Win2K3 EE SP2, MOSS 2007, SSRS Integration Components
Server B: Win2K3 EE SP2, SQL Server 2005 SP2, MOSS database, SSRS, WSS 3.0, SSRS Integration Components A user in IE on Server A can successfully browse to the ReportServer virtual directory on Server B.
Another "test" MOSS server has been configured separately and successfully against Server B, so it seems like there's something amiss with Server A. The report server configuation tool shows all green. There are no entries in the App or System log that appear related to this issue. We've looked at KB's 871179 and 896861; no luck there.
We've tried both Windows Authentication and Trusted Connection with a number of different accounts, including a domain admin. No luck.
The error is really irritating, considering it gives no additional information, logging, or context.
Like many others, I am have trouble getting this to work, and none of the solutions I have found on the inter-tubes seems to work for me:
"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 401: Unauthorized."
The Setup:
MOSS/SSRS (Integration Mode) running on a server farm on a single server: myserver.mydomain.org
Service Account for all Services: mydomainmyaccount (trusted for delegation, member of IIS_WPG) myserver trusted for delegation SSAS running under Local System on ssas.mydomain.org.
SETSPN -L mydomainmyaccount results:
HTTP/myserver.mydomain.org
HTTP/myserver
MOSS Authentication Settings
Authentication Type = Windows Default Authentication Provider = Negotiate (Kerberos) Anonymous access not enabled
IIS Settings
SSRS on Default Web Site: Port 8080
Application Pool Identity mydomainmyaccount
NTAuthenticationProviders="Negotiate,NTLM"
Security: Windows Authentication
MOSS on Sharepoint-80 Site: Port 80
Application Pool Identity mydomainmyaccount NTAuthenticationProviders="Negotiate,NTLM" Security: Basic Authentication except _vti_bin/ReportServer is Windows Authentication The idea is to use kerberos to pass credentials from SSRS reports running on myserver.mydomain.org to SSAS on ssas.mydomain.org.
does anyone know, when will the functionality of linked reports, my reports, data-driven subscriptions in MOSS integrated mode be enabled? Now it is according to Microsoft not supported. Will this be supported in the future ?Thanks.
I have configured Reporting services to use MOSS integrated mode. I have two servers, one for MOSS and the other for SQL database and reporting server.
Since I am using NTLM for IIS authentication, I can only use "Trusted Account" for Reporting Service Integration.
Then I created a report in SQL Server BI development studio and deployed to a MOSS document library. The deployment was successful. However, when I tried to open the report, I got the following error message:
An error has occurred during report processing. This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode.
I have tried to switch to "Windows Authentication" for Reporting Service Integration, but this will give error for "Set Server Defaults" screen. Also the deployment from BI studio to MOSS will fail with authentication error. So I think I have to stay with "Trusted Account" option there.
What should I do to make the report accessible while using "Trusted Account"? Is there any configuration which has to be done for this purpose? Any input is appreciated.
I have a report where I use Globals!ReportName in the header of the report for the report title. In Development and on SSRS stand alone the value for Globals!ReportName is in mixed case and the file extension is omitted. When the report is published to a MOSS server integrated with SSRS the value for Globals!ReportName is all in lower case and the file extension is included.
Is there any reason for this change in behavior and is there a way I can put back the mixed case and omit the file extension?
I have a linked server in SQL 2007 form SQL to DB2.(IBM)
If I write a distributed query from SQL to DB2 I get mt data returned. ie: select * from openquery(Movex_Extranet,'Select * From mvxadta.ooline')
If I write a Query from SQL to DB2 using the 4-part naming convention linkserver.catalog.schema.object then I also get my data returned.
ie: select * from MOVEX_EXTRANET.RCHASE5C.MVXADTA.OOLINE
My problem is with the Query Designer in SQL2007.
When I right click the first lot of code and select "Design query in editor" The Designer GUI opens up and displays my table in graphical form with all columns selected - Great.
But When I repeat this for the code that uses the 4 part naming The Designer opens up and displays the table but with no columns viewable or available for me to select ??
Anyone know what might be causing this to happen. Is it a bug in SQL 2007 ??
I have tried linking the server using 2 types of providers ( One from Microsoft & one from IBM) but each time I still cannot see or choose columns in the designer using the 4part naming convention.
The 2 providers I tried where. Microsoft OLE DB for ODBC Drivers. IBM DB2 UDB for Iseries IBMDA400 OLE DB Provider
Any help greatly appretiated as I would really love to use the designer using 4part naming convention.
Apparently if you read this the it should work ? http://msdn2.microsoft.com/en-us/library/aa225987(SQL.80).aspx#dvmscworkingwithtablesfromdifferentdatasources
I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.
BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Home Edition (Build 6000) Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : SQL Server Database Services Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : SQL Server Database Services Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. Error Number : 29513 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I'm configuring now Reporting Services on SQL Server 2005 in Office Sharepoint Server 2007 integration mode. In the beginning of the process, I had already installed SQL Server 2005 with RS and Office SPS 2007. I used following guides to make further steps: How to Configure Reporting Services to Use a Non-Default Web Site (Reporting Services Configuration)
How to Configure Service Accounts (Reporting Services Configuration)
How to Configure SharePoint Integration on a Standalone Server How to Configure the Report Server Integration Feature in SharePoint Central Administration
Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services
So I installed RS add-in for SPS, made RS configuration and almost all SPS configuration. I stopped with error
"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. " in "Set server defaults" command.
My servers configuration is following: 1. Both RS and SPS are running on the same server. 2. I cannot change port of default web site, so I made different web site "Reporting services" under same web server with port 8086 (http://mtx-sps2007:8086/reportserver)
3. RS Windows service runs under domain system account that is a member of local Administrators group (account name sql2k5sps7) 4. RS Web service runs under NT AuthorityNetworkService account 5. Database connection configured using mentioned above account sql2k5sps7
6. Report Server Web Service URL in SPS is set to http://mtx-sps2007:8086/reportserver 7. Authentication Mode in SPS is set to "Trusted account" 8. My account, under which I make a connections through terminal services to SPS and RS servers and through http to reportingservices page is a member of local administrators group of both my PC and server. 9. I'm not familiar with SPS (honestly speaking, with RS too, but at least I learning this quickly, but SPS is out of my responsibilities scope) 10. ReportServer runs under separated app pool that runs under NT AuthorityNetworkService account
And now I'm fighting with this error on "Set server defaults" command. It's interesting that from my PC there is no credentials prompt when entering SPS administrations page and error is following: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode But from terminal client, connected to SPS and RS server, there is a credentials prompt (I enter my credentials) and error is as mentioned abowe: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. Also, the same error I got when I tried to add a report to report viewer web part on SPS test page.
Can anyone help me with this? I would be greately appreciated to any help on resolving this issue.
Hi everybody. I am new to VBA,.,, I Have created a folder under inbox in Outlook 2007 which stored the receipients information like name, E-mail, which is not present in the address book of outlook. I have imported this folder in access 2007. My problem is ... it does not display the email address. Rest of the informations is displayed... Is there any way i could do this.?? is there any way i could get the email addresses to appear(import/get) in to the access table??? Is there any module i mite have to create??
We have an Office SharePoint 2007 site, we developed a couple of web parts and added them to our site. We used SQL Server Reporting services 2005 as our reporting solution. The reports are hosted on the report center and when we need a report, we open it by sending a URL requesting the report, passing the report parameters in the URL query string. So the report is filtered based on the parameters passed from the web parts.
But since best practices say that you should host reports directly under SharePoint, by configuring the reporting services to run in the SharePoint integrated mode. We followed the steps and installed SharePointRS and we finally succeeded to publish the reports to a SharePoint folder, but we had a limitation: we are unable to pass the report parameters internally to the report hosted in SharePoint. If we passed them in the query string as the report center case, SharePoint neglects them totally. So the question is: how can I pass parameters internally between a SharePoint web part and a SQL server 2005 reporting services report hosted in SharePoint?
I need "conditional" cascading parameters: In Report Manager when one changes parameter 1, parameter 2 get changed based on parameter 1. Optionally, one can also enter values to parameter 2 directly.
I was able to achieve this in SSRS 2000 (SP2) with the following setups. SSRS 2005 and SP1 no longer works - Parameter 2 always shows its default value regardless whether one select a value in Parameter 1 or not.
Parameter 1 available values: from query default values: non query (specify a value "<None>") Parameter 2 available values: Non query (no value specified) default values: from query (based on Parameter 1)
It seems to me that the default value in SSRS 2000 is considered as cascading parameter. But it is no longer the case in SSRS 2005.
Is this a SSRS 2005 bug? is there any other work arounds or suggestions?
Hi, In my report i have got 10 columns to disply out of which 8 are direct pull and rest two are calculated(count of column). All the 8 columns are used as parameters. when i open the report all should take default values and report should be generated.This is done. In BIDS this report is generated i 5 sec approx. But when i view it in ReportViewer it takes 30 sec approx to display the same. Table has maximum of 4000 records. And two of the Parameters out of 8 have 4000 values. Is there a scope to get the performance at par with BIDS environment.
We have reports that runs fine in our developing and test inviroment. But when I deployed to the production server so comes the problem when navigating reports with multiple pages. It works fine when reports loads for the first time or click the refresh button, it show the first page of the report. Then we get "An internal error occurred on the report server. See the error log for more details. (rsInternalError) " when we try to go to next page or back to the previous page.
I have SSRS 2005 SP2 configured to work in Sharepoint integration. Everything works fine except that I am not able to programmatically change any property of report viewer web part (instance) that I have added on on home page of my sharepoint site. I can do same thing via sharepoint UI but not through program. When my programs runs it fetches all web parts been added on home page, then I need to iterate through each one and find report viewer web part. While iterating, as soon as I arrive to report viewer web part it is named as "Error web part" with error message as "Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again"
If someone has a solution, please respond at your earlist.
I have a table with a column named measurement decimal(18,1). If the value is 2.0, I want the stored proc to return 2 but if the value is 2.5 I want the stored proc to return 2.5. So if the value after the decimal point is 0, I only want the stored proc to return the integer portion. Is there a sql function that I can use to determine what the fraction part of the decimal value is? In c#, I can use dr["measurement "].ToString().Split(".".ToCharArray())[1] to see what the value after the decimal is.
Hi there- I want to see the reports developed in SQL reporting Services from Share point Server 2007. I see two methods to do this and would like to know the advantages / disadvantages between these two methods. 1) Configure Report Server to run in Share Point Integration mode and deploy the SQL reporting services reports directly in the Share point site. 2) Configure Report Server to run in Native mode and deploy the SQL reporting services reports in a web site. Just add the link for these reports in the Share point Site. Thanks in Advance.
Hey guys, I am working on the database side of an upgrade for our Sharepoint site to MOSS 2007. The current environment is SQL Server 2005 (SP2) clustered (8 dual core CPUs, 32GB RAM) with about 0.75 TB of data (about 10 different dbs). I noticed that the collation on the sharepoint databases are not the same as the system databases and other user databases.
The collation setting for our current Sharepoint is: Latin1_General_CI_AS_KS_WS
The collation setting for MOSS is: Latin1_General_CI_AS_KS_WS
The collation setting for our system databases is: SQL_Latin1_General_CP1_CI_AS
The collation setting for the server is: SQL_Latin1_General_CP1_CI_AS
I am aware of the following issues with having different collation settings between user databases and system databases. http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/12/883.aspx
http://support.microsoft.com/kb/843578
Currently nothing is broken, everything is working fine; So my question is: What does best practices suggest I do in this situation? Do I leave everything as is? Do I change the server collation and system databases?
Any suggestions and feedback will help. Thanks, Reghardt
We have 64 bit MOSS with integrated SRS. This works quite well. You lose data-driven subscriptions until the release of SQL 2008. We want to build a custom subscription/workflow solution that renders reports and pops them into SharePoint lists. What we want to do is render thousands of reports into SharePoint document libraries and use workflow rules to route them to file shares, emails, approvals, etc.
This can be done manaully by right clicking the RDL in a report library and selecting Manage Subscriptions. This brings up a web page listing existing subscriptions (_layouts/ReportServer/ManageSubscriptions.aspx). This page does not write to a SharePoint list, but a set of tables in the ReportServerIntegrated database. I can see the tables and stored procedures that do the work. I cannot find a programming interface to create the subscriptions in code. I guess I can just call these stored procedures.
I also posted in the SharePoint forum, but maybe someone here can shed some light on this frustrating issue:
We have Reporting Services integrated with our MOSS environment. Several reports were set up for autmatic delivery via subscription. This was pre SP1 times and the reports ran just fine (they are not data driven reports). Whether it is related or not I don't know, but two weeks ago we upgraded to SP1 without any problems. Shortly after that, our users stopped getting their reports via email. When I go to the reports and click on "Manage Subscriptions", the history of subscriptions shows that the report ran, but then there is an error message under last results saying
"The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)"
I tried recreating reports, setting up new data connections, re-subscribing... nothing works. Checked SQL server logs - they seem to be OK; checked SharePoint logs - they show error with few minutes off the scheduled report, so I don't know if this is related, but here it is nevertheless:
"Unexpected query execution failure, error code 282. Additional error information from SQL Server is included below. "The 'proc_GetTpWebMetaDataAndListMetaData' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead." Query text (if available): "{?=call proc_GetTpWebMetaDataAndListMetaData(?,'1F57DB6C-AF94-4557-866D-4214D9EC8313',?,NULL,1,?,?,6187)}" "
Any ideas what went wrong or how to fix this? Does this have anything to do with .Net service packs that we installed about the same time as SP1 implementation?
