Hi All,
I am deploying my reports on to the report viewer on a Sharepoint site. I wanted to know how to handle exception in the reports here. I was looking for exception handling in SSRS, but most of them are given with respect to displaying reports in ASP.NET pages. Is there any way I can configure Report Viewer to display friendly error messages instead of the vague error messages displayed from SSRS.
Thanks,
S Suresh
Not 100% sure if this is the right forum, but its the one i'm mostly used to ...
We run one one machine Sharepoint Services 3.0, we've added the webpart cab file. When we add the Report explorer that points to the second server running SSRS this works fine. When we add the Report Viewer that point to that same server running SSRS it works fine.
But, when we link to output of the Explorer to the Viewer, or vice versa, the page comes corrupt and we have to hide or delete one of the components.
Any ideas, i've been looking for some articles, found a hotfix but they all were on v 2.0 .....
Kind Regards
Is it possible to connect to the Report Viewer web part in SharePoint? This is the SharePoint integrated guy. I am displaying a report. I'd like to have links in the report that cause a sub-report or even a custom web page to open in another web part on the same page.
Is this possible?
Thanks.
J
Has anyone been successful in configuring the Hyperlink Target property in the SSRS Sharepoint Web Part? I've tried every setting, including _blank, yet the behavior does not change.
Am I doing something incorrectly or is this not implemented correctly?
Hello all,
I'm new with SP v3 and the Reporting Services of SQL Server 2005.
I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.
Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.
Cheers
Marc
Hi, I am getting the following error when I try to open up my web application now, after installing the report viewer add on and placing it onto one of my pages.
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=nutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system could not find the file specified.
Source Error:
Line 47: <add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
Source File: web.config
So far I have tried to fix this error by installing the reportviewer.exe on the server. I have also verified that the ReportViewer files are in the assembly folder on the server. I also found a site saying to run the reportviewer.exe from a specific location, here is the link
http://dotnetslackers.com/_NET/re-49414_Could_not_load_file_or_assembly_Microsoft_ReportViewer_WebForms.aspx
but when I try to browse to the folder it is talking about I found out that I don't even have a BootStrapper folder under Microsoft Visual Studio 8/SDK/v2.0
Does anyone have any ideas on how to fix this error?
I am trying to integrate reports that I have built with VS 2005 and deployed to my report server locally.
The path to the report is
http://SERVERNAME/Reports/Pages/Report.aspx?ItemPath=%2fBilling+System+Reports%2fBasic+Financial+Reports%2fBasic+Financial+Statistics+-+TimeKeeper+YTD
When I put that into the "Report" parameter the web part display an error:
The report server has encountered a configuration error. See the report server log files for more information
And when I click on the ellipses, I get a pop up with the same error.
I installed SQL2005 SP2 and the RS Add on for MS sharepoint CTP
Any help would be great!
Thanks,
Erik
I have created a report on my local machine and deployed it on a server. As I am the administrator of the server, I can access the reports with servernameReports. The report has got three data sets. Out of these three one is a Stored procedure and other two data sets have sql queries. The user selects the 'Business year' and 'sales type' from list box. This report works perfect from my local machine as well as from teh server when I am running it
I have some other users who wish to access these reports. I did the following steps:
Created a new role and assigned it at the Data Source Folder and Reports Folder
I also made the user a Database user on the server.
After doing these steps, the user can access the Reports site by servernameReports.
The user then can go into the Reports folder. But when the user tries to run the report, he gets an error with:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'BusinessYear'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Can anyone help me with this? Is htere something to do with setting up of the datasource?
I have tried to search, but could not find relevant info.
Any help/Pointers will be really appreciated.
regards
Joshker
Hi,
We have a solution where we from a Windows application (using the report viewer control SP1) display some reports. Some of the reports uses a custom report item to display some graphics. This works fine on a lot of different installations, but now (for some reason) we have a problem at one customer.
We get strange GDI and transport errors when rendering these reports:
"Unable to read data from the transport connection: The connection was closed."
or
"Remote GDI stream version: 10.0.1. Expected version 10.0.1. Offset and length were out of bounds for the array or count is greater than the number of elements from the index to the end of the source collection."
These report work fine when you run them in the browser, but they never work in the report viewer control...
Please provide some help.
Kind Regards
Sune
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
I'm not sure what to do to fix this. I've downloaded the redistributable for the report viewer. Please help, I need to have this before the weekend is over.
Thanks,
I have created a project using MVC 4 application.i have created a dataset model and .rdlc file using report viewer but i'm getting the following error when i run it.
View 5 Replies View RelatedI am using MOSS 2007 and Reporting Services 2005. Integration part worked. But my existing report (analysis service report) with cascading parameter doesn't work in sharepoint. Every time you select a parameter you have click "Apply" to see the the cascading parameter. Is this a bug with report viewer webpart, because this works on regular sql 2005 rs viewer.
SharePointHelp
I have created a .rdlc file in MVC application. I have used Matrix in report and also i have bar charts. Issue is when I view the report in my application--all the months data and all the years data is getting summed up..
ex:
it should display like
jan  feb  mar
1 Â Â 2 Â Â Â 3
but it is coming like
Mar
6
I have group by as Month for Month columns and Year for Year columns, how to fix this error.
Hi,
I get the following error when I am trying to deploy Report from Visual Studio Report Designer.
SRSS is configured in SharePoint integration mode. Configuration is mentioned below.
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://rbddspsdev2:44887/.
------------------------------
ADDITIONAL INFORMATION:
Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services)
------------------------------
BUTTONS:
OK
Configuration is as follows.
Web front end server.
MOSS 2007 Standard edition 64 bit.
SQL Reporting Service Add in 64 bit.
SQL Server
MS SQL server 2005 32 bit with sp2.
Reporting Services configured.
WSS 3.0 32 bit required for configuration, of SRSS in integrated mode.
Windows service and web service are both running under a domain account. The account is a SharePoint Admininstrator. The account is also in Administrators, Reporting Server user and Web service group and also has a dbo rights on database.
Ive seen this asked all over but am yet to find a fix for my case.
I have 1 SharePoint 2007 server
1 SQL 2005 SP2 server with Reporting services running
Reporting services is configured and running all with ticks in SharePoint integration mode, the reporting services section shows up in Central Admin ok.
When I try to access reporting services I get the error :
http://reports.domain/reportserver
Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors Looking thru the logs I get the error :
w3wp!library!d!04/04/2008-13:54:20:: Call to GetItemTypeAction(/).
w3wp!library!d!04/04/2008-13:54:20:: Call to ListParentsAction(/).
w3wp!library!d!04/04/2008-13:54:20:: Call to ListChildrenAction(/, False).
w3wp!library!d!04/04/2008-13:54:20:: 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. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl, CatalogItemList& children)
at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports)
--- End of inner exception stack trace ---
I setup a new website called RS Web Site in IIS on the SQL box, I then set this in the Configure Report Server. I have made sure Annonymous access is off.
Does anyone know how on earth I can resolve this ..
Many Thanks
Marcus
Hi guys
I seem to be having a bit of trouble deploying my reports from my Reporting Services Project in Visual Studio to my Sharpoint server.
Both the reporting server and sharepoint are installed on the same server.
The settings within my reporting server are as follows (where report is the site name):
TrargetDataSourceFolder - https://server/Report/Shared Documents/DataSources
TrargetReportFolder - https://server/Report/Shared Documents
TrargetServerURL - https://server/Report
I have not yet changed over all my reports to use fully qualified urls yet. As we have multiple domains in which the reports need to go through before they hit the production server and i haven't yet decided how i am going to handle the issues of the reports requiring fully qualified addresses (if someone has a way i would love to know).
I was getting the following error when i tried to deploy the projects but i delete all extensions from the blocked file types and that error went away. I can only guess that there was a file type it didn't like.
Error - "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators."
When i deleted all the file extensions i now get the following error.
Error - "File Not Found."
Just wondering if anyone has had any success with visual studio and sharepoint deployment or run into this problem.
Thanks
Anthony
Hello,
I am passing the partameters to MS Report Viewer control to view the report. It is working fine with normal parameters like 'abc', 'Jon' etc.
But fails with parameters having special characters like 'abc+', 'Version 1.1 Part 1', 'R1.8 RC' throws error "
The parameter is missing a value"
Could anyone please help on this.
Thanks,
Chandroday
I used the following reference code while creating this simple ASPX page with reportviewer control using VS 2005
http://www.tutorialsall.com/REPORTINGSVCS/WebFormsReportViewer-ReportServerCredentials/
ReportViewer is having following properties
ProcessingMode = "Remote",
ReportServerUrl = "/foldername/myreport
ReportPath = "http://report.mydomain.com/reports"
Even after using admin user we got the same problem
Please help
I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.
Below is the message detail:
A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)
Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?
Regards,
Gunady Ng
whenever I try to create a PowerView report on an existing powerpivot- excel sheet I get following error:"An error occurred while loading the model for the item or data source 'xxx'. Verify that the connection information is correct and that you have permissions to access the data source."Â Error details:
<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://intranet/PowerPivot/PowerPivot-Galerie/Mappe1.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.</Message>
[code]...
When I try to open the PowerPivot sheet form Power Pivot Gallery and click on any filter I receive following message:Â An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: PowerPivot Data.
Hi,
I am receiving the following error when I run the report builder query. I am able to successfully select the dimensions and measures that I am intrested in but when I run the report I get the error message.
The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
----------------------------
Semantic query execution failed.
----------------------------
Query execution failed for data set 'dataSet'.
----------------------------
An error has occurred during report processing.
I am testing this against both Adventureworks standard and enterprise cubes. Additionality I saw a post in this forum
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
that seemed related but I am using reporting services in sharepoint integrated mode so I am having a hard time trying to troubleshoot this.
Thanks,
Larry
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.
Thanks
Shankar
Can a person change the page title from "Report Viewer/Manager" to the actual report name?
View 3 Replies View RelatedHello,
Very strange phenomenon with the "Jump to report:" Hyerlink Actions when I deployed my reports to the production servers:
The Actions no longer funcioned properly when attempting to go to one report to another. Sometimes, the same report would come up and sometimes a different report. It appeared that whatever mechanism Report Server uses to construct the proper URL when using "Jump to report:" is unreliable(or the URL is not being honored by the web-server).
All this is happening under the Report Viewer control. I have had to do a painful fix of manually constructing the entire absolute URL and including the reportviewer control in the url.
Any way to get back relative Jump to report: URL's?
Thanks JS
We are generating excel report using report viewer at run time but if excel report having more then 65000 record generating error Microsoft. Reporting Services.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceed.
View 2 Replies View RelatedHi ,
I have a problem using Report Viewer With SQL Reporting Services 2005.
I had a really weird issue with a ReportViewer. It would show the little green Loading progress bar image €¦ but it wouldn€™t show any data, just a white background where the output should be. I knew the data was there because exporting to Excel or PDF showed the data just fine.
The problem is report toolbar is display but NO DATA is displayed and the report comes out as EMPTY .
Thanks in advance..
Can you please help me out in resolving this problem.
Hi,
I want to give filtering criteria in my SSRS report.
I have drop down list control having list of Email's of clients.
So, how can i pass the value of the particular Email id in my SSRS report using Report Viewer control?
How can i pass user input as parameter in my report using visula studio 2005?
Thanx,
Ruja
Hello,
I'm using Reporting Services to render a text (stored in sql as varchar(max)). The text is all plain text, with some lines having trailing spaces.
Source text file i've imported to SQL via SSIS:
CLIENT: 10055
STATEMENT 2007
DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1 COLUMN2 COLUMN 3
TRY THIS
*Note the trailing spaces on the line before 'STATEMENT 2007'.
I've designed a report using the Report Project in VS2005 to retrieve this text via a stored procedure. When I test the report using the 'Preview' tab in the IDE, it looks good
CLIENT: 10055
STATEMENT 2007
DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1 COLUMN2 COLUMN 3
TRY THIS
But when I deploy the report and run it using URL Access:
CLIENT: 10055
STATEMENT 2007
DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1 COLUMN2 COLUMN 3
TRY THIS
On all lines with trailing spaces, they (the trailing spaces) have been removed. This is affecting my formatting of some reports and statements. We really want to use the report viewer as it has built in paging, print and export capabilities.
Why does it look okay in VS2005 but different in Report Viewer via URL Access and Report Manager?
Note: When I export as PDF, it looks okay.
The stored procedure I use to return the data is a CLR Hosted assembly as below:
Code Snippet
Partial Public Class StoredProcedures
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub GetPagedDocument(ByVal inText As SqlString)
Dim dr As SqlDataReader
Dim row As New SqlDataRecord(New SqlMetaData("RowText", SqlDbType.Text))
Dim cmd As New SqlCommand("select cast(doc as varchar(max)) as 'DOCTEXT' from testdoc WHERE id='" + inText + "'")
Dim cn As New SqlConnection("context connection=true")
cn.Open()
cmd.Connection = cn
SqlContext.Pipe.SendResultsStart(row) 'initialise the resultset to be returned
dr = cmd.ExecuteReader
'If no records in result set, return.
If Not dr.HasRows Then
row.SetString(0, "There is no document to display or you do not have permission to view the document.")
SqlContext.Pipe.SendResultsRow(row)
SqlContext.Pipe.SendResultsEnd()
' SqlContext.Pipe.Send("There is no document to display.")
Return
End If
'Read rows in the result set
dr.Read()
'Get the entire text
Dim docText As String = dr.Item("DOCTEXT")
'debug
row.SetString(0, docText)
SqlContext.Pipe.SendResultsRow(row)
SqlContext.Pipe.SendResultsEnd()
Return
'end debug
End Sub
End Class
Any help will be appreciated.
i just clicked on Advanced mode in Column Group, and then in Row Group Side i set Fixed Data=true for first top static. I'm using local report not server report and i'm displaying that local report in Reportviewer. Now also its not working....
View 6 Replies View RelatedHi,
I am having hard time in sending parameters to the report server through reportviewer control from my application. Could anybody help me on this issue?. Is there any way to send the parameters and also what kind of configuration do i need on my report project so that it can accept parameters from my application.
Thanks,
Do I need the report server running in order view a SSRS report in a report viewer control? I've created my report in .net and it works great when I'm viewing it in visual studio, but can I run it my web app without the report server.
View 1 Replies View RelatedI just installed a fresh lab machine with WSS 3.0 and SQL 2005 SP1. I registered the RS web parts.
In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.
When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.
If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.
Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.
Thanks,
Joe
Here is a situation in my company:
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?