Salsa Blog

50 Things About Salsa Part 8

By Jason Zanon, Salsa
(With a little help from Amanda Foster and Beth Johnson)

You’ve come this far- don’t stop now! We’re focused on some of the reporting functions you’ll find in Salsa. Need to back up or slow down? You can start from the beginning.

Reports

All the amazing data Salsa collects can be sliced and diced to your specifications with Custom Reports. Don't hesitate to hop your way over the learning curve; our support team is happy to help build reports to your specifications on request. (Really want to go nuts? Start combining different reports' complex data sets with Excel's VLOOKUP.)

Beyond the basics, reports have some excellent but easy-to-miss powers. We've blogged about these before, so the next four items are cribbed from Four Sneaky Ways to Get the Most from Salsa Reports.

40. You Can Copy a System Report

See a report in the standard Salsa library that's almost exactly what you want? You can get a local copy of any system report in your custom reports library and tweak to your heart's content. To copy a system report:

  1. Place the system report on one of your dashboard pages.
  2. Hit "Full Report" to run it.
  3. Click "Clone and edit this report" in the upper left-hand corner of the report results page.

Just navigate to your custom report list, and the copied report should be there for you to edit.

Clone a report in Salsa

41. Reports Can Give Totals and Subtotals

In SQL land, this feature is called "rollup" -- and that's what it's named in the custom report builder. You can find rollup, under the "Filter" tab.

To get a subtotal,

  1. Click on the "Group By?" box for at least one field under Columns.
  2. Select a "function" (such as "Sum") for at least one field you're not grouping by.
  3. Select "Rollup" under the "Filter" tab

Subtotal donation reporting in Salsa

You may be thinking here, "I want to see individual gifts add up to a sum, not a sum for every line."

Perfectly possible! Try grouping by the Donation_KEY field (or for other kinds of reports, the _KEY field on the table you're reporting). Since KEY numbers are completely unique, their "sum" will always be only a sum of one value ... while the "rollup" will give you the total of all those individual gifts.

Overall sum report in Salsa

42. Reports Can Request Variable User Fields

So you've got a report that's just the right framework of columns and rows, and you're thinking ... dang, I have to rebuild this any time I want to see an updated set of numbers?

In fact, you do not have to rebuild it.

Reports can be built to request user input of variables every time they are run -- for instance, a date, or a date range -- so that a like array of data can be presented for the evolving parameters at hand each time the report is run. To do this,

  1. Under the "Conditions" tab, select the field you'll want to vary each time you run the report
  2. Select an operator -- "Equals" is the default, but you might want "Less Than," "Greater Than," or others.
  3. Leave the "Value" field empty.
  4. Change the "Value type" field to "User Variable."
  5. In "Variable Label", enter human-readable text that will prompt the person running report on what kind of information to enter. For instance, if the condition is built on the Transaction_Date field, the Variable label might be "Enter the date here".
  6. Use the (+) button and "Add OR condition" buttons to add as many different user-submitted condition entries as you like. These can be freely combined with fixed conditions.

Reports can request variable user fields

43. Reports Can Be Set to Run on a Schedule

No matter how polished and buffed your report, it still needs a human being to run it ... and in any given busy week (to say nothing of those spent on the beach), that step can easily slip the mind.

No problem.

Salsa reports can not only be run by hand, but can be set to run automatically and email the results on a scheduled basis. To set one up,

  1. Place the system report on one of your dashboard pages.
  2. Hit "Full Report" to run it.
  3. Click "Export" in the lower right-hand corner of the report results page.
  4. Under "export to a file, or schedule an export," click "Export Options".
  5. Set the "run and export this report" field to "on a schedule".
  6. Select a start time for the first report to run.
  7. Select the run frequency from the "Run the report" menu.
  8. Select one or more (comma-delimited) email addresses to receive the reports.

The other fields on this page -- a custom header, optional include fields, compressed files -- are strictly optional.

Schedule reports in Salsa

Read Part 9.

Topics: Salsa