Printing

%3CLINGO-SUB%20id%3D%22lingo-sub-1254983%22%20slang%3D%22en-US%22%3EPrinting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1254983%22%20slang%3D%22en-US%22%3E%3CP%3ETwo%20Questions%3A%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20When%20printing%20a%20report%20where%20row%20data%20is%20sorted%20by%20column%20A%2C%20and%20there%20are%20multiple%20rows%20where%20column%20A%20is%20the%20same%2C%20is%20there%20a%20way%20to%20only%20print%20column%20A%20when%20it%20changes%3F%3C%2FP%3E%3CP%3EExample%3A%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%20Joe%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20123%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Joe%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%20123%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Joe%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20234%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20234%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Joe%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20345%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20345%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Steve%20%26nbsp%3B%26nbsp%3B%20abc%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Steve%26nbsp%3B%20abc%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20If%20in%20the%20above%20example%2C%20where%20the%20name%20is%20a%20control%20break%2C%20is%20it%20possible%20to%20automatically%20skip%20one%20row%20when%20it%20breaks%20between%20Joe%20and%20Steve%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1254983%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Two Questions:

1.  When printing a report where row data is sorted by column A, and there are multiple rows where column A is the same, is there a way to only print column A when it changes?

Example:          Joe       123                 Joe      123

                        Joe       234                             234

                        Joe       345                             345

                        Steve    abc                 Steve  abc

2.  If in the above example, where the name is a control break, is it possible to automatically skip one row when it breaks between Joe and Steve?

 

 

0 Replies