Create or edit a report using the Report Wizard
This article applies to Dynamics 365 Customer Engagement (on-premises) version 9.1 using the legacy web client. If you’re using Unified Interface, your apps work the same as Unified Interface for model-driven Power Apps. For the Power Apps version of this article, see: Create a report using the Report Wizard
All reports that are created using the Report Wizard are Fetch-based reports. Note that all reports generated with the Report Wizard print in landscape mode.
Go to Reports.
To add a new report, select New.
In the Report: New Report dialog box, in the Report Type list, select Report Wizard Report, and then select Report Wizard.
You can only use the Report Wizard to edit reports that were created with the wizard.
Select the starting point for your report.
To create a new report, select Start a new report.
- OR -
To start from a copy or edit an existing report, select Start from an existing report, and check the Overwrite existing report check box.
Select Next.
Enter the name of the report, and specify which record types the report will use.
This step identifies where the data in the report comes from. You can include data from one or two record types, or data from related records.
Enter data in the fields:
Report name. This value will be displayed in the reports area.
Primary record type. Data from all fields in this record type and related record types will be available when you are defining criteria for which records to include.
Related record type. If you need to display data from a related record type, select an additional record type here.
Caution
Avoid selecting data from a related record type that is not required, as it makes the report take longer to load.
Select Next.
Define a filter to determine which records are included in your report.
Organize and lay out your report data
For detailed information on laying out your report, see Organize and lay out your report data.
Select the basic format of the report.
Table only. This provides a table grouped and sorted as you specified.
Chart and table. Displays both a chart and table.
Show table below the chart on same page. Selecting the chart does nothing.
Show chart. To view data for a chart region, select the chart region. Selecting an area in the chart will display a table with details for that section of the chart.
Select Next.
Include a chart in the report
If the report includes a chart, specify the type of chart, and how the data is displayed in the chart.
Select the chart type, and then select Next.
The Chart preview area shows how the data will be displayed.
For vertical and horizontal bar charts and line charts, specify which data to display on each axis:
In the Format Column (X) Axis section, select the field to use for the X axis, and the label that is displayed on the chart for the field.
In the Format Value (Y) Axis section, you can select two fields. For each field, you can specify the label that is displayed on the chart.
In the Format Labels and Legends section, specify whether or not to show the data labels and a legend.
For pie charts, specify the slices and values for the chart.
For slices, you must select one of the groupings in your report.
For values, you must select a numeric column with a summary type.
Select Next.
Finish, test and refine the report
After you finish defining the report, return to the Report form, and if required, update the name and description of the report, and determine where the report is displayed.
Review the summary of the report, select Next, and then select Finish.
Test the report. On the reports tab, in the Actions group, select Run Report. If the report needs modifications, edit the report.
Make the report available to others for use. More information: Determine who can use a report
Edit a report
To edit an existing Report Wizard report, first select the report. Then, in the Records group, select Edit. Finally, select Report Wizard.
If you need to change data on the General or Administration tabs for a new report, wait until the report is saved before making the changes. Any changes on these tabs made before a report is saved will be ignored.
This topic applies to Dynamics 365 Customer Engagement (on-premises). For the Power Apps version of this topic, see: Create a report using the Report Wizard
All reports that are created using the Report Wizard are Fetch-based reports. Note that all reports generated with the Report Wizard print in landscape mode.
Go to Reports.
To add a new report, select New.
In the Report: New Report dialog box, in the Report Type list, select Report Wizard Report, and then select Report Wizard.
You can only use the Report Wizard to edit reports that were created with the wizard.
Select the starting point for your report.
To create a new report, select Start a new report.
- OR -
To start from a copy or edit an existing report, select Start from an existing report, and check the Overwrite existing report check box.
Select Next.
Enter the name of the report, and specify which record types the report will use.
This step identifies where the data in the report comes from. You can include data from one or two record types, or data from related records.
Enter data in the fields:
Report name. This value will be displayed in the reports area.
Primary record type. Data from all fields in this record type and related record types will be available when you are defining criteria for which records to include.
Related record type. If you need to display data from a related record type, select an additional record type here.
Caution
Avoid selecting data from a related record type that is not required, as it makes the report take longer to load.
Select Next.
Define a filter to determine which records are included in your report.
Organize and lay out your report data
For detailed information on laying out your report, see Organize and lay out your report data.
Select the basic format of the report.
Table only. This provides a table grouped and sorted as you specified.
Chart and table. Displays both a chart and table.
Show table below the chart on same page. Selecting the chart does nothing.
Show chart. To view data for a chart region, select the chart region. Selecting an area in the chart will display a table with details for that section of the chart.
Select Next.
Include a chart in the report
If the report includes a chart, specify the type of chart, and how the data is displayed in the chart.
Select the chart type, and then select Next.
The Chart preview area shows how the data will be displayed.
For vertical and horizontal bar charts and line charts, specify which data to display on each axis:
In the Format Column (X) Axis section, select the field to use for the X axis, and the label that is displayed on the chart for the field.
In the Format Value (Y) Axis section, you can select two fields. For each field, you can specify the label that is displayed on the chart.
In the Format Labels and Legends section, specify whether or not to show the data labels and a legend.
For pie charts, specify the slices and values for the chart.
For slices, you must select one of the groupings in your report.
For values, you must select a numeric column with a summary type.
Select Next.
Finish, test and refine the report
After you finish defining the report, return to the Report form, and if required, update the name and description of the report, and determine where the report is displayed.
Review the summary of the report, select Next, and then select Finish.
Test the report. On the reports tab, in the Actions group, select Run Report. If the report needs modifications, edit the report.
Make the report available to others for use. More information: Determine who can use a report
Edit a report
To edit an existing Report Wizard report, first select the report. Then, in the Records group, select Edit. Finally, select Report Wizard.
If you need to change data on the General or Administration tabs for a new report, wait until the report is saved before making the changes. Any changes on these tabs made before a report is saved will be ignored.