Open the Reports tab, click New Report, pick a report type (Opportunities, Leads, Accounts, or a custom type), choose a format, add your filters and grouping, then save and run it. A dashboard is just a layer on top: pick one or more reports as sources, add components like charts or tables, and set who the dashboard runs as. That's the mechanics. The part that trips people up is everything the report can't see, because it only ever shows what's already sitting inside Salesforce.
1. Pick a report type. From the Reports tab, click New Report and choose the object you're reporting on, Opportunities, Leads, Accounts, Cases, or a custom report type your admin built. The report type decides which fields and related objects you can pull in later, so get this right first.
2. Choose a format. Tabular is a flat list, good for exports. Summary lets you group rows (by stage, by owner, by month) and add subtotals. Matrix groups by both rows and columns at once, useful for a grid like rep-by-quarter. Joined reports go further: they let you combine several report blocks, even from different report types, on one page as long as they share a common field, so you can see Opportunities and Cases for the same account side by side.
3. Add filters and fields. Narrow the date range, owner, stage, or any field relevant to the question you're answering. Drag in the columns you actually need and remove the rest, a report with 40 columns is not more useful than one with 8 of the right ones.
4. Group and add formulas if needed. Group rows by a field to get subtotals, add a bucket field to roll several picklist values into one category, or add a row-level formula for a calculation standard fields don't give you.
5. Save, run, and build a dashboard from it. Once the report looks right, save it to a folder you can share. To turn it into a dashboard, go to the Dashboards tab, create a new dashboard, and add components, each one pointing at a report as its source. Set the dashboard's running user carefully: a fixed running user shows everyone the same data regardless of who's viewing, while a dynamic dashboard shows each viewer only what their own permissions allow.
A Salesforce report can only report on Salesforce data. The moment a question needs something that lives somewhere else, whether a customer's paid invoices in QuickBooks, real inventory counts in your ERP, or shipping status from a logistics provider, the report hits a wall. People work around it by exporting to Excel and manually pasting in numbers from three other systems, which means the dashboard leadership looks at every Monday is already a day or two stale by the time someone's done stitching it together.
The other common breakdown is distribution. A dashboard inside Salesforce is great for people who log into Salesforce. It's useless for the warehouse manager, the finance team, or a customer who needs the same numbers but has never had a Salesforce license and never will.
We connect Salesforce report data with numbers from your ERP, accounting system, or inventory platform into one combined dashboard, so a pipeline number and a cash number sit next to each other without anyone exporting anything to Excel first.
A scheduled export, an emailed summary, or a lightweight external dashboard puts the same figures in front of a warehouse lead, a client, or a finance team member who has no reason to ever open Salesforce directly.
Tell us which report or dashboard someone has to rebuild by hand, and where the missing pieces actually live. We'll map out what it would take to make it update itself.
If a dashboard needs data from outside Salesforce to actually answer the question, exporting to Excel isn't a long-term fix. We build the connections that keep it current automatically, and Salesforce reporting is just one example, we do this for whatever system in your business still runs on manual exports.
Let's talk →A joined report combines multiple report blocks, each potentially built on a different report type, into a single report page. The blocks have to share at least one common field, like Account, so you can view Opportunities and Cases for the same accounts side by side instead of running two separate reports.
Open the report, click Export, choose Details Only or Formatted Report, pick .xlsx or .csv, and download. Formatted Report keeps your groupings and subtotals; Details Only gives you a flat row-per-record file that is usually easier to drop into another spreadsheet or tool.
A dynamic dashboard runs as the logged-in viewer rather than a single fixed running user, so each person only sees the data their own record-level permissions allow. It's the right choice when the same dashboard gets shared across teams who shouldn't all see the same underlying records.
Standard report types come built in around core objects like Opportunities, Leads, and Accounts. Custom report types get built by an admin to report across objects or fields that standard types do not cover, often combining a custom object with a standard one.
Not natively. A standard report only queries Salesforce objects. Getting outside data into the same view means bringing it into Salesforce first (through an integration or a custom object) or building a combined dashboard outside Salesforce that pulls from both sides.