Crystal Reports - Formatting one Group Header data across columns with details.

[Former Member]

Hello Everyone,

I have two-column report that needs to use multiple level of grouping.

Unfortunately, CR treats both columns as being part of the same group. It doesn't span down the page completely and then start at the top of the page. It only starts at the top of where the current group started.

Here is a sample:

GH1

  GH2

    GH3

GH4 – Data1

Detail 1                   Detail 2

GH4 – Data2

Detail 1                   Detail 4

Detail 2                   Detail 5

Detail 3                   Detail 6

Here is what I wanted it to look like:

GH1

  GH2

    GH3

GH4 – Data1           GH4 – Data2

Detail 1                   Detail 1

Detail 2                   Detail 2

GH4 – Data3            Detail 3

Detail 1                   Detail 4

Detail 2                   Detail 5

                             Detail 6

I have attached the design of the reports please do help me find the solution to get this format of report in place.

[abhilash_kumar · Accepted solution]

Hi Kishor,

Do you also have a screenshot of the report's preview page?

-Abhilash

[Former Member · Accepted solution]

Hi Abhi,

Thank you for the quick response, I have attached the Preview of the report please have a look at it.

-

Kishor

[DellSC · Accepted solution]

What does it look like with data?  Showing us the design view doesn't help much.

You could try suppressing the Group 4 footer section to see whether that works for you.

-Dell

Message was edited by: Dell Stinnett-Christy

[Former Member · Accepted solution]

Hi Dell,

I have attached the report preview in the reply message to Abhi. Please have a look. Suppressing did not work

[DellSC · Accepted solution]

Ahhh... I see.  You want to put the data into columns. I don't think you'll be able to do what you're looking for.  When you work with columns, the details will alternate between the columns so you won't get all of a group in a single column.

-Dell

[Former Member · Accepted solution]

Hi Dell,

Thank you for the clarification, Is there any other way of achieving this requirement in crystal reports. As this report is very important for out project in Crystal reports.

-

Kishor

[DellSC · Accepted solution]

There might be some way to format the data appropriately in SQL, so that you have fields from multiple groups in the same row.  This all depends on your data, though.  There is no way I know of to meet your requirement by just formatting things in Crystal.

-Dell

[Former Member]

Have you tried going to the section expert, and in the column layout tab changing the values for Printing Direction:  Across then down or Down then across?

[Former Member]

Hi Chester,

Thank you for the response, changing Across then down or Down then across will only operate on data in the details section. What i want is if you see my design view only Group 8# name should be formatted to multiple columns as below.

This is how I am getting the report:

This is what I am trying for:

-

Kishor

[DellSC]

I just though of something you might try..... (I have not tested this, though.)

1.  Take out Group4.

2.  Sort your data by the field from Group4 and then by the first field in the details.

3.  Have 2 details sections, both formatted for multiple columns - down then across.

4.  Put the field from GH4 in the first detail section.  Go to the Section Expert for that section and click on the button to the right of "Suppress"  (DO NOT check the suppress checkbox!).  Enter something like the following:

     NextIsNull({MyTable.Group4Field}) or {MyTable.Group4Field}<> Next({MyTable.Group4Field})

5.  Put the details data in the section details section.

You won't get exactly what you're looking for, but it should be closer than what you have.

-Dell

[Former Member]

Hi Dell,

Thank you for the suggestion, I feel we are getting closer.

We should be able to do achieve this using formula.I tried the one you suggested, I got the below report. Can we try something get this fixed using formula.

-

Kishor