Hi everybody,

i have a very Little question, that bothers me a lot
there is a Report working fine, everything done, it has 10+ columns.

now the "challenge" is that the first 4 columns have Information about customer, the next 5 about Products etc.

now i Need to add a "text" / "box" whatever, with Title: "Customer" and a Title "Products" over the Columns.

Is there any way to do this???

Kind regards and thx a lot
Jack

This message has been edited. Last edited by: <Emily McAllister>,

You could create a DEFINEd field that contains Customer or Product depending on the value of the columns you are printing. Then Sort across this new DEFINEd field.

That, or you could do what my colleague did and color-code zones of columns by title, like so:

-*BLUE
TYPE=TITLE, COLUMN=MFSMX, 	 	COLOR='BLACK', BACKCOLOR=RGB(155 195 230), $
TYPE=TITLE, COLUMN=MFSALES, 	 	COLOR='BLACK', BACKCOLOR=RGB(155 195 230), $
TYPE=TITLE, COLUMN=SALESDIFFPCT,   	COLOR='BLACK', BACKCOLOR=RGB(155 195 230), $
TYPE=TITLE, COLUMN=SLS_IND,	 	COLOR='BLACK', BACKCOLOR=RGB(155 195 230), $
TYPE=TITLE, COLUMN=MFSALESCHG, 		COLOR='BLACK', BACKCOLOR=RGB(155 195 230), $

-*PINK
TYPE=TITLE, COLUMN=LBRCMT, 	 	COLOR='BLACK', BACKCOLOR=RGB(255 175 175), $
TYPE=TITLE, COLUMN=LBRDIFFPCT, 		COLOR='BLACK', BACKCOLOR=RGB(255 175 175), $
TYPE=TITLE, COLUMN=LBRPCT_IND, 		COLOR='BLACK', BACKCOLOR=RGB(255 175 175), $
TYPE=TITLE, COLUMN=LBRPCT, 	 	COLOR='BLACK', BACKCOLOR=RGB(255 175 175), $
TYPE=TITLE, COLUMN=MFTOTWAGES, 		COLOR='BLACK', BACKCOLOR=RGB(255 175 175), $
TYPE=TITLE, COLUMN=MFNONMGROTWAGES,	COLOR='BLACK', BACKCOLOR=RGB(255 175 175), $
TYPE=TITLE, COLUMN=MFSPH,	 	COLOR='BLACK', BACKCOLOR=RGB(255 175 175), $

-*ORANGE
TYPE=TITLE, COLUMN=MFGC, 	 	COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $
TYPE=TITLE, COLUMN=MFGCCHG, 	 	COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $
TYPE=TITLE, COLUMN=GCPCTCHG, 	 	COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $
TYPE=TITLE, COLUMN=MFGCPN, 	 	COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $
TYPE=TITLE, COLUMN=MFTICKET, 	 	COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $
TYPE=TITLE, COLUMN=MFTICKETCHG, 	COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $
TYPE=TITLE, COLUMN=TICKETCHGPCT,	COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $
TYPE=TITLE, COLUMN=MFGGCPCTCHG,		COLOR='BLACK', BACKCOLOR=RGB(239 182 98), $

... or you could try looking at previous posts such as this one to get some ideas.

Remember to do a search first, it could save you a lot of time whilst you sit around twiddling your pearls waiting for someone to give you a solution

T