Page 1 of 1

Youth class printouts

Posted: Thu Apr 30, 2009 10:24 pm
by mprusse
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.

Posted: Fri May 01, 2009 6:01 am
by iamdavid
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.

Posted: Fri May 01, 2009 7:10 am
by gawing
I created a custom report with the standard information and it fits nicely on one page.

Posted: Fri May 01, 2009 7:18 am
by aebrown
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.

Posted: Fri May 01, 2009 7:24 am
by aebrown
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?