Solved

Multiple Columns - Displaying the Group Header over Each Column

Posted on 2003-11-04
8
308 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:s1m0ne
8 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 9682453
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
 
LVL 1

Author Comment

by:s1m0ne
ID: 9682570
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
 

Expert Comment

by:panwang
ID: 9775802
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:s1m0ne
ID: 9781011
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
 
LVL 1

Author Comment

by:s1m0ne
ID: 11823779
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
 

Expert Comment

by:panwang
ID: 11826882
Thanks
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11860310
PAQed, with points refunded (100)

modulo
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question