topic Re: problem in reports in Application Development and Automation Discussions

problem in reports

Former Member — Wed, 15 Nov 2006 06:00:20 GMT

hi experts,

I have created one report in that there is 8 columns.Out of this eight column 3 columns are related to each other.so i want to display these three column in different color.How to do this.

regards,

Ashok.

Re: problem in reports

Former Member — Wed, 15 Nov 2006 06:02:31 GMT

Use Alv list

Re: problem in reports

Former Member — Wed, 15 Nov 2006 06:02:51 GMT

write: itab-filed1 color 3,itab-filed2 color 4,itab-filed3-color5.

Re: problem in reports

Former Member — Wed, 15 Nov 2006 06:03:24 GMT

R u using alv to displa the output?

Have a lok at below links It ll help you.

http://www.sap-basis-abap.com/abap/color-a-column-value-in-alv-report.htm

Best Regards,

Vibha

*Please mark all the helpful answers

Re: problem in reports

former_member283648 — Wed, 15 Nov 2006 06:08:20 GMT

Hi,

While Printing those fields, you can set color using the ABAP command format like the following. for more colours list you can refer to SAP online help documentation.

... COLOR n [ON] or ...COLOR OFF

Effect

Color of line background. n can have the following values:

OFF

or COL_BACKGROUND

Background (GUI-specific)

or COL_HEADING

Headers (grayish blue)

or COL_NORMAL

List body (bright gray)

or COL_TOTAL

Totals (yellow)

or COL_KEY

Key columns (bluish green)

or COL_POSITIVE

Positive threshold value (green)

or COL_NEGATIVE

Negative threshold value (red)

or COL_GROUP

Control levels (violet)

Re: problem in reports

Former Member — Wed, 15 Nov 2006 06:12:40 GMT

Hi Ashok

It's simple.

In your write statement mention color for the three fields.

Ex.

WRITE 😕 FIELD1, FELD2, FIELD3 COLOR 1, F4, F5, F6 COLOR 1, F7, F8, F9 COLOR 1.

(assuming 3,6,9 are related).

Regards

Surya.

Re: problem in reports

Former Member — Wed, 15 Nov 2006 06:33:13 GMT

hi Ashok,

do as follows, it will solve your problem.

loop at itab.

write:/ itab-field1 color 3,itab-field2 color 4, itab-field3,itab-field4 color 4......

endloop.

so it will fill the color for the fields 1,2,4 but not for 3.

thanks,

Murali

Re: problem in reports

Former Member — Wed, 15 Nov 2006 06:33:15 GMT

Hi,

in your case you can go for ALV list, and make those three columns as key fields, then they appear in different colour. and also alv coding is simple and faster.

you need not to do any formatting.

Regards

Vijay