Column Wrapping?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have a report with a variable number of columns, each with a subtotal. My
problem is that I have from 1 to 6 columns per record and I only have room
for 3 wide. Is there any way to have the columns wrap so that I get three
wide and the next three end up down the page?

Thanks,

Jim
 
sure, just put the fields accross the page in the detail section that will
fit, then put the controls for the other three under the first ones.
like...
 
Unfortunately, it's not separate fields I need to fit, but different series.
I have a query with a customer and the tickets they bought last year. The
report shows how many tickets they bought for up to six shows, in up to six
separate columns. The series header shows the name of the show, the detail
lists the seats purchased and cost, and the series footer gives a subtotal of
the cost per show.

I need to figure out how to make the entire series (header, detail, and
footer) columns start again underneath the first three.

Thanks for the help, hopefully I've given enough info to be a bit more
helpful.

Jim Crowley
 
I don't really have an answer, but I ended up finding a usable work-around.

I had originally included a column break before the group header. What I
did was removed that break and let there be two groups down if there was
room. Then I made sure that group was kept together in the "sorting and
grouping" settings. That maximized my space and now I'm able to fit
everything.

However, if anyone can supply a true answer to my original question, I would
still love to know what it is.

Jim
 
One suggestion would be like this:

Give the first 3 shows the same code in a seperate field,
and the second 3 shows another code f.ex

(1)
Show 1
Show 2
Show 3

(2)
Show 4
Show 5
Show 6
How you put the code it depends how Show Names are Save or
Coded Before.
And after that in Report Group by Code (1) and Code (2)
the headers of the code (1) and 2() will have the name of
shows (3) and details (information cost and purchased
whatever you have).

Hope this idea help (of course it depends on Normalization
and Designing also)

Thanks,
MArsela
MOS-MCP
 
Back
Top