Saturday, December 31, 2011

Enable ASP.NET Session State By Program

A blog Acticle by Abhijit, telling how to build a HttpModule for .Net 4.0 to enable or disable Session State for the Pages that need it or the whole site.
the article is here.

Tuesday, December 27, 2011

Reporting Services Timeout Settings

Location of Report Web Directory : C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager

copied from an answer by Ryna Shripat on StackOverflow here:

You can fiddle with any of the following:

1) Modify SessionTimeout and SessionAccessTimeout system properties.

Here is a sample script for rs.exe which will set these values for you:

Public Sub Main()      Dim props() as [Property]      props = new [Property] () { new [Property](), new [Property]() }      props(0).Name = "SessionTimeout"      props(0).Value = timeout      props(1).Name = "SessionAccessTimeout"      props(1).Value = timeout      rs.SetSystemProperties(props) End Sub  

You can run this script with the following command:

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"The timeout is expressed in seconds, so this example sets the SessionTimeout and SessionAccessTimeouts to about an hour and a half.

(via http://blogs.msdn.com/b/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx)

2) Change Report Execution Timeout via Report Manager Open Report Manager At the top of the page, click Site Settings. This opens the General Properties page of the site.

Report Execution Timeout Specify whether report processing times out after a certain number of seconds. (viahttp://msdn.microsoft.com/en-us/library/ms181194.aspx)

3) Set the HttpRuntime ExecutionTimeout

  1. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services.
  2. From there, expand Web Sites -> Default Web Site, and click on ReportServer. On the right-hand pane, right-click ‘Web.Config’ and select ‘Open’.
  3. Locate the HttpRuntime parameter. If it doesn’t exist, you will have to create it within the section.
  4. Set the executionTimeout value to ‘10800’ (3 hours) as shown below:
       

4) Increase the script timeout on the report server

  1. Go onto your Reporting Server and open up Internet Information Services; right-click on the ReportServer and select Properties.
  2. Go to the Options tab, and set the ASP Script timeout to 300 seconds (this didn't really work for me).

5) Set the report to never time out on the server

  1. Open your web browser on the server and go to http://localhost/Reports
  2. Navigate to the Report location and click on the problem report(s).
  3. On the left-hand pane, click on Properties.
  4. In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’. (viahttp://geekswithblogs.net/ssrs/archive/2009/10/30/steps-to-resolve-ssrs-timeout-issues.aspx)

Monday, December 26, 2011

Publishing Reports to the CRM Server

Customer Effective Blog on Restoring SSRS Server and Publishing reports

SimpleTals Blog on Reporting Services

Ryan Duclus wrote a post on Reporting Servics with some nice solutions, including repeating row header for every page a how to create a calendar like report. it is recommended reading : Ten Common SQL Server Reporting Services Challenges and Solutions by .
The SimpleTalk Blog has all the reporting services related artices here. some very advanced solutions but essetial for good reporting generation.

Thursday, December 1, 2011

CRM 2011 IFD and AS FS2.0 Resources

Configuring IFD with Microsoft Dynamics CRM 2011 on MS Blog
Microsoft Dynamics CRM 2011 Implementation Guide explanation on the Document
Introducing Microsoft Dynamics CRM 2011 Claims-based Authentication - Movie on Youtube, starts at installing AD FS, made by MS Tech.
Microsoft CRM 2011 How to Configure IFD Hosted Setup - detailed script at InteractiveWebs Blog, following all the steps needed including the definition of a SSL certificate.




Sunday, November 13, 2011

Blogs Posts on CRM 2011 Charts

Richard writes an intro on the new chart features of the CRM and how to use them on his blog post : Dynamics CRM 2011 Charts, Views and Data Grids

Another post by the CRM Team with XML Editing is Here

Sunday, October 16, 2011

XML Schema and Chart Samples for CRM on MSDN

Smaples:
http://msdn.microsoft.com/en-us/library/ee704599.aspx
Visualization Data Description Schema for XML

Chart Samples for CRM on MSDN

Document on MSCRM SDK : Visualization (Chart) Samples

Customer Effective Blog with many examples on CRM 2011

link to the blog is this : Customer Effective Blog
It has samples and explanations on:
  1. Form Printing.
  2. Form Customization
  3. Changing Form appearance
  4. Duplicate Detection and Fuzzy Logic
  5. Using FetchXml from JavaScript
  6. Sorting Chart on an aggregated Value.
  7. Explanation of Field Level Security
  8. Working with Multi Value Parameter in SSRS

A tool to edit the Ribbon and a SiteMap Editor

Here is a tool on CodePlex to do the pain in the neck activities on the CRM:
MS CRM 2011 : Pragma Toolkit : Ribbon, Site Map Editor

Sunday, October 9, 2011

The Javascript Grid Editor

There is a Havascript library to edit CRM Records on a the Grid.
It is Opensource and created by CRMEntropy, here : http://crmgrideditor.codeplex.com/

Customer Care Solution by Microsoft

http://dynamics-crm.pinpoint.microsoft.com/en-us/applications/customer-care-accelerator-for-microsoft-dynamics-crm-2011-12884914795

Showing Alerts on CRM Form notification Area using JScript

it is possible to Add alerts to the Alert list control on a form.
The code is very simple :

The Alerts are ordered by priority.

var mep=1;

function set_alert()
{
var notificationsArea = document.getElementById('crmNotifications');
if (notificationsArea == null)
{
alert('div not found');
return;
}

if (mep==1)
{
notificationsArea.AddNotification('mep2', 2, 'source', 'Warning message');
notificationsArea.AddNotification('mep3', 3, 'source', 'Info message');
notificationsArea.AddNotification('mep1', 1, 'source', 'Critical message');
mep=2;
}
else
{
notificationsArea.SetNotifications(null, null);
mep=1;
}
}