Multiple Columns - Displaying the Group Header over Each Column

Hello,

I have a subreport that lists ItemNumber and QuantitySold for a specified period.

The data appears in three columns:

Item        Qty        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###

I would like to be able to have the header over each column:

Item        Qty        Item        Qty        Item        Qty
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###        xxxxx     ###

The groups are laid out as follows:

Group Header #1: Store                 <--   "Item    Qty"
Group Header #2: ItemNumber       (suppressed)
Details      (ItemNumber, QuantitySold)        (suppressed)
Group Footer #2: ItemNumber    <--  ItemNumber, SUM(QuantitySold)
Group Footer #1: Store                  (suppressed)

In the Section Expert, the Details section has "Format with multiple columns" checked, and the resulting Layout tab has "Format Groups with multiple column" checked.

Thanks in advance,

s1m0ne
LVL 1
s1m0neAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
I would have thought that in this case you should be able to put the column labels in the page header and repeat as necessary.

Pete
0
s1m0neAuthor Commented:
Pete,

Since it is a subreport, there is no page header. Also, if the final page contains fewer than three columns, I want the header over only the columns with actual data.

This:

Item        Qty        Item        Qty
xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###
xxxxx     ###
xxxxx     ###
xxxxx     ###

Not this:

Item        Qty        Item        Qty        Item        Qty
xxxxx     ###        xxxxx     ###
xxxxx     ###        xxxxx     ###
xxxxx     ###
xxxxx     ###
xxxxx     ###

Any other ideas?

Thanks,

s1m0ne
0
panwangCommented:
Click Right Mouse,

Select Format Section, then, click 'details'

the right tab show 'Format With Multiple Column', Checked

The Tab Will Show 'LayOut',

Then You Can Do Continue
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

s1m0neAuthor Commented:
panwang,

This is what I had done before I posted the question. My issue is/was the lack of headers over all three columns.

----------

To all:

I came up with a somewhat (i.e. barely) workable solution. I suppressed Group Header #1 and moved the headers to Group Header #2, and added a conditional suppress formula:

Not (GroupNumber In [1,30,59, ... etc.])

This works, except it involves counting the items in each column, which must be done all over again if the layout is changed.

I'm leaving this question open, hoping for a better solution.

For instance, is there any function to determine if the current group is at the top of a column?

Thanks,

s1m0ne

0
s1m0neAuthor Commented:
LearnedOne,

Your recommendation makes sense to me, as my last comment contains useful information, but none of the other comments was helpful to me.

I have been here at EE for more than a year, but one thing is still not clear to me: What exactly is the questioner's responsibility with regard to inadequately answered questions?

Should I have requested that this question be PAQ'd within three weeks of my last comment?

At what point is having "abandoned" questions deemed abuse of the points system?

In my view, there is a big difference between asking a question and not responding to the experts' comments, and participating in a question while hoping (perhaps in vain) for further comments, one of which may be the desired answer.

I hope the intended tone comes across -- as a quest for enlightenment, not as an attack.

Thanks,

s1m0ne

P.S. Once a question get to this point (where a cleanup volunteer is involved) is the questioner expected to respond if he or she has no objection to the recommendation?
0
panwangCommented:
Thanks
0
moduloCommented:
PAQed, with points refunded (100)

modulo
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.