Crystal Reports: displaying group horizontally.

[former_member548403]

I am trying to display data in my report from left to right and I can use the subreports and list the subreports side-by-side to show the data horizontally. The trouble is, I would have to use too many subreports, which will slow down the report.

Someone suggested using the "Down and Across" function in the report and when I could try using the function, but how do I separate the group header and display it horizontally? For example:

<Group Header>     <Group Header>    <Group Header>
Data               Data               Data

....

[former_member548403]

The report is showing data like this right now.

<Station 1>     <Station 4>
Sam              Jackie
Jack             Mike
Ruth             Barry
<Station 2>
Mack 
Eddie
John
<Station 3>
Peter
Luke
Moses

When i tried "Across then Down", the report displays data like this:

<Station 1> Sam Jack Ruth <Sation 2> Mack Eddie John <Station 3> Peter Luke Moses <Station 4> Jackie Mike Barry

I need the report to display data like this:

<Station 1>   <Station 2>   <Station 3>    <Station 4>
Sam           Mack          Peter          Jackie
Jack          Eddie         Luke           Mike
Ruth          John          Moses          Barr

[abhilash_kumar · Accepted solution]

Hi Kenshin,

Here's what you could do:

1. Insert a Group Footer 1b section (you could use the existing group footer too).

2. Reduce its height and make it as thin as possible. Don't suppress this section

3. Go to the section expert > highlight this group footer section > check "Print at bottom of page"

This should force the next group to start in a new column.

-Abhilash

[former_member548403 · Accepted solution]

Thanks! I actually figured it out and it was exactly what you suggested. I came back to update my question with the solution, and you beat me to it!

[ido_millet]

Another option is to use a CrossTab.

[former_member548403]

Can I? I am not an expert with the Crosstab, but I tried using the Crosstab, too, but I cannot display data under the group header. Any suggestion?

[DellSC]

If you search for "Multiple Columns" in the Crystal Help, you can find an entry called "To create a multiple-column report" that has the information you need for configuring this. In the "Layout" tab that appears in the Section Expert when you do this, there is an option to "Format group with multiple column" that might get you what you're looking for.

-Dell

[former_member548403]

Hello, Dell. I've tried that and it is only 50% of what i need. I need the next group to display horizontally, but it's not doing that. I need to divide and separate each group value per group and display them slde by side.

[DellSC]

Have you tried setting it to "Across then Down"?

[former_member548403]

Yes, I have. Please see my comment under the original question.