2 column report

[Alp Bekisoglu]

Hi All,

One more on reporting:
How do I restrict the output of a report (set as 2 columns) so that I
actually get
the 8 lines of data as 2 columns of 4 and 4? It does it when I set across
then down, but it needs to be down then across.

Thanks,

Alp

 

[Marshall Barton]

One more on reporting:
How do I restrict the output of a report (set as 2 columns) so that I
actually get
the 8 lines of data as 2 columns of 4 and 4? It does it when I set across
then down, but it needs to be down then across.

If you really know ahead of time hpw many records are in the
report, then you can use a subreport set to Down then
Across, but only if you set the subreport control just tall
enough for 4 records and set CanGrow to No.

 

[Alp Bekisoglu]

Thanks Marsh,

I have dealt with it by creating 2 queries and 2 reports. I was curious why
the down-then-across is not sizeable since across-then-down splits the info
exactly into two sections.

Alp

 

[Marshall Barton]

I have dealt with it by creating 2 queries and 2 reports. I was curious why
the down-then-across is not sizeable since across-then-down splits the info
exactly into two sections.

Way to go! The messy two subreport approach is a tricky way
to do this.

Another,even trickier, way is to use calculated fields in
the report's record source query:

SELECT table.*,
(SELECT Count(*)
FROM table As X
WHERE X.sfld < table.sfld
) As RecNum,
(SELECT Count(*)
FROM table
) As TotalRecs,
(2 * RecNum) \ TotalRecs + 1 As ColNum
FROM table
ORDER BY sfld

The ColNum field calculates the column number (1 or 2) and
the reports groups on this field with the group header's
NewColumn set to Yes.

 

[Alp Bekisoglu]

Thanks again for your advice. Wouldn't it be a nice option if Access offered
an option to allocate the source data evenly across colums, regardless of
the parsing method; dta or atd, once column value is set to more than 1 that
would be quite useful?
Maybe in Access 3058....

Alp