Report for members sustained by not set apart
-
- New Member
- Posts: 9
- Joined: Wed Mar 28, 2012 1:23 pm
Report for members sustained by not set apart
I can't seem to find a report that will show those members who have been sustained for a calling but not set apart. I'm trying to create a custom report but I'm not finding the criteria I need. Does anyone have a report such as this that they can share? Or can anyone provide instructions as to how to create such a report? Thanks!
- rbeede
- Member
- Posts: 205
- Joined: Sat Apr 02, 2011 1:33 pm
- Contact:
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
There's no way to do this entirely with custom reports, but you can use a custom report in conjunction with a spreadsheet to give you what you want. There are a couple of reasons why you can't do it with just a custom report:cnilsson wrote:I can't seem to find a report that will show those members who have been sustained for a calling but not set apart. I'm trying to create a custom report but I'm not finding the criteria I need. Does anyone have a report such as this that they can share? Or can anyone provide instructions as to how to create such a report? Thanks!
- Each person can have more than one calling, and custom reports report on individuals.
- There is no criterion related to that detail of callings.
- Create a custom report.
- For the criterion, set "Member Status -- is -- Called to a position" (that will show you only members who have a calling)
- On the Format tab, make sure you include "Callings with Date Sustained / Set Apart"
- Save the Report.
- Run the report.
- Copy the entire report to the clipboard (Ctrl+Shift+C)
- Open a spreadsheet application
- Paste the clipboard.
- Add a column, and create a formula using various string functions to extract the callings and the /No or /Yes for the Set Apart flag.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
After I wrote that complicated approach, I realized that you can simply use the Members with Callings report. It shows the Set Apart flag. It also creates one row per calling, which is much simpler than the custom report, which combines all the callings for an individual on one row. You still might want to copy that report to a spreadsheet for further filtering and processing, but it will be a much better starting point than a custom report.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
-
- Senior Member
- Posts: 3909
- Joined: Mon Sep 24, 2007 9:17 am
- Location: Cumming, GA, USA
aebrown wrote:After I wrote that complicated approach, I realized that you can simply use the Members with Callings report. It shows the Set Apart flag. It also creates one row per calling, which is much simpler than the custom report, which combines all the callings for an individual on one row. You still might want to copy that report to a spreadsheet for further filtering and processing, but it will be a much better starting point than a custom report.
I use the Members with Callings report and then click on the Set Apart column to sort it so that all those who haven't been set apart are at the top. (Actually I first click on the Sustained column and then the Set Apart column so that those who haven't been set apart are at the top and they are sub-sorted in the order they were sustained). I can then just print the first page or two to print those who haven't been set apart.
-
- Community Moderators
- Posts: 1184
- Joined: Sun Oct 21, 2007 6:04 am
- Location: Utah, united states
This is my favorite method, and just print the first page or you'll get your whole ward.eblood66 wrote:I use the Members with Callings report and then click on the Set Apart column to sort it so that all those who haven't been set apart are at the top. (Actually I first click on the Sustained column and then the Set Apart column so that those who haven't been set apart are at the top and they are sub-sorted in the order they were sustained). I can then just print the first page or two to print those who haven't been set apart.
It's one of those reports that you'll "get right on" every month, because the need to know this never goes away and can become standard in your ward processes.cnilsson wrote:I'll get right on this and use the Members with Callings report.
-
- New Member
- Posts: 1
- Joined: Fri Dec 01, 2023 10:23 pm
Re: Report for members sustained by not set apart
Another good way to find this report in LCR is: Organizations > Callings by Organization > Options > Filter By (check the box "Callings Not Set Apart") > Print.