Solved

Multiple Columns - Displaying the Group Header over Each Column

Posted on 2003-11-04
8
309 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Formatting a Crystal Report 2 77
display n/a in column 2 36
can i install CR2016 alongside CR2008 without overwriting it? 4 53
free Crystal Report viewer 4 39
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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