Advanced Reports
Manage: All Custom Reports
You can create an advanced report that includes:
- Multiple levels of headings and subtotals.
- Related business objects.
- Sub filters.
You can also use one or more advanced reports in composite reporting as sub reports.
Advanced reports enable you to perform many actions on your data from primary business objects and related business objects, including:
- Counting
- Grouping
- Summarizing
- Totaling
You can include fields from the related business objects directly in your report without needing a calculated field. The fields from the related business objects must directly relate to the primary business object.
Some use cases for advanced reports include:
- Computing the average, minimum, or maximum value of currency and numeric fields.
- Creating outlines.
- Displaying grand totals and subtotals based on the group hierarchy setup in the report.
- Filtering and sorting data.
- Grouping data up to 9 levels.
- Including group headers and group names in your report to separate your data logically based on the group level hierarchy.
- Summarizing detail data rows.
- Summarizing or totaling currency and numeric fields based on the primary business object.
- Using 1 or more advanced reports as subreports in composite reporting.
Pradeep can you please post a sample report based on advance and standard.
ReplyDeleteSure, If not the screenshot, I will post the excel sheet which should tell you the report details.
DeleteHi Pradeep, Great Article... Thank you.
ReplyDeleteCan you please explain more about Display Header which is in Sort tab in the report definition.
Hi Thanks for your comment.
DeleteYou use Display Header in the sort tab, if you want to see the summation of numbers / currency values. Please make sure you have opted for one ore more fields with aggregate function in your columns tab, else it will throw an error if you are just checking the Display Header Check box.
Thanks,
LoveWorkday