Generate Reports In No Time With Microsoft Dynamic Crm
0 views
Skip to first unread message
Sayed Ally
Mar 25, 2013, 10:50:03 AM3/25/13
to publish-the...@googlegroups.com
*****************************************************************
Message delivered directly to members of the group:
publish-the...@googlegroups.com
*****************************************************************
Please consider this free-reprint article written by:
Sayed Ally
*****************************
IMPORTANT - Publication/Reprint Terms
- You have permission to publish this article electronically in free-only publications such as a website or an ezine as long as the bylines are included.
- You are not allowed to use this article for commercial purposes. The article should only be reprinted in a publicly accessible website and not in a members-only commercial site.
- You are not allowed to post/reprint this article in any sites/publications that contains or supports hate, violence, porn and warez or any indecent and illegal sites/publications.
- You are not allowed to use this article in UCE (Unsolicited Commercial Email) or SPAM. This article MUST be distributed in an opt-in email list only.
- If you distribute this article in an ezine or newsletter, we ask that you send a copy of the newsletter or ezine that contains the article to http://www.isnare.com/eta.php?aid=144931
- If you post this article in a website/forum/blog, ALL links MUST be set to hyperlinks and we ask that you send a copy of the URL where the article is posted to http://www.isnare.com/eta.php?aid=144931
- We request that you ask permission from the author if you want to publish this article in print.
The role of iSnare.com is only to distribute this article as part of its Article Distribution feature ( http://www.isnare.com/distribution.php ). iSnare.com does NOT own this article, please respect the author's copyright and this publication/reprint terms. If you do not agree to any of these terms, please do not reprint or publish this article.
*****************************
Article Title: Generate Reports In No Time With Microsoft Dynamic Crm
Author: Sayed Ally
Word Count: 464
Article URL: http://www.isnare.com/?aid=144931&ca=Internet
Format: 64cpl
Contact The Author: http://www.isnare.com/eta.php?aid=144931
Easy Publish Tool: http://www.isnare.com/html.php?aid=144931
*********************** ARTICLE START ***********************
You can generate database reports quickly and easily with special features of Microsoft Dynamic CRM software. The reports can quickly be written and added to Microsoft Dynamic CRM. You need to first make sure that you have all of the required collateral software, such as MS SQL Server 2003 or 2005. Consult your manual to make sure you have all that you need for generating Microsoft Dynamic CRM reports.
You probably do have it all, so let�s assume that you do. To prepare a report�s generation, first keep in mind that you want to use filtered views, not tables. That is, when you select the data source for your report, use the filtered views that are in the Microsoft Dynamic CRM database instead of the database tables. The reason for this is that filtered views are more secure and they are more efficient. Each individual�s Microsoft CRM security roles determine which of the records are returned by a query to a filtered view. Thus, reports that are based on filtered views only show users the records that they have permission to view.
Next, make the report prefilterable. When you write a report, you can set it up so that it has a default filter for each individual user to be able to edit before generating the report. This is known as making the report �prefilterable�. Making reports this way gives you a couple of advantages. For one thing, the user can edit the filter to find the precise he needs right away without multiple guessing efforts. And for another thing, the default filter stops users from accidentally generating the report based on all records.
In order to make a report �prefilterable� in Microsoft Dynamic CRM, you need to specify the prefix CRMAF_prefix in your SQL query when you are writing up your report in the Report Designer. Adding this prefix causes Microsoft CRM to add a default filter to the report. For every filtered view having this prefix in the query, users are able to edit the filter criteria. Criteria related to accounts can be edited but not criteria related to contacts.
And finally, make the report context-sensitive. There are three different areas from which to generate reports in Microsoft Dynamic CRM. One is from the Reports area, as part of the list of all reports. A second is from an �entity� list page like a Leads page for example, or from any Advanced Find view of the Leads. In this mode, users can select to generate reports based on selected records, all applicable records, or all records in the current view. And finally, there is the option of generating the report from an individual record, which is run on the current (viewed) record.
About The Author: Sayed Ally, is the lead CRM Analyst. His company provides, http://www.crmsoftwareprovider.com/. Sayed can be reached at Tel : (905) 815- 1995 ext 22, email: aSa...@cqsolutions.com
Please use the HTML version of this article at:
http://www.isnare.com/html.php?aid=144931
*********************** ARTICLE END ***********************
- To distribute your articles go to http://www.isnare.com/distribution.php
- For more free-reprint articles go to http://www.isnare.com
Message delivered directly to members of the group:
publish-the...@googlegroups.com
*****************************************************************
Please consider this free-reprint article written by:
Sayed Ally
*****************************
IMPORTANT - Publication/Reprint Terms
- You have permission to publish this article electronically in free-only publications such as a website or an ezine as long as the bylines are included.
- You are not allowed to use this article for commercial purposes. The article should only be reprinted in a publicly accessible website and not in a members-only commercial site.
- You are not allowed to post/reprint this article in any sites/publications that contains or supports hate, violence, porn and warez or any indecent and illegal sites/publications.
- You are not allowed to use this article in UCE (Unsolicited Commercial Email) or SPAM. This article MUST be distributed in an opt-in email list only.
- If you distribute this article in an ezine or newsletter, we ask that you send a copy of the newsletter or ezine that contains the article to http://www.isnare.com/eta.php?aid=144931
- If you post this article in a website/forum/blog, ALL links MUST be set to hyperlinks and we ask that you send a copy of the URL where the article is posted to http://www.isnare.com/eta.php?aid=144931
- We request that you ask permission from the author if you want to publish this article in print.
The role of iSnare.com is only to distribute this article as part of its Article Distribution feature ( http://www.isnare.com/distribution.php ). iSnare.com does NOT own this article, please respect the author's copyright and this publication/reprint terms. If you do not agree to any of these terms, please do not reprint or publish this article.
*****************************
Article Title: Generate Reports In No Time With Microsoft Dynamic Crm
Author: Sayed Ally
Word Count: 464
Article URL: http://www.isnare.com/?aid=144931&ca=Internet
Format: 64cpl
Contact The Author: http://www.isnare.com/eta.php?aid=144931
Easy Publish Tool: http://www.isnare.com/html.php?aid=144931
*********************** ARTICLE START ***********************
You can generate database reports quickly and easily with special features of Microsoft Dynamic CRM software. The reports can quickly be written and added to Microsoft Dynamic CRM. You need to first make sure that you have all of the required collateral software, such as MS SQL Server 2003 or 2005. Consult your manual to make sure you have all that you need for generating Microsoft Dynamic CRM reports.
You probably do have it all, so let�s assume that you do. To prepare a report�s generation, first keep in mind that you want to use filtered views, not tables. That is, when you select the data source for your report, use the filtered views that are in the Microsoft Dynamic CRM database instead of the database tables. The reason for this is that filtered views are more secure and they are more efficient. Each individual�s Microsoft CRM security roles determine which of the records are returned by a query to a filtered view. Thus, reports that are based on filtered views only show users the records that they have permission to view.
Next, make the report prefilterable. When you write a report, you can set it up so that it has a default filter for each individual user to be able to edit before generating the report. This is known as making the report �prefilterable�. Making reports this way gives you a couple of advantages. For one thing, the user can edit the filter to find the precise he needs right away without multiple guessing efforts. And for another thing, the default filter stops users from accidentally generating the report based on all records.
In order to make a report �prefilterable� in Microsoft Dynamic CRM, you need to specify the prefix CRMAF_prefix in your SQL query when you are writing up your report in the Report Designer. Adding this prefix causes Microsoft CRM to add a default filter to the report. For every filtered view having this prefix in the query, users are able to edit the filter criteria. Criteria related to accounts can be edited but not criteria related to contacts.
And finally, make the report context-sensitive. There are three different areas from which to generate reports in Microsoft Dynamic CRM. One is from the Reports area, as part of the list of all reports. A second is from an �entity� list page like a Leads page for example, or from any Advanced Find view of the Leads. In this mode, users can select to generate reports based on selected records, all applicable records, or all records in the current view. And finally, there is the option of generating the report from an individual record, which is run on the current (viewed) record.
About The Author: Sayed Ally, is the lead CRM Analyst. His company provides, http://www.crmsoftwareprovider.com/. Sayed can be reached at Tel : (905) 815- 1995 ext 22, email: aSa...@cqsolutions.com
Please use the HTML version of this article at:
http://www.isnare.com/html.php?aid=144931
*********************** ARTICLE END ***********************
- To distribute your articles go to http://www.isnare.com/distribution.php
- For more free-reprint articles go to http://www.isnare.com
Reply all
Reply to author
Forward
0 new messages