Avatar of SStroz
Flag for United States of America asked on

Working with a large detail section


I'm running into something I've never seen before - a Crystal Report with objects (labels and fields) to the "right" of the "displayed" detail section.

It took me a LONG time to even see them but I finally figured out that if I shrink the view to 50% they are displayed in the grey area to the right.  The only problem is they're so small I can't work with them.  I also need to edit these and I don't know how to drag new fields into this area.  It does look like I can change the Page Setup to 11 x 17 but that isn't big enough.

This report was designed this way so it can be exported to excel.

Any ideas?  I'm lost on this one.

Thanks in advance

Crystal Reports

Avatar of undefined
Last Comment

8/22/2022 - Mon

Here's the report

In Design View - You can try using the Find (cntl-f) function on the menu bar of Crystal Reports. If you don't know the field you are looking for you can open the Show SQL query located under Database to find the name. Once you find the select field or label you can select format Text under Format Menu.
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

As mlmcc said, you can temporarily change the page/paper size to one that's wide enough to show all of the fields.  If the printer that the report is set to use doesn't support a large enough size, you can temporarily change the report to use a different printer.  If you don't have an actual printer that supports the size you need, you can install a virtual PDF printer, which "prints" to a PDF file.  There are a number of them out there.  The ones that I've looked at work by emulating a Postscript printer and then converting the Postscript output into a PDF file.  The one that I have (CutePDF Writer) includes a number of really large paper sizes (up to 3' x 8'), plus the ability to specify your own custom paper size.  I've used that before in CR to create a large page size.

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Thanks!  Funny, I've been in the business for many years and I had NO idea you could change the paper size through printers.