pminet wrote:Is there a way to create a custom report using data captured in the quarterly report convert detail section.
Not all data in MLS is available through a custom report.
pminet wrote:I am trying to create a report showing converts who are ym and to show if they have received the priesthood (yes its in MLS), if they have a calling (yes its in MLS), if they have attended sacrament (
its in the quarterly report but is that it?)
A custom report showing young men converts with the priesthood and holding a calling is possible. The filter criteria for this would be something like:
Member Status | is | Convert
Sex | is | male
Age | is less than | 19
and Age | is greater than | 11
Priesthood | is not | Unordained
Calling in Organization | has a value
But there is no data regarding attending sacrament for an individual in MLS. Sacrament meeting attendance is statistical data for the entire ward. If you were tracking sacrament attendance for an individual through a custom field then the data would be available. Do do so would require advance planning and additional administrative man hours to track.
pminet wrote:I wonder if the only way to do this is to dump to csv both reports and vlookup the information in excel.
This would not provide any more information that the custom report using the filter criteria provided above for the particular data you want. The data point you are missing and not available in MLS is the individual sacrament attendance.
Line 24 of the quarterly report, converts age 8 and older baptized and confirmed in the last 12 months attending at least one sacrament meeting last month, is obtained from the ward mission leader. It is data he tracks for converts. Note that it asks for converts witin the 12 months prior to the quarterly report end date attending sacrament in the last month. It does not ask for data for all converts.
The report you want will not necessarily give the data for line 25, converts age 12 and older who have a Church responsibility or calling. MLS may not have the data for those with responsibilities. It will have data for those with callings and some responsibilities. A responsibility is not necessarily recorded in MLS. For example, we have teachers who have the responsibility as ushers. That responsibility is not recorded in MLS.