How to change the way groups are displayed

[manjulam]

Hi,
I have grouped the retrieved data based on a field(episode num). In CR, the default way of displaying groups is one group below the other. I am sure that I will have only three groups and so i need to display it side by side.
i.e; now the display is:

scenes:
37
2
4

pages:
13
2
1

I want it like:

scenes pages
37 13
2 2
4 1

Is there any way out?

 

[rier]

Have you considered using subreports?

 

[manjulam]

I wanted to consider using sub reports as the last option as I have too many already. I wanted to know whether there is any other way out.

 

[kenhamady]

CR does multiple columns, but doesn't have a column break feature. Will the number of records in each group be somewhat consistent? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[manjulam]

There will be only one record(with five fields) in a group

 

[kenhamady]

in your example:

Pages
13,2,1

I am confused. Your example sounded like this was 3 records in each group. Are these three fields in one record? What are the five field names and how do they fit with the example you have shown above? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[manjulam]

Ya,in the example,it was three fields of one record. Sorry,I should have been more clear. My table structure is like this: I have a "type" field which will distinguish each group.And for each "type"(scenes,pages or minutes) I have one record in the table with five fields like "total", "previous total" etc. So when I retrieve I get records for all types and so I group it on the type field. Hope this is clear.

 

[chelseatech]

Write a conditional formula for each value and place the sum of each formula in a nice big group footer.

Formula for Pages/First field
if "Type"="Page" then {table.field1}

Similar formulas for each value and then arrange the SUM's of these in the Group footer with a heading.
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

Is the 37 below scenes a subtotal of a field or the field itself? It it is a subtotal you might try a cross-tab with the column being the TYPE and your 5 fields as summarized fields. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[manjulam]

I wrote formulae to concatenate each group as a string and I placed these formulae on the details field. It worked now.
But I would still want an easier method to place groups side by side. I have another section in my report where various departments and employees of each department have to be retrieved and displayed horizontally and not the default vertical display of groups. Is there any other way out?

Essentially what I need is this:
CR groups data and displays like this:

Dept1:
-----
Emp1
Emp2
Emp3

Dept2:
-----
Emp1
Emp2
Emp3

I want to place it horizontally like this:

Dept1: Dept2:
----- -----
Emp1 Emp1
Emp2 Emp2
Emp3 Emp3

Manjula

 

[kenhamady]

I don't know of an easier way. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[52]

When you insert the group, there is a combo box which says: in ascending order. If you select "in specified order", it will let you change the order any way you want.

 

[manjulam]

Hey, I think I have cracked it. Actually, in the format section of the details band, i checked format with multiple columns,changed the printing direction to "across and then down" and checked the "format groups with multiple colums" and it worked!! The width needs to set properly and it would have been so much nicer with a column break feature!

Now I need a label for each of these rows to be displayed. If i place a text object it repeats for every column. Is there a way out?