help on generating report

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

Guest

Hi, I am a fresher here and now meeting a problem when designing a report.

I want to let the results shown in rows instead of in columns. Anyone could help me do this? For example, in the table, two columns are

A1 B1
A2 B2
A3 B3

When the report is genereted by default, it shows

A1 B1
A2 B2
A3 B3

However, I want them to be shown as

A1 B1 A2 B2 A3 B3

And it is difficult to use multi-column report, because there is a grouping variable. Is there any way around?
Can anyone help me out? It is really urgent. Thanks a lot for your help in advance!
 
If a multi-column report doesn't work for you , this would
most likely have to be done totally with VBA code, probably
populating a temporary table to base the report on.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
Hi, I am a fresher here and now meeting a problem when designing a report.

I want to let the results shown in rows instead of in
Click to expand...
columns. Anyone could help me do this? For example, in the
table, two columns are
A1 B1
A2 B2
A3 B3

When the report is genereted by default, it shows

A1 B1
A2 B2
A3 B3

However, I want them to be shown as

A1 B1 A2 B2 A3 B3

And it is difficult to use multi-column report, because
Click to expand...
there is a grouping variable. Is there any way around?
 
Thanks a lot. But I have no background on VBA. :-( Can sub-report do it? I have searched for reference, but have not found any useful yet.
 
Not sure how a subreport could if a regular report can't.
Now, here is a thought. Would setting up a subreport that
uses columns and placing it in your group footer do the job?
I can see where a setup like that may work although I have
never tried doing it myself.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
Thanks a lot. But I have no background on VBA. :-( Can
Click to expand...
sub-report do it? I have searched for reference, but have
not found any useful yet.
 
Thanks. I will try it tonight. Hope it works.

This problem comes from a reference management. I have two tables, one is publication table, including PubID, title. The other is an author table, inlcuding PubID, autherID, surname, first name, order(which means if the auther is the first, second, third.... auther.

Now I want to generate the reference. So the form should be author1, auther2, auther3,..autherN, title. But after grouping, the form of the report is lik
Author
Auther
..
title(PubID as group variable

I have no idea how to change it. :-(
 
Will,

I did some experimenting and came up with a solution that
will do what you want, although title should probably be
above or at the beginning of your row of authors.

Create a report on a query that ties the two tables together
and put nothing on it but the author field at the very left.
I would probably lose the label attached to the text box.
Now in Page Setup set it to have 4 or 5 columns ordered
horizontally. Play with this to see how the names fit.

Now on your main report, or a new one if you like, Group by
Title. If you want the title to be first drop the title
field in the GroupHeader and then drop a SubReport control
in the header as well just to the right of it and assign the
control to use your first report with the columns and make
sure that it's CanGrow property is set to Yes. Go to Preview
and you should see your rows of Authors. You will need to
play with sizing the subreport and controls to get it right
probably. You could also place the subform under the title
control if you like, just don't put it in the detail section
or you will end up with a row for every author that you
have.

Let me know how it works.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
Thanks. I will try it tonight. Hope it works.

This problem comes from a reference management. I have two
Click to expand...
tables, one is publication table, including PubID, title.
The other is an author table, inlcuding PubID, autherID,
surname, first name, order(which means if the auther is the
first, second, third.... auther.
Now I want to generate the reference. So the form should
Click to expand...
be author1, auther2, auther3,..autherN, title. But after
grouping, the form of the report is like
 
Back
Top