colums

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

Any suggestions on how to do the following report:

We run a query which gives us data on various products
with product information for each product.

The report page has 3 colums, we want the report flow
smoothly like a continous newspaper column i.e. at the
bottom of column 1 the report data continues from the top
of column 2 and so on.

At present the problem we are getting is that if there is
not enough space between the bottom of the last product
and the bottom of the page, the next product starts at
the top of the next column.


Thanking you in advance
 
Are you looking for 3 newspaper columns of equal length rather than varying
lengths of columns depending on the number of records and the length of the
page?
 
The method I use is to add a calculated column in the query that creates
values of 1, 2, or 3 based on the record's sorted rank. Then add three text
boxes to a report:
Name: txtOne
Control Source: =1

Name: txtTwo
Control Source: =2

Name: txtThree
Control Source: =3

Then create a narrow subreport of your previous detail records based on the
query where the top third records have a calculated value of 1, then next
third of 2, and the last third of 3. Add the same subreport to the main
report three times and set the Link Master/Child properties to the name of
your calculated column and one of the three text boxes.
 
Hi Duane

Does this method still work if:

1. If the report is greater than 1 page

2. If the product information section varies in size due
to text it contains. e.g.if there is not enough space at
the bottom of column 1 to take all of the product
information how will the remainder of that information
start at the top of column 2

Tom
 
1) I have only done this with data that all fits on a single page. You would
need to test it for multiple pages.
2) not sure, again you would have to test.
My uses have been for a limited amount of records that were all about the
same record size such as a phone list.
 
-----Original Message-----
Any suggestions on how to do the following report:

We run a query which gives us data on various products
with product information for each product.

The report page has 3 colums, we want the report flow
smoothly like a continous newspaper column i.e. at the
bottom of column 1 the report data continues from the top
of column 2 and so on.

At present the problem we are getting is that if there is
not enough space between the bottom of the last product
and the bottom of the page, the next product starts at
the top of the next column.


Thanking you in advance
Click to expand...
Hi,
If you go to sorting and grouping, make sure that
the "keep together" property is set at "none" for all of
your group headers and footers. You also might check the
property box for your footers. Click on the Footer bar
in design view and then click on the property box. There
are a couple of controls that you might find helpful,
such as: "Force New Page" and "New Row or Column" these
should be set to "none",. You also might want to click
on the Group Header bar and view properties: click
on "Repeat Section" and this put the heading at the top
of the next column, should the data be separated (ex.
starts at the bottom of col 1 and continues in col 2.)
Hope this is helpful.
 
Hi

Thanks for your input

Can you please clarify "click
on "Repeat Section" and this put the heading at the top
of the next column, should the data be separated (ex.
starts at the bottom of col 1 and continues in col 2.)"

Tom
 
Back
Top