Subscribe to my newsletter EDM News
Reports are Better than Queries
17 July 2008, by , in Data Management, No comments

I’m often asked by my clients, when pulling data, if they should use a report or a query. The answer, of course, is it depends on the final use of the information that is output.

A simple rule of thumb is that if you need to present the data externally (e.g., a membership listing, an event registrants list, badges, or name-tents), you should use a report. Also, if it is data that you pull consistently and frequently over time (e.g., monthly membership data), reports are better than queries.

If the data is only going to be used internally, you can probably use a query.

However, having said that, I strongly encourage my clients to use reports, rather than queries, whenever possible. There are two primary reasons for this:

  1. Reports force you to correct the data at the source. Because reports present data that is “static” in the sense that the output cannot be modified (think pdf), if there is an error on the report (e.g., a name is misspelled), then the data must be changed in the database, rather than directly on the report. The result is that the data is correct for the next person that needs it.
  2. Different users using the same report should get the same result. Reports typically don’t allow you to change the query source, other than perhaps allowing for certain criteria to be changed at runtime (e.g., entering a date range on a dues renewal report). Because the report is using the same criteria each time it is run, the results will be consistent. Contrast this with a query tool that allows you to change any and all criteria, and you can see where queries can create a lot of consternation among staff if even one query line is different.

So look at the data you’re pulling. Are you using queries more than you should?

About author:

Leave a Reply

Archives

Sign-up for EDM News

 

 

Testimonials

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

“We came to Wes because we were very frustrated with our existing AMS and we wanted to improve our capabilities as soon as practicable. Wes very quickly helped us through a process of identifying our needs, identifying potential vendors, and selecting a new system that we’ll be able to move into very quickly. I especially appreciated Wes’s candor about our processes as well as the systems we were looking at. He was a great resource to have in a period of high anxiety for our organization. I would highly recommend Wes for any similar project.”

Jack Chiasson, CMP Executive Director
National Association of Life Brokerage Agencies

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

Mary Pat Paris
International Registration Plan

“This is the second database implementation we’ve done since I have been at Western Arts Alliance (WAA). The first I did on my own. This time we engaged Wes Trochlil as our database planning consultant. Let me tell you, this process is a whole lot easier having Wes on your team! For a small association like WAA, it’s tempting for board and EDs to question the justification and expense of a database planning consultant. But it’s the small associations that need Effective Database Management the most. Wes strengthened our planning process, clarified our needs requirements, helped us steer around solutions that couldn’t meet our objectives, and saved us money in the long haul.”

Tim Wilson, Executive Director
Western Arts Alliance

Tim Wilson
Western Arts Alliance
%d bloggers like this: