LCR cutom report drops columns

[ebenvisher]

For me, LCR only prints as many columns to the PDF as will fit on the width of one page. So if I choose, say, 20 columns, I get a report with only the first 10 or so.

I expected it to act like Excel, and print one set of pages for each column range.

It cannot actually be designed this way, so what am I missing? As I understand the current behavior, I can never make a custom report with more than a small number of columns (under 10 or so).

Thanks *so* much for your help.

[davesudweeks]

I just generated a report with 14 columns. All the columns show whether I print portrait or landscape.
Then I took it to 20 columns and it truncated at 14 columns when printing portrait but all 20 columns showed when printing landscape.

With all due respect, I'm wondering what use there would be for that many bits of information on a single report. Then, of course, all my custom reports have been to answer very specific questions and don't require a large number of columns to provide the information needed.

[ebenvisher]

Dave,

Thanks for taking your time to help!

My guess is that I use the data as you do. I want all the detail for members so I can make reports or deduce information that LCR is incapable of.

When you want more than 14 columns, what do you do? Run the request multiple times, selecting different fields each time?

Thanks again.

--Eben Visher

[davesudweeks]

I consider the reports function something that will allow creating a specific query to answer a specific question (such as "unbaptized children of record"). Such a report would likely contain the preferred name, head of house name, address, home phone, individual phone, email, age, and household position: less than 10 columns. I still can't imagine what single question would require more than 20 columns of information.

But I'm just a ward clerk in Oklahoma. I recommend you use the feedback link on the Create A Report page and indicate what you need to accomplish with the custom report you need to create. Another option is to ask your Stake President to bring up the need in his Coordinating Council.