Crystal Format with Multiple Columns Grayed Out

maverick0728
maverick0728 used Ask the Experts™
on
We have a labels report from our ERP software company that we need to modify.  It is currently set to print on 8.5x11 paper, 2 across, 2 down.  

We need to modify to print on a 4x6 label.  For some reason when I am in the Section Expert > Details section the "Format with Multiple Columns" is grayed out.  

How can I remove this?  I need to set all data to one 4x6 label.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
DO you know how the report was created?

I believe if the report was created with the LABEL wizard, you can't change the report design as it is controlled by the label paper chosen.

Have you tried changing the paper it uses in the printer driver rather than changing the report itself.

mlmcc

Author

Commented:
I've tried changing the paper, but it still leaves the detail section grayed out.  What is the best way to start a new report and leave all my database settings alone?  This is a report designed by our ERP software vendor and I don't want to mess with their already set for the report.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
The way I do it is to click NEW REPORT
Set the database (you could choose the existing view)
At that point I click OK/FINISH in the wizard and do the rest manually.

If you are printing a standard Avery label then you could start with the label expert/wizard and choose the appropriate Avery label as the paper.

mlmcc

Author

Commented:
thanks that worked

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial