2 column report

  • Thread starter Thread starter Alp Bekisoglu
  • Start date Start date
A

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
 
Alp said:
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.
Click to expand...

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.
 
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
 
Alp said:
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.
Click to expand...

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.



 
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
 
Back
Top