BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Design

Formatting the detail section to display multiple columns

Format the details section to display in multiple columns:

1. Right-click on the Details section, to open the Section Expert dialog box.

2. On the Sections list, click the details section.

3.On the Common tab, select Format with multiple columns check box. A new tab called Layout appears.

4. On the Layout tab, specify the formatting for the columns: Enter the width of the column in the Width box (you can set the height by dragging the section borders in the Design view of the report).

5. Enter the space between labels going across the page in the Horizontal gap checkbox.

6. Enter the space between labels going down the page in the Vertical gap box.

7. Select the printing direction, Across then Down or Down then Across.

If the report is grouped, and you would like the group headers and footers to display in multiple column format as well, select the Format groups with multiple columns checkbox and click ok.

Final Results:

Tagged , , , ,

8 thoughts on “Formatting the detail section to display multiple columns

  1. Gabriel

    Great!,

    But i have a question, is it possible to display data like this?
    For example I have a result set of 6 records and I want to show something like this:
    Rec1 Rec4
    Rec2 Rec5
    Rec3 Rec6

    and if I have a result set of 10 records show something like this
    Rec1 Rec6
    Rec2 Rec7
    Rec3 Rec8
    Rec4 Rec9
    Rec5 Rec10

    Reply
  2. Namrata Mathur

    I want to format the details section to display in multiple columns at runtime. I am using .NET RAS SDK.

    Anyone please reply if you have solution for that.

    Thanks.

    Reply
  3. drym

    how to format the details section to display in multiple columns under group? i want it like this:
    Group1
    ———————————————————————————————————————————-
    Group2 Group2
    fldName1 fldName2 fldName3 fldName1 fldName2 fldName3
    Rec Rec Rec Rec Rec Rec
    Rec Rec Rec Rec Rec Rec
    Rec Rec Rec Rec Rec Rec

    Reply
  4. Cathy

    I am very new to Crystal Report 2014 and have minimal training. I need to know how to do the following: I have 2 tables LEGSUM & LEGDTL. My current report returns records with each record having an Active Date & Last Position Date. Each record is either a P (DTL.LD_PL) type or a D time. I need only the Active Date on P records and only Last Position Date on D records to display. And then I need a separate field to calculate the days between those 2 dates. Below is a sample of what I am currently getting. In the scenario below, I want the Active date of 2/2/16 on leg 2 and the Last Position date of 3/3/16 on leg 4. This report is for calculating the number of days the chassis has been out from 2/2 thru 3/3. Any help would be appreciated

    Trip Leg Active Date Last Position Date Chassis LD_PL
    1012 2 2/2/16 3/3/16 aplz111000 P
    1012 4 3/3/16 3/3/16 aplz111000 D

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

GET SOCIAL

QUICK TIP

From the Format Editor, you can change the direction of the text in a field by selecting from the Text Rotation drop-down list (0, 90, or 270 degrees).

ADVERTISMENT