Youth class printouts

Discussions around using and interfacing with the Church MLS program.
mprusse
Member
Posts: 228
Joined: Sun Jan 28, 2007 9:01 pm
Location: Littleton, CO-USA
Contact:

Youth class printouts

Postby mprusse » Thu Apr 30, 2009 9:24 pm

Is this printout possible from MLS?

1-youth (ages 12-18) divided by class/quorum
2-sub sorted by age (oldest to youngest)
3-all on one printout (not one class per sheet)

I can come close using the Print Lists & Rolls feature but it doesn't sort the youth by age but rather by last name.

Please help me figure what I'm missing to get this printout. Thank you.

User avatar
iamdavid
Member
Posts: 50
Joined: Sun Sep 07, 2008 5:07 am

Postby iamdavid » Fri May 01, 2009 5:01 am

Using the Print Rolls and Lists feature, select Standard List and also:
Each Class Group starts a new page - NO
Show sensitive information - YES

It will bring them up with the eldest on the first page and work back down through their ages, showing the age next to each name, grouped Alphabetically by Class.

Other than that you would need to shape a Custom List available in the Menu Dropdown under Membership. I think the Print Lists option will suit your needs though.

gawing
New Member
Posts: 17
Joined: Fri Jan 19, 2007 12:52 pm
Contact:

Postby gawing » Fri May 01, 2009 6:10 am

I created a custom report with the standard information and it fits nicely on one page.

User avatar
aebrown
Community Administrator
Posts: 14685
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Fri May 01, 2009 6:18 am

macsense wrote:Is this printout possible from MLS?

1-youth (ages 12-18) divided by class/quorum
2-sub sorted by age (oldest to youngest)
3-all on one printout (not one class per sheet)

I can come close using the Print Lists & Rolls feature but it doesn't sort the youth by age but rather by last name.


Unfortunately you have placed too many specific conditions for MLS to generate the list directly. As you (and WenU) noted, if it weren't for the requirement to sort by age within the class, the Standard list from Print Rolls & Lists would work fine (it sorts alphabetically by name).

Alternatively, if you remove the requirement to have it all on one printout, you can print the 6 classes individually from the specific organization in MLS (e.g., go to the Mia Maids organization, show only members, click on the birth date column, then print), and each could be sorted by age, but you would have 6 different pages.

So your only other option to fulfill all 3 requirements is a custom report, but custom reports have no ability to divide by class/quorum. So you would have to generate the report and then copy the data to a spreadsheet and do some more processing. You could select everyone whose "Organization class is Priest or Organization class is Laurel or Organization class is Teacher..."). In the spreadsheet, you would have to parse the "Organization Class" field to extract the youth class (it includes Sunday School classes and other classes as well) and put it in a new column. Then you would have to sort by the class and the birthdate and then separate the classes. By the time you've done all that, it seems a lot easier to just generate 6 individual reports, but it's your choice.

User avatar
aebrown
Community Administrator
Posts: 14685
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Fri May 01, 2009 6:24 am

gawing wrote:I created a custom report with the standard information and it fits nicely on one page.


It's easy enough to generate a custom report, but as I reported in my other post, I don't see how you can meet all three requirements listed in the first post of this thread directly from MLS. Could you share details as to how you met all three requirements?


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 2 guests