Answered by:
How to create a report in crm 4?

Question
-
Hi All,
Can anyone please tell me how to create a report in crm 4 and explain about the feilds (Categeories,RelatedRecordTypes and Display In)?
Saturday, June 11, 2011 1:38 PM
Answers
-
Hi,
Reports Area means Reports List Page (Workplace->My Work-> Reports). If you will not choose Reports Area in Display In then report will not show in Reports List Page (Report Area is just a flag that system uses in the standard reports list page views to show/hide report, if you you will create a new list page view then it might show that report)
I hope this answers your question.
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 Monday, June 13, 2011 5:40 AM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:33 PM
Monday, June 13, 2011 5:40 AM -
Hi,
You can refer to the following links for step by step custom report development guide using SSRS:
http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx
http://nitindhawan.wordpress.com/2009/06/18/create-crm-custom-report/
http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx
I beleive the above web links will help you in creating SSRS report step by step.
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 Monday, June 13, 2011 5:02 PM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:33 PM
Monday, June 13, 2011 5:02 PM -
Hi,
There are two types of views in Dynamics CRM 1. System Views and 2. Personal Views .
System views are globalized entity views that are shared with all users and can not be restricted via security. Can be created from Entity Customization and include Lookup, Assositated, Quick Find, Preview and Public Views.
Personal Views are personal entity view can be created using Advanced Find and also can be assigned and shared with other users. For further details on advance you may refer to the following links:
http://rc.crm.dynamics.com/rc/regcont/en_us/op/help/source_find_AdvFind_CreateNew.htm
http://www.youtube.com/watch?v=XT2A79onZFM
http://channel9.msdn.com/Blogs/jodonnell/Microsoft-Dynamics-CRM-40--Advanced-Find-with-John-ODonnell
http://www.dynamicscare.com/blog/index.php/dynamics-crm-sharing-vs-assigning-advanced-find-views/
I hope this answers your question.
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 Monday, June 13, 2011 5:37 PM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:33 PM
Monday, June 13, 2011 5:37 PM -
Hi,
Quick Find View
Quick Find Views is a system view and allows you to search from the entity list view page (CRM main entity page) and you can customize the search critera as well as columns to be displayed in result (You can cusotmize Quick Find Views from Entity Customization->Views) if user will search from the entity list view page then CRM will search for those attributes which are marked for searching in Quick Find View. This view is shared between all user who have access to entity. Its more like a quick search available for entities on the entity list page. You can access Quick Search text box in almost every Cucstomizable CRM entity list page.
Advance Find
Users can use Advance Find to create personal views that contains entity any attribute and its related entity attribute search criteria, can be Grouped together with Or and And conditions. Users can also customize the result displayed columns and can directly export the result data into excel . User can share and assign these view to other users. You can define Advance Find views for all cusotmizable entities. Each entity have its Personal and System views. There is no globalized search available in CRM that allows to search across all entities records in CRM. Advance find only allow you to search for a particular entity all records. You can access the Advance Find form the CRM Home Page Tool Bar. Personal views can only be edited using Advance Find.
With Advance Find user can create views with different search crtiterias i.e. Can search Accounts by City, Country, Name, Email Address, Accounts that have no activity performed since last 3 months (neglected from past three months), Accounts that have no complaints since past 1 months etc.
If the search is required to be performed on multiple criterias then use Advance Find or if only to search by a single attribute then use Quick Find Search (Search Text Box on Entity List Page)
You can use above links to read more about Advance Find and Quick Find views functionality.
I believe this will answer your question.
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 Tuesday, June 14, 2011 6:22 AM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:34 PM
Tuesday, June 14, 2011 6:22 AM
All replies
-
Hi,
You may refer to the following link for further details on creating a custom report for CRM 4.0 via SQL Server Reporting Services:http://edwardsdna.wordpress.com/2010/03/10/create-a-custom-quote-order-or-invoice-report-for-your-customers/
http://blogs.msdn.com/b/ceibner/archive/2009/07/28/building-a-crm-4-0-report-that-will-be-accessed-via-an-iframe.aspx
http://blogs.msdn.com/b/crm/archive/2008/11/10/reports-for-crm-4-0-using-sql-server-2008-and-report-builder-2-0.aspx
http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspxWhile uploading an existing or creating a new report you can specify the following parameters in Categorization section:
Categories
In Categories, you can specify report category i.e. Sales Reports, Marketing etc. to arrange reports group wise. You can add more categories as per required from Settings->System->Administration->System Settings->Reporting
Related Record Types
In Related Record Types, you can specify related CRM records that are associated with this report i.e. Accounts, Contacts, Leads etc.
Display In
In Display In, you can Select Whether the current report run shortcut will be display in Form, Entity Homepage Grid (Entity List Page) or Reports Area
I hope your question is anwered.
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 Saturday, June 11, 2011 2:22 PM
Saturday, June 11, 2011 2:22 PM -
Hi,
Thanks for our reply. what do you mean by "Report Area" rest of the things I got it. Once again thanks for your reply.
Monday, June 13, 2011 12:52 AM -
Hi,
Reports Area means Reports List Page (Workplace->My Work-> Reports). If you will not choose Reports Area in Display In then report will not show in Reports List Page (Report Area is just a flag that system uses in the standard reports list page views to show/hide report, if you you will create a new list page view then it might show that report)
I hope this answers your question.
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 Monday, June 13, 2011 5:40 AM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:33 PM
Monday, June 13, 2011 5:40 AM -
Hi,
Thanks, Yeah, I got it. Can you please give me some example of custom reports by using SSRS reports. Once again thanks for reply.
Monday, June 13, 2011 4:45 PM -
Hi,
You can refer to the following links for step by step custom report development guide using SSRS:
http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx
http://nitindhawan.wordpress.com/2009/06/18/create-crm-custom-report/
http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx
I beleive the above web links will help you in creating SSRS report step by step.
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 Monday, June 13, 2011 5:02 PM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:33 PM
Monday, June 13, 2011 5:02 PM -
Hi,
Thanks for your immediate response. I will go through those links and let you know if have any doubts. Before can you please explain the views and types of views specifically (Advanced find view). where I can see the Advanced find view records means forms???
Monday, June 13, 2011 5:10 PM -
Hi,
There are two types of views in Dynamics CRM 1. System Views and 2. Personal Views .
System views are globalized entity views that are shared with all users and can not be restricted via security. Can be created from Entity Customization and include Lookup, Assositated, Quick Find, Preview and Public Views.
Personal Views are personal entity view can be created using Advanced Find and also can be assigned and shared with other users. For further details on advance you may refer to the following links:
http://rc.crm.dynamics.com/rc/regcont/en_us/op/help/source_find_AdvFind_CreateNew.htm
http://www.youtube.com/watch?v=XT2A79onZFM
http://channel9.msdn.com/Blogs/jodonnell/Microsoft-Dynamics-CRM-40--Advanced-Find-with-John-ODonnell
http://www.dynamicscare.com/blog/index.php/dynamics-crm-sharing-vs-assigning-advanced-find-views/
I hope this answers your question.
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 Monday, June 13, 2011 5:37 PM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:33 PM
Monday, June 13, 2011 5:37 PM -
Hi,
Thanks, But I wanna know the Advanced find view for example take quick find view (For every entity Ex: Account Entity you wanna search the record at that time you will find quick find view like that where can I see the Advanceed find view. Once again thanks for your reply.
Tuesday, June 14, 2011 1:00 AM -
Hi,
Quick Find View
Quick Find Views is a system view and allows you to search from the entity list view page (CRM main entity page) and you can customize the search critera as well as columns to be displayed in result (You can cusotmize Quick Find Views from Entity Customization->Views) if user will search from the entity list view page then CRM will search for those attributes which are marked for searching in Quick Find View. This view is shared between all user who have access to entity. Its more like a quick search available for entities on the entity list page. You can access Quick Search text box in almost every Cucstomizable CRM entity list page.
Advance Find
Users can use Advance Find to create personal views that contains entity any attribute and its related entity attribute search criteria, can be Grouped together with Or and And conditions. Users can also customize the result displayed columns and can directly export the result data into excel . User can share and assign these view to other users. You can define Advance Find views for all cusotmizable entities. Each entity have its Personal and System views. There is no globalized search available in CRM that allows to search across all entities records in CRM. Advance find only allow you to search for a particular entity all records. You can access the Advance Find form the CRM Home Page Tool Bar. Personal views can only be edited using Advance Find.
With Advance Find user can create views with different search crtiterias i.e. Can search Accounts by City, Country, Name, Email Address, Accounts that have no activity performed since last 3 months (neglected from past three months), Accounts that have no complaints since past 1 months etc.
If the search is required to be performed on multiple criterias then use Advance Find or if only to search by a single attribute then use Quick Find Search (Search Text Box on Entity List Page)
You can use above links to read more about Advance Find and Quick Find views functionality.
I believe this will answer your question.
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 Tuesday, June 14, 2011 6:22 AM
- Marked as answer by Jim Glass Jr Wednesday, June 15, 2011 7:34 PM
Tuesday, June 14, 2011 6:22 AM -
Hi,
Thanks for your reply. How to create a roceord through organization. Whenever we are creating a record it will be created through user right. Can you please tell me how to create a record through organization level. What is the difference between these two. once again thanks for your reply.
Wednesday, June 15, 2011 4:44 PM -
Hi Javeed,
I am awaiting for your reply. I think you are busy with some other work. Please reply me when you have time. Thanks
Friday, June 17, 2011 12:59 AM