report in columns?

[jlnewbie]

I've been able to generate my report in columns but is there a way not to repeat the text names for all the data. example:

Sample 1 2 3 4
Date 01/03 02/03 02/03 03/03
ID jl pl jk pk
Percent 50 80 90 91

Presently the names are repeated for each column and does not look as clean as my example. I'm using access 97
Thank you


JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[hermanlaksko]

If I understand you correct you could put your text on the reports page header the header is also independant of the amount of columns in the report detail.

If, however, you want not to repeat text on the actual detail of the report set "Hide duplicates" to yes, you will find this under format for the field.

Rgds Herman

 

[jlnewbie]

thanks Herman:
Presently my column report looks like this

Sample 1 Sample 2 Sample 3 Sample 4
Date 01/03 Date 02/03 Date 02/03 Date 03/03
ID jl ID pk ID jl ID kl
Percent 60 Percent 85 Percent 90 Percent 95
whereas this is what I need
Sample 1 2 3 4
Date 01/03 02/03 02/03 03/03
ID jl pk jl kl
Percent 60 85 90 95



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[hermanlaksko]

Are the "Sample/Date" etc labels or what are they, if they are labels they chould easely be removed.
Herman

 

[jlnewbie]

Yes they are labels, but if I remove the labels in the detail section all of them will be removed. Even the first column.
thanks again

JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[hermanlaksko]

Maby you should try changein the look on the report to this:

(Report Page Header)
Sample Date ID Pct ETC.
(Report Detail)

1 02/03 jl 85
2 03/03 pk 60
3 04/03
4

Herman