‏إظهار الرسائل ذات التسميات SSRS. إظهار كافة الرسائل
‏إظهار الرسائل ذات التسميات SSRS. إظهار كافة الرسائل

الخميس، 1 ديسمبر 2016

SSRS: ASP.Net ReportViewer control doesn't appear in Chrome or Safari

To solve this issue you have two solution as below:
1- Just include SizeToReportContent="true" as shown below
<rsweb:ReportViewer ID="ReportViewer1" runat="server" SizeToReportContent="True"...

2- Use the following JQuery code in the ASPX page:
<script type="text/javascript"> $(function () { // Bug-fix on Chrome and Safari etc (webkit) if ($.browser.webkit) { // Start timer to make sure overflow is set to visible setInterval(function () { var div = $('#<%=ReportViewer1.ClientID %>_fixedTable > tbody > tr:last > td:last > div') div.css('overflow', 'visible'); }, 1000); } }); </script>

الخميس، 26 سبتمبر 2013

The permissions granted to user 'domain\username' are insufficient for performing this operation. (rsAccessDenied)

To Solve this problem do the following:
1- Run IE as Administrator.
2- Open Reporting Service configuration Manager.
3- Click Report Manager URL and open this URLs.
4- Click Folder Setting.
5- Add New Role Assignment with Selecting all roles.
 Now this message will not appeare again.

الاثنين، 23 سبتمبر 2013

CRM 2011:Web service request SetDataSourceCredentials to Report Server http://ServerName/ReportServer failed with SoapException

This error occur when you try to open report in CRM,to solve this problem do the following:
  1. Give the NetworkService the role Owner and CRMReaderRole in MSCRM_Config Database and your Organization Database.


- Open Reporting Service Configuration Manager and add the current user to Role assignment
- Remove the execution account.





الثلاثاء، 20 أغسطس 2013

SSRS: Cannot create a connection to data source ‘CRM.’ (rsErrorOpeningConnection) Guid should contain 32 digits with 4 dashes


To run the report from the report server Url, you might find that if you are using normal domain account for username/password you will get the following error:


An error has occurred during report processing (rsProcessingAborted) Cannot create a connection to data source ‘CRM.’ (rsErrorOpeningConnection) Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

This is because the Username should be 'systemuserid' and the Password should be 'organizationid'. You can get this by running the query against the CRM database:


SELECT fullname, systemuserid, organizationid FROM FilteredSystemUser Order By fullname

السبت، 6 يوليو 2013

Report render failure. Error: An error has occurred during report processing. (rsProcessingAborted)

setspn -L ADGROUP\dynamicsadmin

setspn -L ADGROUP\CRMSandbox

setspn -A http/WIN2K8-SQL2K8 ADGROUP\dynamicsadmin

setspn -A http/WIN2K8-SQL2K8.fqdn.com ADGROUP\dynamicsadmin

-- Also if the error contains the below details.

"System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://ed-crmweb01/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0468750. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.29.3.4:808. "

Then try adding an inbound rule to the Windows firewall allowing TCP traffic on port 808, domain network. 


Also you will find a full solutions on the following link:
http://blog.cobalt.net/blog/4-steps-that-will-help-you-conquer-the-rsprocessingaborted-error

The report server cannot decrypt the symmetric key used to access sensitive

1-Open Reporting Services Configuration Manager

2-Connect to your RS server

3-Select 'Encryption Keys' from the left pane

4-Press the 'Delete' button to get rid of your encrypted content 

5-After doing this, you will need to re-set the connection strings and stored credentials on your reports.

السبت، 8 يونيو 2013

How to Repeat Table(Tablix) Header on each Page in SSRS 2008

 To Repeat Table(Tablix) Header on each Page in SSRS 2008 do the following:
1- Click the first cell in table header.




2- From the Row Group click Static and go to properties.


















3- From properties window set the (KeepWithGroup=After) and (RepeatOnNewPage=true).