By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

Rows and Columns

rcollins
100+
P: 234
I have a report that the boss would like to see in rows rather than columns. I am a bit confused on how to do this. Here is what I have now:
Funding (Funding header)
Name (ClientName header) Duration Total
Phase (Phase header) Duration
Here is what I want:
Funding (Funding header)
Name (ClientName header) Duration Total
Phase Phase Phase
Duration Duration Duration
I am confused on how to do clumns this many levels in. I know how to make the whole report do multiple columns. Please help, thanks
PS I coul do a printscreen if needed to see
Feb 21 '08 #1
Share this Question
Share on Google+
6 Replies


cori25
P: 83
send a print screen please
Feb 21 '08 #2

NeoPa
Expert Mod 15k+
P: 31,768
I'm a bit rusty on this, but if you cannot set columns simply for the detail section, then you may need to consider creating a (columned) subreport to handle the details.
Does this answer your question?
Feb 22 '08 #3

rcollins
100+
P: 234
Right at the moment I have it kind of set up, but not quite the way I would like it.
I have it to where it puts the phases in columns, but it is kind of screwed up. I would like it to put spaces where the phases are empty, so that the phases "Extended Services", "Mentoring" and "Unbillable" phases all line up, but theyy dont. I also have page breaks between funding, which is the top level of grouping, and when one of these groups runs onto a second page the columns are off, putting the names in with the columns. I am not sure what I am doing wrong.
Feb 22 '08 #4

NeoPa
Expert Mod 15k+
P: 31,768
...
I am not sure what I am doing wrong.
I've no idea what you're doing so don't look at me :D

To be able to help I'd need you to explain what you've done to separate the Phases into columns. That's always assuming I can remember what needs to be done when I understand the situation, but I'll try at least.
Feb 22 '08 #5

rcollins
100+
P: 234
I am not sure what I am tring to do myself half the time :)
So I took your advice and tried subreports...did the trick...the boss likes the way it turned out. Now for a more challenging one...

** Edit ** See Selective Unmatched Query.
Feb 22 '08 #6

NeoPa
Expert Mod 15k+
P: 31,768
I'm pleased to hear it :) Be warned though, that multiple-columned sub-reports can be a bit of a struggle to maintain. Try to convince said boss(es) that it's perfect now and never to request any changes ;)

I've split your other question into the new thread.
Please continue with that across in the other thread.
Feb 23 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.