Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Multiple Columns - Displaying the Group Header over Each Column

Posted on 2003-11-04
8
Medium Priority
?
312 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
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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. …
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

609 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