In this webinar, our experts showcase a variety of demo use cases of how different components of the...
Do you have a requirement to create a report to sum a calculated field in a report? Are you thinking that this can only be done through a custom SSRS report? Guess what, you can accomplish this using the out of box report wizard! Use the steps below to find the sum of revenue field in a report created using report wizard in Microsoft Dynamics CRM.
Step 1. Access the reports wizard in the reports section.
Step 2. Start a new report and click next
Step 3. Specify the name of the report and chose the record type.
Step 4. Specify the report filter criteria or specify the view to base the report on.
Step 5. Add column grouping and columns to the report. For the field that you would like to Sum on, chose the summary type on the properties of the column.
Step 6. Chose the format of the report.
Step 7. Validate the report summary and complete the wizard.
Hope this comes in handy. If you need additional tips and tricks on report writing, please feel free to check our very informative blogs or our CRM Book. In addition, the PowerObjects Education department is always churning out new Dynamics CRM material via webinars and boot-camp classes.
Happy CRM'ing!
I have 3 amount fields that I am reporting through report wizard in CRM 2015. Is it possible to add another column that totals the 3 fields? And then to do a grand total of this line level calculated field?
Hi Anton - If you have crm 2015 - you can do calculated fields. Then you can use a calculated field which is the summing field x + y + z in forms or views. https://powerobjects.com/blog/2014/11/17/calculated-fields-in-dynamics-crm-2015/
Thanks. But my question relates to reports produced in the wizard. I know how to use a field calculated in a form. Can I "create" a calculated field directly in the report?