# Guides

> Task-led guides to automating recurring SQL reports: Excel workbooks, scheduling with your existing orchestrator, dbt models and moving from SSRS or Crystal.

Step-by-step answers to the jobs people automate with DRE. For every option and key, see the [documentation](https://getdre.com/docs/).

[

## Move SAS reporting workflows to DRE

Keep Oracle or SQL Server, inspect checked Excel workbooks, watch a real run and download the synthetic overdue-loan example. SAS reference unexecuted.



](https://getdre.com/guides/sas-reporting-to-dre/)[

## How to automate SQL reports to Excel

From a query to a formatted workbook emailed on schedule: the Python script way, the DRE way, and when to keep the script.



](https://getdre.com/guides/automate-sql-reports-to-excel/)[

## How to schedule SQL reports

Named schedules in YAML, a preview of every firing, and reruns that keep their period, with cron, Airflow, Dagster or Databricks Jobs.



](https://getdre.com/guides/schedule-sql-reports/)[

## From dbt models to Excel reports

Read the tables dbt builds as sources and deliver them as formatted workbooks, with the dbt habits you already have.



](https://getdre.com/dbt/)[

## Moving from SSRS or Crystal Reports

Port paginated reports to SQL, YAML and PDF templates, and prove each one matches with a parity check.



](https://getdre.com/docs/moving-from-ssrs-or-crystal/)