Multi columns in a group

[Former Member]

Hi all,

I am having trouble getting data that is grouped the way i need it.

I know crystal groups very well and i can do it that way but my

report needs to have two columns.

Is there a way to do this or do i need to press on and figure

out how to group before I call Crystal?

thanks

Timalaugh

[Former Member]

Okay... that's what I thought.

Thanks.

[Former Member]

Hi Tim, I am not sure I am clear about what you are trying to accomplish, however, if you have CRXI,

this is what I would do.

Right click the details section and go to section expert

Click where it says... Format with multiple columns

at the top right of the expert, you should now see an extra tab that says Layout

Click on the layout tab.

Check format groups with mulitple columns.

Set detail width, gap, etc as needed,

also printing direction. Across then down will most likely be what you want.

By adjusting the width, gap, page margins, etc, you can control how many columns show up.

[Former Member]

Yes, thank you, The trouble is not getting multiple columns to work in detail...

its getting multiple columns to work in a Group Section so duplicates do not show.

... for example i have parts A, B, C, C, C, D, E...

I only want part C to show one time with its accompanying number fields summed up.

ordinarily to do this I would simply put it into a group section... but, I have to have multiple columns

and it seems I can not have multiple columns in Group Sections

so... i am hoping for a work around....

starting to look like i need to have the data grouped before it gets to Crystal.

Thx

Timalaugh

[abhilash_kumar]

Hi,

Yes, 'Format with multiple columns' is not available with Group Sections.

So, if you wish to use this option with the detail section, you need to make sure the data is grouped before it comes into Crystal Reports.

Or, you can even use sub-reports, however I wouldn't prefer that way, as it is an overhead to the database and it is not needed when you can simply write a SQL.

-Abhilash