[Resolved] Build lateral report in Crystal?

[BIGGY]

Generally the way it works in Crystal is that you have a group and then the details under it. In my case, I have:

Group 1 - Order # AAA
Line1
Line2
Line3
...
Group 1 - Order # BBB
Line1
Line2
Line3
...

The number of lines, line items, and everything else is always dynamic of course. Is it possible to build a report where everything is on one line? So as it would look like:

Order # AAA - Line 1 - Line 2 - Line 3...
Order # BBB - Line 1 - Line 2 - Line 3...

I can build the above by hardcoding variables, however it's very time consuming when I did it manually once and then anytime the product changed I had to go back into the report to change the variable and what they were looking for. Any easier ways to do that?

[brucevde]

Go to the Format Section screen.

For the Group, set the "Underlay Following Sections" option. You will need to move the first control in the detail section after all the Group Header controls otherwise they will overwrite the Group header.

'typical design layout
Group Header - "Company Name"
Details      - "Some Field"

'design layout for underlaying sections
Group Header - "Company Name"
Details      -               "Some Field"

For the Details, set the "Format with Multiple Columns" option.
A new Tab will appear called Layout. Specify a Width and set the "Across then Down" option. The Width will determine how many Detail sections (i.e records) will be printed across the page.

[BIGGY]

Ok, I'm following, the only part I'm getting hung up on is when I set the Width...then everything goes way out of alignment.

[BIGGY]

Ok, I've got it printing more or less correctly. Thanks much for the help! One final question. Can I move the section somehow? It seems to start always over on the very left of the report. That's where I have the header. I'd like it to start on the same vertical plane, but so that it's not directly under the rest of the text. If I move the details over and then create the layout, it blanks everything out I'd like to somehow move the whole section over to the side.

[brucevde]

You can't print a section starting at a certain position.
What do you mean by "blanks everything out"? Are you referring to the way Crystal displays "suppressed" fields/sections as in the sample pic.

If yes, that is what is suppose to happen. It indicates that the detail section is repeated X number of times. In the sample pic 5 detail sections can fit on one line. Once multiple columns are set you can only add fields to the "enabled area" of the details section.

Another option to try - suppress the Group Header section. Move everything into the Details section and set the "Suppress if Duplicated" option on all group header fields.