Solved

Multiple Columns - Displaying the Group Header over Each Column

Posted on 2003-11-04
8
310 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

 
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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

688 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