LCR to Excel

Use this forum to discuss issues that are not found in any of the other clerk and stake technology specialist forums.
rmrichesjr
Community Moderators
Posts: 3352
Joined: Thu Jan 25, 2007 11:32 am
Location: Dundee, Oregon, USA

Re: LCR to Excel

#11

Post by rmrichesjr »

weemanisme wrote: Sun May 01, 2022 9:18 am What leadership role/calling has the permissions to use the custom reports? I have attempted to find the reports menu option you listed directions for and there are no options for me.
In LCR, Other -> Access Table will show which callings have access to which features. However, I don't see "custom" anywhere in the table. Do you perhaps mean custom reports in MLS?
eblood66
Senior Member
Posts: 3812
Joined: Mon Sep 24, 2007 9:17 am
Location: Cumming, GA, USA

Re: LCR to Excel

#12

Post by eblood66 »

rmrichesjr wrote: Sun May 01, 2022 11:15 am In LCR, Other -> Access Table will show which callings have access to which features. However, I don't see "custom" anywhere in the table. Do you perhaps mean custom reports in MLS?
The option is called 'Create Reports' in the 'Reports' section. I's only available to the bishopric, ward clerk (not assistants) and exec sec and similar callings at the stake level.
jwjohnson99
New Member
Posts: 12
Joined: Sun May 26, 2019 9:08 am
Location: Provo, UT

Re: LCR to Excel

#13

Post by jwjohnson99 »

If you access LCR using the Chrome browser there is a Chrome extension that will copy a table on a website to Excel or Google Sheets. I’ve found it very helpful for this issue.
waltbristow
Member
Posts: 65
Joined: Fri Jan 19, 2007 3:49 pm
Location: Lynchburg, VA, USA

Re: LCR to Excel

#14

Post by waltbristow »

I believe only the ward clerk has the ability to create custom reports.
User avatar
Biggles
Senior Member
Posts: 1581
Joined: Tue May 27, 2008 5:14 am
Location: Watford, England

Re: LCR to Excel

#15

Post by Biggles »

waltbristow wrote: Wed Jun 15, 2022 3:19 pm I believe only the ward clerk has the ability to create custom reports.
And the Bishop and his counsellors! Also the Exec Secretary!
ijromerob
New Member
Posts: 2
Joined: Sun Feb 23, 2020 2:17 pm

Re: LCR to Excel

#16

Post by ijromerob »

bjenks wrote: Sat Feb 26, 2022 7:59 pm I'm not sure what you're trying to export, but I created a custom list (e.g., YSA), highlighted and copied the list, and pasted it into Excel using plain text. Needed minor formatting adjustments. This might be useful for some situations.
Thanks this was very useful
bigkess
New Member
Posts: 1
Joined: Fri Jan 20, 2023 1:05 pm

Re: LCR to Excel

#17

Post by bigkess »

The way I do it that works quite well is to pull a list of expenses (under the expense summary tab) I want (say welfare provided for a specific family). Then I right mouse click and select Print, then save/print as a PDF. I then use a free pdf to Excel converter which converts it to Excel. This captures 95% of the data and requires minor formatting to make "whole".
User avatar
cottrells
Member
Posts: 103
Joined: Fri Jan 19, 2007 12:14 am
Location: Bournemouth, UK
Contact:

Re: LCR to Excel

#18

Post by cottrells »

Another way is to use the Data > Get Data > From File > From PDF function inside Excel

See https://www.howtogeek.com/770474/how-to ... oft-excel/
Post Reply

Return to “General Clerk Discussions”