Multiple column report

[linda sciallo]

I have a subreport that has data in one column as follows:

100 Pending
Events
1100
1105

200 Pre Inspection
Events
1200
1205
1210
1215

I want to fill the page going down the first column. When the first column on the page fills up, I want to continue displaying data in the second column (see example below):

100 Pending 200 Pre-Approval
Events Events
1100 1200
1105 1205
1210
1215

(end of page)

How can I accomplish this??

 

[dhoffman]

This is supposed to work. It worked for me once, but I'm having trouble with it now.
Just open your subreport in design view. Go to file->PageSetup. Go to columns and set it to two columns then uncheck the checkbox halfway down and set the column width to be the width of one column. Make sure the width is small enough to fit two columns on the page.

I did this before, however it is not working for me now. I have a subreport that prints in two columns if I open it by itself. However when I open the main report the subreport suddenly only prints in one column. I am sure I have enough room for both columns. I have gotten this to work before. This is really pissing me off, please help!

 

[linda sciallo]

I tried that prior to posting my question and it did not work.

It works if I run the subreport independent of the main report.

Once I put the subreport in the main report, it lists all the data in one column.

Has anyone been able to do this successfully??

 

[pcs]

yeah i have done it. have you tried increasing the width of the subform control (pull it out to close to the page width of your main form). the subreport wizard usually seems to make to subreport control too narrow, which will cause it to print in one col.

hth,
al

 

[dhoffman]

that does not help me at all. Thanks anyway.

 

[pcs]

dhoffman,

sorry i was of no help at all to you. but, it works when i do it.

maybe you could provide more details abt. what you are trying to do in your report. it may be more complex than the ones that i have done.

al

 

[dhoffman]

It's a very simple report. There is a one to many relationship between the main and sub report. The main report is very normal with one column. The subreport prints in two columns if I open it by itself. However it only prints in one column when I open the main report. I realize it is hard to imagine anything other than sizing or spacing being the problem here. Perhaps it is, but I have done everything I can think of to make the sizing and spacing correct. I had this working once before actually, but I deleted that report for other reasons. I must be doing something wrong, something very minor, but I can't thinkof anything. Could there be any properties that I am forgetting to set to a certain value?

 

[dhoffman]

to Linda Sciallo:

I bet if you go to the page setup and make your columns go across and then down that it will work. I found that out after *@&#ing around with it for a while. Of course, acroos and then down is not what I want either. It needs to go down one column until half the records are met or the end of the page (whichever comes first). I think for some reason that one will achieve that affect if things are set up properly because I believe that is how I had it before.

 

[linda sciallo]

I tried that, but it not display the data
down the first column and then start in the second column when the first column is full.
It displayed alternate rows in the first and second columns (like below):

100 Pending Events
1100 1105

200 Pre Inspections Events
1200 1205
1210 1215

I wound up doing two queries and two reports:
the first query and report displays the data in the first column, and the second query and report displays the data in the second column
(I shouldn't have to do it this way, but it was only way I could get the data to display
correctly).

 

[dhoffman]

How did you get each subreport to only display half of the records?

 

[Fornatian]

Why not include the two queries in another query and set the join type so that records are shown on both sides regardless of data.

 

[linda sciallo]

to dhoffman:

In the Report Footer area (in Design view), I
created two subreports that are side by side.
The first subreport contains the first query and report which retrieves the first half of the data from the table. The second subreport contains the second query and report which retrieves the second half of the data from the table. It works like a charm!