Answered by:
SSRS reporting in CRM 2011

Question
-
Hi All,
I am in the development Phase of CRM system and very new to CRM and CRM SSRS reporting, would like to know some SSRS reporting question .
I am using one custom enitity to capture Order received date and there is another enitity which is contains some date information related to order .
Is it possible in crm to join these 2 entities in crm to calculate no of days between 1st entity data and 2nd entity date .
Please guide me the extensibility of CRM reporting tool.
Cheers,
S
Sunday, July 3, 2011 1:21 PM
Answers
-
Yes it is possible you can join entities (via Link-Entity). CRM 2011 reporting uses FetchXml (in case of on-premise and online) or Filtered Views (in case of on-premise oinly) and you can join in fetchxml and as well as FIltered Views, Fetch Xml example:
<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
<entity name='team'>
<attribute name='name' />
<attribute name='businessunitid' />
<attribute name='teamid' />
<order attribute='name' descending='false' />
<link-entity name='teammembership' from='teamid' to='teamid' visible='false' intersect='true'>
<link-entity name='systemuser' from='systemuserid' to='systemuserid' alias='user'>
<filter type='and'>
<condition attribute='systemuserid' operator='eq' value='{0}' />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>or you may also refer: http://technet.microsoft.com/en-us/library/gg328117.aspx
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".- Proposed as answer by Jehanzeb.Javeed Sunday, July 3, 2011 6:04 PM
- Marked as answer by SSQLL Sunday, July 3, 2011 7:25 PM
Sunday, July 3, 2011 6:03 PM -
Hi Jehanzeb,
My question is "Is it possible to join 2 diffrent entities for reporting purpose in crm ? "
Cheers
- Marked as answer by SSQLL Friday, August 12, 2011 8:49 AM
Sunday, July 3, 2011 5:43 PM
All replies
-
Hi,
Follow the instruction at the following blog post for creating a new report (http://blogs.msdn.com/b/crm/archive/2010/10/26/how-to-creating-custom-report-with-microsoft-dynamics-crm-2011-bids-fetch-extension.aspx)
In SQL Reporting Services you can apply any formula in the coumn value. After adding the column right click on the coumn click expression and use the DateDiff formula i.e. = DateDiff(column1, coumn2)
You can also refer the following Urls for CRM 2011 Reports development
http://blog.rahulsharma.in/2011/04/microsoft-dynamics-crm-2011-fetch-xml.html
http://axforum.info/forums/showthread.php?t=37652
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".- Proposed as answer by Jehanzeb.Javeed Sunday, July 3, 2011 3:59 PM
Sunday, July 3, 2011 3:59 PM -
Hi Jehanzeb,
My question is "Is it possible to join 2 diffrent entities for reporting purpose in crm ? "
Cheers
- Marked as answer by SSQLL Friday, August 12, 2011 8:49 AM
Sunday, July 3, 2011 5:43 PM -
Yes it is possible you can join entities (via Link-Entity). CRM 2011 reporting uses FetchXml (in case of on-premise and online) or Filtered Views (in case of on-premise oinly) and you can join in fetchxml and as well as FIltered Views, Fetch Xml example:
<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
<entity name='team'>
<attribute name='name' />
<attribute name='businessunitid' />
<attribute name='teamid' />
<order attribute='name' descending='false' />
<link-entity name='teammembership' from='teamid' to='teamid' visible='false' intersect='true'>
<link-entity name='systemuser' from='systemuserid' to='systemuserid' alias='user'>
<filter type='and'>
<condition attribute='systemuserid' operator='eq' value='{0}' />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>or you may also refer: http://technet.microsoft.com/en-us/library/gg328117.aspx
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".- Proposed as answer by Jehanzeb.Javeed Sunday, July 3, 2011 6:04 PM
- Marked as answer by SSQLL Sunday, July 3, 2011 7:25 PM
Sunday, July 3, 2011 6:03 PM