Auto-deploy Reports To Sharepoint 3.0 Site --URGENT
Hi!
I need your help for something I've been trying to do:
I use VS2005 to create reports, which are then uploaded to a WSS 3.0 site's document library. Next I manually connect these .rdl files to a shared data source file (.rsds) that I have created in that document library. Everything works fine!
So, what I would like to do is to have a way to automate the process of uploading the .rdl files and then connecting them to the shared data source.
I'm aware of the WS Upload Service, but this does not do the connection of the .rdl to the data source.
Any ideas?
Thanx a lot!
Stefanos
View Complete Forum Thread with Replies
Related Forum Messages:
Deploy/edit Reports In Sharepoint Integrated Mode
Hi, I'm working with the Dec CTP of SQL 2005 SP2 and the associated Sharepoint addin. I've been able to get a report created in VS2005 and manually uploaded to the Document Library holding reports, and the report works when I open it (using an internal datasource, not shared). My first problem is I can't get VS2005 to deploy datasources or reports to my doc library. I have configured TargetDataSourceFolder http://server/site/doclib TargetReportFolder http://server/site/doclib TargetServerURL http://server/ When I try to deploy my Shared Data Source, it asks me to login, and will not accept my credentials (I am farm administrator, and site collection administrator, and local administrator, and a site owner) Secondly, for the report I manually uploaded, I can't edit it in Report Builder (from Sharepoint) because I get stuck on entering something that works into the Select Site or Server dialog box. I've tried http://server/ and http://server/site/ and http://server/site/doclib Can I have some tips please? Thanks Martin
View Replies !
Cannot Deploy Reports From Visual Studio To Sharepoint In Integrated Mode
Hi Having finally managed to get over the hump of getting Sharepoint integrated mode working in a farm install, I am having a problem deploying reports from Visual Studio to Sharepoint. I have set the deploy properties as follows: TargetDataSourceFolder: http://ppdwn-bl10:8888/ReportTest/Data Sources TargetReportFolder: http://ppdwn-bl10:8888/ReportTest/Harvest Reports TargetServerURL: http://ppdwn-bl10:8888/ Visual Studio is updated to Service Pack 2, as is of course the report server. The reports APPEAR to deploy - they actually appear in the document library after deployment! But the result is: ------ Build started: Project: Harvest Reports, Configuration: Debug ------ Build complete -- 0 errors, 0 warnings ------ Deploy started: Project: Harvest Reports, Configuration: Debug ------ Deploying to http://ppdwn-bl10:8888/ Deploying data source 'http://ppdwn-bl10:8888/ReportTest/Data Sources/ReportWarehouse.rsds'. Report Server has encountered a SharePoint error. Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl'. Report Server has encountered a SharePoint error. Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdownSaleable.rdl'. Report Server has encountered a SharePoint error. Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/FaceBreakdown.rdl'. Report Server has encountered a SharePoint error. Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/LustreBreakdown.rdl'. Report Server has encountered a SharePoint error. Deploying resource 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/paspaley.gif'. Report Server has encountered a SharePoint error. Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPercentage.rdl'. Report Server has encountered a SharePoint error. Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPM.rdl'. Report Server has encountered a SharePoint error. Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/Summary.rdl'. Report Server has encountered a SharePoint error. Deploy complete -- 9 errors, 0 warnings ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Unfortunately I cannot view the reports in Sharepoint - I can see them in the document library but when I click them I get the same error, except in the web browser. "Report Server has encountered a SharePoint error". The Report Server log shows the following: w3wp!library!1!03/06/2007-09:38:24:: Call to GetPermissionsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl). w3wp!library!1!03/06/2007-09:38:24:: Call to ListParentsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl). w3wp!security!a!03/06/2007-09:38:24:: i INFO: Exception while running with elevated privileges w3wp!security!a!03/06/2007-09:38:24:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) w3wp!library!a!03/06/2007-09:38:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. w3wp!security!a!03/06/2007-09:38:25:: i INFO: Exception while running with elevated privileges w3wp!security!a!03/06/2007-09:38:25:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) w3wp!library!a!03/06/2007-09:38:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. Any help would be appreciated. Thanks Adam
View Replies !
Unable To Deploy Reports From VStudio When Working In SharePoint Integration Mode
Hello, I have a configuration where my SharePoint services are running on a web machine and the SQL server reporting services are running on a different machine. I installed SQL SP2 and the SQL Server Reporting Services Add-in for SharePoint by following all the instructions listed in €śConfiguring Reporting Services for SharePoint 3.0 Integration€? (http://msdn2.microsoft.com/en-us/library/bb326356.aspx). My issue is that when I Deploy a report from a VS Report Server project by running Visual Studio on the machine where reporting servicers is running, everything works fine. But if I try the same thing on any other machine on the network, I get a €śThe file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.€? message. I€™m sure I€™m missing something on the configuration but I can€™t tell what. Thanks a lot Gabo
View Replies !
Deploy A Database And ASP.NET Site To GoDaddy.com
I have a vb.net web page which I created (a shopping cart). I created this site using vb.net 1.1 and SQL 2000 on my laptop. On my laptop everything works properly, but when I tried moving it to GoDaddy (http://currahee3-506.org/px/default.aspx). In the code, each query to the SQL server is done using stored procedures. When you first go the page, a drop down is presented. When you select "Shirt" from the category drop down. A second drop down menu is then displayed and will let you select what type of shirt you are interested in purchasing. Select Polo Shirt Without Pocket. Upon doing so, I receive an error message: Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'. 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: System.Data.SqlClient.SqlException: Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.Source Error: Line 143: sqlCommand.Parameters.AddWithValue("@str_ItemName", Trim(DDL_Items.SelectedItem.Text)) Line 144: Line 145: Dim dataReader As SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection) Line 146: Line 147: dl_Description.DataSource = dataReader Source File: d:hostingcurraheepxdefault.aspx Line: 145 Keep in mind the Stored Procedure works in my testing environment, but not on GoDaddy. I moved the selected statement into a view on the GoDaddy SQL server, and the view worked perfectly. The tables do exist on the GoDaddy SQL Server. This is the Stored Procedure: CREATE PROCEDURE [dbo].[sp_GetItemInfo] @str_ItemName VarChar(50) AS SELECT TOP 100 PERCENTtbl_pxProducts.int_ItemID,tbl_pxProducts.str_ItemName,tbl_pxProducts.int_RetailPrice,tbl_pxImages.str_SmallImageURL,tbl_pxImages.str_MediumImageURL,tbl_pxImages.str_MediumImageBackURL,tbl_pxImages.str_LargeImageBackURL,tbl_pxImages.str_LargeImageUrl,tbl_pxImages.str_SmallImageBackURL,tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold AS int_QtyAvailable,tbl_LookupCategory.str_Category,tbl_pxProducts.Int_SizeID,tbl_LookupSizes.str_Size,tbl_pxProducts.Int_ColorID,tbl_LookupColor.str_Color FROMtbl_LookupCategoryINNER JOINtbl_pxProductsONtbl_LookupCategory.int_CategoryID = tbl_pxProducts.int_CategoryIDINNER JOINtbl_LookupColorONtbl_pxProducts.Int_ColorID = tbl_LookupColor.int_ColorIDINNER JOINtbl_LookupSizesONtbl_pxProducts.Int_SizeID = tbl_LookupSizes.int_SizeIDLEFT OUTER JOINtbl_pxQtySoldONtbl_pxProducts.int_ItemID = tbl_pxQtySold.int_ItemIDLEFT OUTER JOINtbl_pxImagesONtbl_pxProducts.int_ItemID = tbl_pxImages.int_ItemID WHERE(tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold > 0)AND(tbl_pxProducts.str_ItemName = @str_ItemName) ORDER BYtbl_LookupSizes.str_Size Does anybody have any suggestions as to why this stored procedure is failing?
View Replies !
Problem When Trying To Deploy A Web Site Built With Asp.net 2.0 And Using SQL EXPRESS
Hi, Plz help! I built a web site using IIS and ASP.NET 2.0. My web site has a log on screen and I only configured it with one user without any roles. This web site uses the SQL EXPRESS.(I Have 2 databases: 1 for the security required by the application and the other for my application. for the connectionstring I used a windows authentication security with an instance = true.) Everything went well on my PC. When I tried to deploy the web site on another PC, there was a big problem. When I tried to login with the same user I created, then I have a problem. The password is incorrect(Why? I don't know). Maybe there is a problem with the IIS or with the SQL SERVER. pLZ HELP!!
View Replies !
Deploy Failed In SharePoint Add-in For Reporting Services
Hi all, I am a newbie for SSRS 2005 and have a problem about deployment step. First, I have already configured the reporting services and have also tried to create the report by SSRS. Everything is fine until the deployment of my project. The error is shown as followings: The path of the item '/DS/DSSS2' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. Deploy failed And, these bellows are my details Full name path : c:mossdata eport eportml eportmlDRPSS2.smdl TargetDatasource : DS Data Source Name : DSSS2 Then, I have come back to the SharePoint portal and found that the data source folder and data model folder are created as my earlier steps (before deployment step). I, therefore, build the report by using Microsoft report builder and adding the built report into my port through the SQL Server Reporting service report viewer. It is fine and shows the result as my design. But I wonder the error warning in deployment step and would like to solve that. I think my full path name is not longer than the 260 characters as above. Have anyone suggest me about this situation for fixing the error? Thank in advance
View Replies !
Deploy Error To Sharepoint Integration Mode
Hi, I got error "A connection could not be made to the report server http://servername/sitename" when I tried to deploy the data model into sharepoint site from Businesss Inteligent studio. Howervr i am able to deploy from the sharepoint server machine locally.(with the same windows login user). All the authetication mode is Windows authetication. Any help will be very appreciated. Robert
View Replies !
Code To Post Files To A SharePoint Site
I am looking for sql code/approach to export a text file and 2 excel works sheets(from an excel workbook) in a folder, to 3 different tables in sql server, perform data scrubbing and then export the data from all 3 tables to 3 different excel sheets and post them in 3 different web parts in a share point site. Mainly sql code(or any code that i can integrate with SQL Server) to post files to different web parts in a share point site is what i am looking for. Any sort of pointers/suggestions would be really helpful. Thanks & Regards,
View Replies !
Cannot Deploy To A SSRS Sharepoint Integrated From A Desktop To The Server
Hi, I have a server with WSS and SQL Server 2005 with reporting services in Sharepoint Integrated Mode. When i develop Report on the server, i have no problem to deploy on a sharepoint library. My user is a domain account and is in the group Administrators on the server. when i develop Report on my desktop and i want to deploy, i have the following error TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://cpm:81/. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title> Error </title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/> <script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script> <script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script> <meta name="Robots" content="NOINDEX " /> <meta name="SharePointError" content=""/> </HEAD> <BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();"> <form name="aspnetForm" method="post" action="_layouts/error.aspx" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();"> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2RkZWn6RQiD+YddpGkjbShF7sJByhw=" /> <TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%"> <tr><td> <table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%"> <tr> <td colspan=4 class="ms-globalbreadcrumb" align="right"> <a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a> </td> </tr> </table> </td></tr> <tr> <td class="ms-globalTitleArea"> <table width=100% cellpadding=0 cellspacing=0 border=0> <tr> <td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif" alt="" /></td> <td class="ms-sitetitle" width=100%> </td> <td style="padding-top:8px;" valign=top> </td> </tr> </table> </td> </tr> <TR> <TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer"> </TD> </TR> <TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0"> <tr> <td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td> <td class="ms-titleareaframe" id="TitleAreaFrameClass"> <table cellpadding=0 height=100% width=100% cellspacing=0> <tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr> </table> </td> <td valign=top id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%"> <table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0"> <tr> <td valign="top" class="ms-titlearea"> <a href="http://cpm:81" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a> </td> </tr> <tr> <td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle"> <h2 class="ms-pagetitle"> Error </h2> </td> </tr> </table> </td> <td class="ms-titlearearight"> <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> </tr> <TR> <TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell"> <table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0> <tr> <td> <TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0"> <tr valign="top"> <td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td> <td valign="top" width="100%"> </td> </tr> <tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr> </TABLE> </td> <td></td> </tr> </table> </TD> <td> <div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> <td class='ms-formareaframe' valign="top"> <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet"> <TR valign="top" > <TD class="ms-descriptiontext" width="100%"> </TD> <TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD> </TR> <TR > <TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD> </TR> <tr> <td valign="top" height="100%"> <A name="mainContent"></A> <table width=100% border=0 class="ms-titleareaframe" cellpadding=0> <TR> <TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext"> <span id="ctl00_PlaceHolderMain_LabelMessage">Le fichier que vous tentez d'enregistrer ou d'extraire a été bloqué sur ce site Web par les administrateurs du serveur.</span> <P><span class="ms-descriptiontext"> <span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span> </span> </TD> </TR> </table> <script type="text/javascript" language="JavaScript"> var gearPage = document.getElementById('GearPage'); if(null != gearPage) { gearPage.parentNode.removeChild(gearPage); document.title = "Error"; } </script> </td> </tr> </table> </td> <td class="ms-rightareacell"> <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> </TR> <tr> <td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> </tr> </TABLE></TD></TR> </TABLE> <input type="text" name="__spDummyText1" style="display:none;" size=1/> <input type="text" name="__spDummyText2" style="display:none;" size=1/> </form> </BODY> </HTML> --. (Microsoft.ReportingServices.Designer) ------------------------------ BUTTONS: OK ------------------------------ Ty to help me Cédric Boulton
View Replies !
Prevent SQL/CLR Auto Deploy
Hi, I have a solution (VS 2005, C#) that includes a SQL 2005 CLR project. When I run the solution (in debug mode, and with a test harness in a different project in the solution set as the startup project) the IDE often wants to deploy my CRL assembly. How do I tell it NOT to try to do the deployment? (i.e. to only do it when I right-click the project and tell it to). Cheers,
View Replies !
Deploying Reporting Services In An Extranet Sharepoint Site
Hi Everyone, I'd like to know who has experience in deploying reporting services reports in an Extranet Sharepoint Site. I've read some articles on it, and it says its doable. I was hoping I can get some responses in here to see how to go about doing such thing. - what first few considerations do i need to have? - setting up the environment - more importantly, security considerations since the windows authentication that is normally used won't work in an extranet environment. I am guessing that a few groups need to be created on this with only certain access allowed for each (browser capability, content management...etc) Any input would greatly help. Please enlighten me, thank you Angelie
View Replies !
Windows SharePoint 3.0 And Project Server 2007- Error On Rebuild Of Site
My site crashed, so I had to rebuild the Project Site. I used the SharePoint products and technologies configuration wizard to disconnect from the server farm (only actually running on the single server). I then reran SharePoint products and technologies configuration wizard to setup the site. Configured the Project Service and attached to the existing dB's. Previously, I used the url http://servername.domain.forest/PWA/default.aspx . Now when I attempt the use the same URL, I get the following error: "An unexpected error has occurred" I have tested this one 3 servers now and I receive the exact same result. Is there a path I should apply to the servers in order to allow fully qualified server names after a reinstall of the system?
View Replies !
Problems Building An RS Report (SQL 2005) That Uses A SharePoint List In A Sub Site As A Data Source.
I need to build a RS Report (SQL 2005) that uses a SharePoint List as a data source. Is there any API call to get every list in every subsite? Is there a parameter that I can pass to GetListCollection to override the parent Site *.asmx file? Has any one designed an RS Report whose data source is a List in a sub site? Is there some query (or settings in SharePoint) where I can see at which site (*.asmx file) a List belongs since the url approach hasn't worked for me? The lists I need to work with are located at http://rootsite/x/y/. I started my project and added the appropriate xml data source (http://rootsite/x/y/_vti_bin/Lists.asmx) and expected that would allow me to work with the lists within the "/x/y" subsite, but using the GetListCollection Query reveals that it is getting the lists located at the rootsite level. I'd like to get ahold of the lists under the subsite. However the list I am interested in is not included in the data reurned from GetListCollection Regardless of what level I set my data source to ... I get the same collection of SharePoint Lists (which does not inclue my List). I have followed these blogs as a guide: http://rockstarguys.com/blogs/colin/archive/2006/11/10/accessing-sharepoint-list-items-with-sql-server-2005-reporting-services.aspx http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx Any help is much appreciated.
View Replies !
How To Deploy Reports.
Hi, I have a web project and created a setup project for it. And I have to create reports using sql server reporting services. For this I have created an reportserver project and created two reports. I have to create a setup file to install these reports in a remote machine. How to do this? where this .rdl and .rds files will be stored in the reportserver. Regards, Murali
View Replies !
Deploy Reports
Hi, i have installed SQL Server Advanced With Reporting Service following the instructions on the SQL video. Everything works fine. Afther i have make a report with Business Intelligence Studio Express ( using the wizzard ) i try to deploy (local , ISS 5.1 on Win XP SP 2) this report by clicking right mouse on the projectname and then deploy. In the messagebox : no errors, build and deploying. When i serve to http://localhost/reports..... nothing is changed on the main page and i can't browse to my reports. Can someboy help me.....please Thanks
View Replies !
Can Not Deploy Reports
I have created a report project file on my local machine.Now I'm trying to deploy those reports to a development server. I have installed sql server and tools in my local machine but never configured reporting services. When I try to deploy those reports, it asks username and password for reporting services login. But usually as far as I know, i should be able to deploy my reports without entering password etc. Even if I enter username and password, still they dont work. Is that becase I install SQL server in my local machine? Does anyone know why? Thanks
View Replies !
Deploy Reports Remotely
I have a web app done in dot net 2.0. I would like to be able to deploy the reports to a remote server. When I put the server IP in the target string and click DEPOY I get a CANNOT CONNECT error message. If I am on site and use the private LAN address it works perfectly. Is this a firewall or logon issue to SQL? Is there a way to do this? Thanks Chuck
View Replies !
Cannot Deploy Reports With Parameters
Hi, I am a beginner with SQL Reporting Services and having a problem. I can deploy reports with no parameters and the datasources fine. But when I deploy a report with a parameter I get the following error "An unexpected error occurred in Report Processing." I looked at the log file and this is what I found. Any suggestions on how to fix this? aspnet_wp!processing!7!10/03/2007-14:59:11:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.IO.FileNotFoundException: Could not find file 'C:Documents and SettingsD2P6PM51ASPNETLocal SettingsTempexpression_host_a23b56b0ae874a989c3e9c76fe9a07ff.dll'. File name: 'C:Documents and SettingsD2P6PM51ASPNETLocal SettingsTempexpression_host_a23b56b0ae874a989c3e9c76fe9a07ff.dll' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at Microsoft.ReportingServices.ReportProcessing.ReportCompileTime.InternalCompile(Report report, AppDomain compilationTempAppDomain, Boolean refusePermissions) at Microsoft.ReportingServices.ReportProcessing.ReportCompileTime.Compile(Report report, AppDomain compilationTempAppDomain, Boolean refusePermissions) at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.Phase3(ParameterInfoCollection& parameters, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions) at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] definition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileReport(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions) --- End of inner exception stack trace --- Thanks Allan
View Replies !
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 !
Error - Can't Preview Or Deploy New Reports
Hi, I'm trying to build a new report and I can't preview it, and when I try to deploy it to my development Report Server I get this error message: The type initializer for "Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an exception. I have recently re-installed Reporting Services on my development PC, and this is the first new report I've tried to build. I am able to edit and deploy my existing reports no problem. anyone got any ideas how to fix this?
View Replies !
Deploy Reports To Remote Machine
I have a dotnet app using a web form with an embedded report viewer control that calls a report. Works perfectly (now that SP2 is installed). How do I deploy that to a remote server? When I change the target and enter the IP address of the server I get CANNOT CONNECT. Is this maybe a firewall issue that needs some port opened up? Deploying locally works fine. Thanks Chuck
View Replies !
Reporting Services: I Cannot Deploy Reports.
I am using Visual Studio 2005 and trying to deploy reports to SQL Server 2000. I get the following message: A connection could not be made to the report server http://aklink1/reportserver. ------------------------------ ADDITIONAL INFORMATION: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) Please help!
View Replies !
Deploy Reports To Specific Folders
Hi, I am a new user for RS so this might be a very dump question for some of the advanced users here. I am using SQL 2005 RS and was wondering how I can deploy reports to specific folders that I created on the Reports page. I do know that I can go to Properties to move the reports to different folders. But the problem I have is when I deploy the reports from VS 2005 ( I created the reports using VS 2005) they were deployed back to the old/root folder. How can I change the 'deploy-to' destination folder for the reports in VS 2005? Many Thanks, Casey
View Replies !
How To Deploy The Reports Automatically In SSRS?
Hi, I am creating a application to show reports for daily based information. I have created the reports and i am changing the data source at run time.In order to view the updated reports, i have to deploy. So i need to deploy the reports automatically. can any one gave a idea to do this. thanks
View Replies !
Serving Up Reports Without Sharepoint
Hello, Sorry for the newbie question... Is there a way to "serve" up reports in a SharePoint-like way without using SharePoint? I am part of a team of ASP.NET developers that are writing our own pages, but I haven't been able to find information about Reporting Services 2005 in ASP.NET and/or using Web Parts on our own pages. Any information about this would be greatly appreciated. Thank you. -Gumbatman
View Replies !
Deploy Reports Via Visual Studio 2005
This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services. I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out" When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio. Thoughts? Thanks
View Replies !
/Reports Site Returning 404.3 Error After Install
Hi All, I have just installed SSRS 2005 SP2 on a x86 box (one of several boxes we use to run SSRS). However, on this particular machine, I get an http 404.3 error (file not found) when attempting to access any aspx file in the reports virtual directory. aspx files in the /reportserver site all return just fine. All the check marks for the configuration site show green I've uninstalled / re-installed / re-booted / etc... No luck This is a VM server.... Ideas?
View Replies !
Making Reports Customizeable For Users On A .NET Site
Hello, We have a small .NET intranet site and I have some experience with Reporting Services. What I am looking to do is develop some reports on our website. However, I would like to make it so the user can do some customization of their reports. For example, there would be sections of reports (Headcounts, Turnover, etc.) and in each section there would be measurements they could click to include. So I could select the Headcounts section and select the measurements such as Terminations, Hires, and Period End Headcount. I may not select the Turnover sections at all. I am almost thinking like a Google page where you can move around the sections and have your own customized report. Maybe these sections could work as Web Parts, or something like that. Does any of this make sense? Is it possible? Are there are websites or examples that are out there that I could get an idea to see if this has been done and how to do it? Thank you. -Gumbatman
View Replies !
SQL Reports In Sharepoint Team Services
I have installed SP2 on my report server and configured for Sharepoint access. This is all ok. I am able to use the webpart to create a report view but it wants the report. Is there a way to manage the report server (they way I did with reportmanager) in sharepoint. If so I have not found out how. any ideas or links to show how I can have teh reports listed in Sharepoint? Thanks
View Replies !
Transforming A DB To Another Site...URGENT!!
Hi ALL! I need to setup a new SQL server 7.0 to transfer the responsibilities of maintaining a particular database which is currently on another server maintained by some one else in some other city.I need to get all the jobs which are currently run on the other server to my new server and run them on my server.Jobs are basically executing some stored procedures on daily basis.So,what all I need to DTS from original server initially when I setup the new server at my place for this purpose,to still perform all the activities relating to the particular database.Once I transform the database to my new server,the original database will be no longer available for me at the other place.Hope it is clear enough to understand. Thanks.
View Replies !
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 !
Hiding Reports In Sharepoint Integration Mode
I'm setting the Hidden property to True and then creating the report using the CreateReport method from the ReportingService2006 class. When I check the reportserver database Hidden is set to true. But when I call the GetProperties method it shows Hidden as being false. And in the document library the reports are visable. I tried calling the SetProperties method after I created the report but it still didn't work. Here's how I create the report. Dim props(0) As ReportServer.Property Dim SetProp As New ReportServer.Property SetProp.Name = "Hidden" SetProp.Value = "True" props(0) = SetProp rs.CreateReport(Path.GetFileName(fileName), Folder, True, bytes, props, warnings) Any idea? Thanks, -Somsong
View Replies !
Multilingual Reports In Windows Sharepoint Services
Hi, We are building a site with Windows sharepoint services and want to integrate reports from Reporting services. We know this can be done with the Report Explorer and Report viewer web parts. Our requirement is to make the site and also the reports (that are being displayed in the Report viewer web part) multilingual i.e. depending on the user's language preference, all the labels and texts on the report should get changed. Is there some support within Reporting services to do this, or are there other ways (resource files, custom code etc.) through which this can be achieved. Thanks a lot, Simranjeev
View Replies !
Printing Reports In Sharepoint Intergrated Mode
I have been trying to add a button to a web part I have created that renders reports that will print the report using the RSClientPrint ActiveX object. All the information I have found suggest passing the URL for the ReportServer and then the URL to the report (including parameters) and then a friendly title. http://msdn2.microsoft.com/en-us/library/ms159195.aspx The problem I have is that our Reporting Services is installed in Sharepoint Intergrated mode so for starters passing parameters in the URL querystring will not work. Here is some example code, <OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" CODEBASE="<URL to the .CAB file>#Version=0.0.0.1>" VIEWASTEXT> </OBJECT> <script language="javascript"> function Print() { var RSClientPrint = document.getElementById("RSClientPrint"); RSClientPrint.Print('http://<ReportServerURL>/ReportServer', 'http://<SharePointServerURL>/personal/administrator/reports/testreport.rdl', 'Test_Report'); } </script> The browser client print tool appears but when I try to print or print preview It says there was an error rendering the report. I tried putting in a junk URL and I get the exact same message. The test report in question doesn't require parameters so that wont be the problem. I even tried setting the first parameter to the ReportServer URL that is created in Sharepoint, namely, 'http://<SharePointServerURL>/_vti_bin/ReportServer' Nothing seems to work! I notice that the ReportViewer web part that you get when you install fully intergrated mode has a print button that will print the report so this MUST be possible. Has anyone managed to get this working? Many thanks in advance, ADe
View Replies !
Viewing Sql 2005 Reports Externally Through Sharepoint
We have sql 2005 setup pulling sharepoint list data and we have created a report from this data. We can view this report through sharepoint internally however when we try to view the report externally we cant view it? Has anyone else had the same problem? Any help would be much appreciated, thank you.
View Replies !
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 !
Generating Reports From SharePoint List Using Reporting Service
Hello Everybody, I am presently working on a project which handles much larger amount of data. The application demands extensive reporting from the SharePoint data. I'd like to know how I can generate reports from the SharePoint lists using Reporting Services. Planning to install in SQL Server Integrated mode Thank you, Arun
View Replies !
@timestamp Variable For Saving Reports To Sharepoint Library
Hey all, Got a question about the @timestamp variable that you can use to mke a file name unique. I am looking at having a report saved each saturday to a sharepoint folder. I would like the month to be appended to the filename, so that each saturday within a month, the existing report will be overwritten until the month changes, and then a new report will be saved. Is there any way we can create our own variables to use in the filename field or can i pull a variable that i use in the report for the filename? Any help would be great. thanks scotty
View Replies !
Error Deploying Reports In Sharepoint Integrated Mode
We are running SSRS2005 in Sharepoint Integrated Mode. RS is on a separate server from the rest of our WFE in sharepoint2007. It seems all configuration items are good in RS configuration (I originally implemented in Native mode to be sure, then Configured new databases for integrated mode). Additionally I ran WSS 3.0 and configured the RS server to be part of farm. From sharepoint CA, I have configured the 3 settings that show up under Application Management > Reporting Services --under "Manage Integration Settings" we are using "Windows Authentication" mode --All seems fine in the configuration since we are able to access and manipulate the "Set Server Defaults" page and can set SSRS server settings But when we go to deploy a report we get the error below€¦I believe it must be an issue with the double hop from sharepoint to the RS server. Things to note: *we are using a single domain account for both the web service and windows service on RS -necessary to use domain account in our setup according to microsoft -using 1 service account for both services also OK according to microsft *we ran adsUTIL.vbs to enable NTLM authentication in IIS on the report server *sqlserver2005 sp2 implemented on all servers w/ sql components including the client deploying the report *URLs for DC library, Report Library, and Report Center all verified thru browser. Error: ------------------------------ A connection could not be made to the report server http://workspacestest.chi.ecommunity.com/sites/ReportCenter/. ------------------------------ ADDITIONAL INFORMATION: Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services)
View Replies !
Unable To Deploy Reports From VS2005 && Evaluation Copy:0 Days Left
I can't deploy reports on Visual Studio2005 anymore. I say "anymore", because a few months ago, this went well. After building correctly, VS Studio asks for a Login for Reporting Services via a popup window. I don't know what to enter... In IIS ( version 5.1) , I configured Reports and ReportServer for integrated Windows Authentication. In Reporting Services Configuration, I have the Windows Security set on Windows Account, with a username and password that I also use (withoud success) to deploy the reports from Visual Studio. Since the user is a domain user, I tried as login also the complete domain name : domainusername. Nothing helps, the popup "Login for Reporting Servies" appears again and again. If I change the settings in IIS to allow for anonymous access ( machinenameIUSR_machinename), I get the error message that the permissions granted to that user are insufficient. I also changed the Windows Service Identity into "Local System" and "Local Service"; with the same result. In the Log file of Reporting Services, I also find following phrase : "ReportingServicesService!resourceutilities...INFO: Evaluation copy:0 days left" I don't know of there is a link between this and my problems Can anyone help me in this ?
View Replies !
Managing Data Sources For Reports In SharePoint Inegration Mode
Through SharePoint you can upload an RDS file and then click manage data sources to hook upthe report to a proper shared data source. Does anyone know if you can do this through the SharePoint object model? We don't deploy our reports using the designer and we don't want to upload the reports using SharePoint. We want to add the reports to a document library using the object model, when we do this we need to manage the data source so that it will run. Thanks, -Somsong
View Replies !
SSRS Report && .NET Assembly Problem After Deploy (Urgent)
I have created reports which access LDAP to get Employee Information. If i remove LDAP code & only take fields from database report works. If i use LDAP code which is in .NET assembly, It gives #error instead of showing employee name. It works in development enviorment. but when i deploy it to reporting server it gives above error. Development & server are in same network. I am trying with following link also but no luck http://blogs.sqlxml.org/bryantlikes/pages/824.aspx Regards
View Replies !
Change Default Zoom Setting For Reports Viewed On Report Manager Web Site
I've tried changing the default zoom setting by editing the RSReportServer.config file to include <Configuration> <DeviceInfo> <Zoom>Page Width</Zoom> </DeviceInfo> </Configuration> under the <Render> <Extension Name = "HTML4.0" etc. However, all reports still show up with the zoom setting at 100% on the toolbar. I stop and restart the Report Server Service and it comes up OK so I know my XML syntax is cool. What am I doing wrong? This is on a 2005 Report Server. Reports are built in VS2005 Report Designer and deployed to the Report Server directly. Reports are accessed via IE7 browser.
View Replies !
Urgent Problems With Getting Site To Work At Hosts Server
Hi there.I have made a site with some *.mdf database files that works fine at home. I use Sqlexpress, but when i copy my files to the host server (ASP 2.0 SQL server 2005) the *.mdf file will not attach.I get the following error : CREATE DATABASE permission denied in database 'master'.Could not attach file 'D:Websites***********.netApp_DataDatabase.mdf' as database 'Database'.I have tried with a lot of different connection strings but no one work.My current connection stirng is: <add name="ConnectionString_Default" connectionString="Data Source=>>IP Number<<;Initial Catalog=Database;AttachDbFilename=D:Websites>>my path<<.netApp_DataDatabase.mdf;Integrated Security=True;" providerName="System.Data.SqlClient"/>Is there any problem just copying my files to the host server, and then correct the connection string. Is Sql Server 2005 able to attach a *.mdf file just as SQLexpress is.Please help me soneone . Time is running, and I am late with my project.p.s. I am the first using the host server setup with sqlserver 2005. There may be something wrong with theri setup.Thans RHJ
View Replies !
SSRS In Sharepoint, WrapperReportRenderingException/JobCanceledException For Large Matrix (OLAP) Reports
Hi all - please help! I'm running SSRS 2005 (9.00.3027.00) in Sharepoint integrated mode on a Win2003 SP1 box. This works fine for most reports, including matrix reports sourcing data from SSAS 2005. However, I have a couple of large matrix reports (7 columns per group, 12 column groups, 150 rows, 1 row per group, data from SSAS) that run fine when I run them in VS2005, but as soon as I try and run them from within Sharepoint/Report Server I get "An unexpected error has occurred.". Sometimes this happens after 60 seconds, sometimes more (up to 3 minutes) If I filter them down to 7 column groups they work perfectly (altbeit slowly,1-2 mins), 8 groups works sometimes, 9 never works. I've checked that the report execution timeout is set to 10 minutes. The SSRS log shows the errors as WrapperReportRenderingException and JobCanceledException. I'm not sure whether the the rendering error causes the cancelled error or vice versa. does anyone know what I can do about this? By the way, from looking at the CPU usage of the server, it seems as though SSRS does carry on rendering the report long after Sharepoint has given up and returned with the helpful error. Many thanks in advance Alex Log extract as follows: w3wp!library!7!01/25/2007-11:11:44:: Call to GetPermissionsAction(http://uk-ls-it-02/Reports/Triangles/Gross Triangle Treaty Property.rdl). w3wp!library!7!01/25/2007-11:11:44:: Call to ListParentsAction(http://uk-ls-it-02/Reports/Triangles/Gross Triangle Treaty Property.rdl). w3wp!library!7!01/25/2007-11:11:49:: Call to GetPermissionsAction(http://uk-ls-it-02/Reports/Triangles/Gross Triangle Treaty Property.rdl). w3wp!library!1!01/25/2007-11:11:50:: Call to GetPermissionsAction(http://uk-ls-it-02/Reports). w3wp!library!13!01/25/2007-11:11:50:: Call to GetSystemPropertiesAction(). w3wp!library!13!01/25/2007-11:11:51:: i INFO: Call to RenderFirst( 'http://uk-ls-it-02/Reports/Triangles/Gross Triangle Treaty Property.rdl' ) w3wp!runningjobs!7!1/25/2007-11:13:20:: i INFO: Adding: 1 running jobs to the database w3wp!runningjobs!7!1/25/2007-11:14:20:: i INFO: RunningJobContext.IsClientConnected; found orphaned request w3wp!reportrendering!13!01/25/2007-11:14:20:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ; Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.Threading.ThreadAbortException: Thread was being aborted. at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags) at Microsoft.SharePoint.SPWeb.InitWebPublic() at Microsoft.SharePoint.SPWeb.get_ServerRelativeUrl() at Microsoft.SharePoint.SPWeb.get_Url() at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemMetaDataAndContent(String path, UserContext userContext, Boolean returnContent, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper, Byte[]& content, String& mimeType) at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemType(String objectName, UserContext userContext, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper) at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemType(String objectName, UserContext userContext, Guid& id) at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemType(String objectName, UserContext userContext) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper.Microsoft.ReportingServices.Diagnostics.IPathManager.IsSupportedUrl(String path, Boolean checkProtocol, Boolean& isInternal) at Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder.IsReportServerPathOrUrl(String pathOrUrl, Boolean checkProtocol, Boolean& isPath) at Microsoft.ReportingServices.ReportRendering.ReportUrl..ctor(RenderingContext reportContext, String initialUrl, Boolean checkProtocol, NameValueCollection unparsedParameters, Boolean useReplacementRoot) at Microsoft.ReportingServices.ReportRendering.Action.get_DrillthroughReport() at Microsoft.ReportingServices.ReportRendering.Action.get_DrillthroughID() at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.GetActionUri(Action action) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.HasMultipleActions(ActionCollection actions, Int32& actionIndex, RenderActionInfo& firstActionInfo) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderTextBoxPercent(TextBox textBox, Boolean renderId) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderReportItem(ReportItem reportItem, Int32 borderContext, Boolean renderId) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderRangeCellsContent(MatrixCell lastCell, Int32 cellBorderContext) at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderRangeCells(Matrix matrix, Int32 indexRow, Int32 startCell, Int32 endCell, IntList hiddenColumns, Int32 borderContext, Boolean dirLefRight) at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrixLevel(Matrix matrix, MatrixMember currMember, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight, MatrixContext matrixContext) at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrix(Matrix matrix, MatrixMember member, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight, MatrixContext matrixContext) at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderMatrixContent(Matrix matrix, Boolean partialItem, Int32 borderContext, Boolean dirLefRight, Boolean expandLayout, MatrixContext matrixContext) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderMatrix(Matrix matrix, Boolean partialItem, Int32& borderContext, Boolean renderId) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderReportItem(ReportItem reportItem, Int32 borderContext, Boolean renderId) at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderCellItems(ReportItemCollection repItemCol, Hashtable partialItems, Hashtable expandItems, PageTableCell currCell, Int32 borderContext, Int32 linkToChild, Boolean layoutExpand) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GenerateTableLayoutContent(PageTableLayout rgTableGrid, Hashtable partialItems, ReportItemCollection repItemCol, Boolean bfZeroRowReq, Boolean bfZeroColReq, String docMapId, Boolean inDocMap, Boolean renderHeight, Int32 borderContext, Int32 linkToChild, Boolean layoutExpand) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GenerateHTMLTable(ReportItemCollection repItemCol, Double dxParent, Double dyParent, PageData pageData, String docMapId, Boolean inDocMap, Int32 borderContext, Int32 linkToChild, Boolean expandLayout) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderRectangle(Rectangle rectangle, PageData pageData, Int32& borderContext, Boolean renderId) at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderPage(Int32 index) at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderPages() at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderBody(HtmlTextWriter htmlTextWriter) at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerReportArea.Render(HtmlTextWriter outputWriter) at Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension.InternalRender(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached) --- End of inner exception stack trace --- w3wp!runningjobs!13!01/25/2007-11:14:20:: i INFO: CancelableJobExecution.Execute caught our thread abort exception w3wp!library!13!01/25/2007-11:14:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.JobCanceledException: An administrator has canceled the job., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.JobCanceledException: An administrator has canceled the job. ---> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.Threading.ThreadAbortException: Thread was being aborted. --- End of inner exception stack trace --- w3wp!webserver!13!01/25/2007-11:14:20:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.JobCanceledException: An administrator has canceled the job. ---> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.Threading.ThreadAbortException: Thread was being aborted.
View Replies !
|
TRACKER
