Showing Description text

[Former Member]

Hi All

I have a report with columns PRODUCT NUMBER (from Product Master data), PRODUCT DESCRIPTION (from Product text table) AND SALES AMOUNT

The report shows the title Product Number and Sales Amount, but not the title for Production Description. Is there a way for me to either hardcode it, or get that title to show?

This is what I mean:

Product Number

xyz

zbc

etc

cpu

monitor

box

Sales Amount

500

200

50

I want the "Product Description" title to show up above CPU, instead of the blank.

Please help!

Thanks!

Pooja.

[former_member188975 · Accepted solution]

Hi Pooja,

Couple of options:

1. Type it in and save the workbook.

2. Write a VB macro to place the words in the specified cell

3. Make the description as an attribute of Product Number and then display the attribute in the report.

Hope this helps...

[Former Member · Accepted solution]

Thanks Bhanu!

I will go ahead and create the macro...

Pooja.