> For the complete documentation index, see [llms.txt](https://docs.silverband.com.au/home/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder.md).

# Advanced Report Builder

This page will provide an overview on the advanced concepts of Report Builder

## Overview <a href="#overview" id="overview"></a>

Now that you have tried creating and saving basic reports using the Report Builder menu in Paradigm, you can build up your knowledge and generate complex reports that will address your accelerating reporting requirements. Report Builder is capable of formatting data, adding more complex conditions or filters, summarising data, and entering your own SQL code. Formatting the reports can also be done in a lot of different ways to address your business reporting requirements.

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2FPCMuArtz8WLrV0WhyoJl%2Fimage.png?alt=media&amp;token=3c647d6e-7121-4678-be41-5e18c7a92034" alt=""><figcaption></figcaption></figure>

The following are the key concepts in our Report Builder menu that could help and guide you in producing more advanced reports required for your business or institution:

* [Order By Clauses ](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/order-by-clauses.md)
* [Alternative Data Formats](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/alternative-data-formats.md)&#x20;
* [Bulk Student Select](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/bulk-list-creation-in-report-builder.md)&#x20;
* [Complex Comparison Operators ](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/complex-comparison-operators.md)
* [Nested Operators Using Using the AND and OR Rule Set](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/nested-operators-using-the-and-and-or-rule-set.md)
* [User-Defined Parameters](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/user-defined-parameters.md)&#x20;
* [Summarise Data](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/summarise-data.md)&#x20;
* [Generic Report Query](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/generic-report-query.md)
* [External Excel Query via API (Office 365 and Other Supported Excel Versions)](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/external-excel-query-via-api-office-365-and-other-supported-excel-versions.md)