Is batched reporting possible?
Options
I have a few state-by-state reports that I'm occasionally asked to run for all 50 states. Currently I have a query where it asks which state I want to run these on so it can run my report specifically for that state. What I'm wondering is, is there a way to automate Raiser's Edge through some kind of batched reporting so that I don't have to manually re-run each of these reports 50 times?
Tagged:
0
Comments
-
Whew! Another user may have some better ideas. I thought of two possibilities.
1. How much data are you pulling in these reports and what report are you running? Just a query and taking data to excel? If so, would it be an option to split the data into separate reports by filtering on state after you've gotten data into excel? Macros could maybe help with it too.
2. Don't know the costs involved but there is queue optional function for RE that from my understanding can be used to run queries/reports at set time like overnight. Here's the knowledgebase link: https://kb.blackbaud.com/articles/Article/482150 -
If you know MS Access, you can export your data (all states at once) from RE and then set up an Access database that will show that data by state. Similar to Excel, but Access might be a better option if you run this fairly often (takes longer to set up the first time, but then saves you time, usually, every time you run the reports).
Crystal Reports might be an option, but I don't know enough about them. And as JoAnn mentioned, the Queue module might help...but I don't know much about that either (other than it's on my list to find out more!).0 -
Could you create a pivot table report in RE that starts the breakdown by state?
If you wanted to use REQueue, you would have to create 50 reports and add them a queue which will output 50 reports for you. You only have to set it up once and then it will run all of them for you at the click of a button (or when scheduled). I use REQueue daily. It's worth the time and investment. (But you cannot put pivot reports in queue).0 -
Debra Holcomb:
Could you create a pivot table report in RE that starts the breakdown by state?
If you wanted to use REQueue, you would have to create 50 reports and add them a queue which will output 50 reports for you. You only have to set it up once and then it will run all of them for you at the click of a button (or when scheduled). I use REQueue daily. It's worth the time and investment. (But you cannot put pivot reports in queue).
I will add the caveat that setting up Queue can be a huge pain, especially if you're running it on a computer that is not yours. Having the correct RE, local and network share security rights for both you and the username on the computer that you're running it on can be a mess to configure. I have several Queues set up that I can run when needed, but that for some reason just won't run in the overnights when I have them scheduled, and I've been unable to figure out why. I got in touch with blackbaud about it, and the guy who helped me admitted that he dreaded getting Queue questions, because there are just so many places where things can go wrong.
I mean, not "go wrong" like a catastrophic failure of your database. Just go wrong like, not work.0 -
To give some background, these are primarily a couple of LYBUNT/SYBUNT reports (with contact info) in prep for our local ambassadors around the country so they know who to target before the end of the year. We’ll be running these from now through roughly January. The SYBUNT is significantly larger with what I’d estimate each state to have a few hundred people in it. The LYBUNT is obviously much smaller. I could run the whole thing as a query and output it to Excel, but my guess is it would probably take about the same amount of manipulation and time to get it to work.
I also have an extensive recognition summary report that’s run monthly based on a state-by-state level for a couple of funds on a year-over-year span, and including dollars and number of donors who gave over a certain amount. Currently this report is run 6 times (at roughly 5-10 minutes each) to produce a single report in Excel.
I may look into RE:Queue and see how involved it is and if it might do what I’m trying to do, much as I’d hate to have to create 50 of each of those two reports and 6 of the other. Depending on cost, it may not be worth getting this module since I’d mostly be running these 3 reports with it.
Likewise I may give Crystal Reports a look, as that has been on my to-do list for a while now.
I’m not sure if a pivot table would suit my needs, since I’ve never used them, but I’ll give that a look too.0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board