Question:
Hi Gurus,
Our user wants to have "Vendor Name" printed on the column header, when ever he uses vendor infoobject in this reports. Can this be done..?
In more detai:
NOW WE HAVE:
vendor Amount
234689 MCI Worldcom INc. $2300.90
They Want:
vendor vendor name Amount
234689 MCI worldcom Inc. $2300.90
They want the "vendor name" column label to come up every time. I tried to save it on the workbook. It saved and remain there until they refresh with a new selection criteria.
Any inputs please....
Thanks
- Jim
Answer:
I believe you have to do this with VB... don't know how else you could solve it. If you don't use VB, BW will always reformat it's "own" area. Any VB coding runs after the formatting has been done.
cheers,
El Belgio
Answer:
Hi El,
I know VB. I do not know how to write in excel. Can you give me details and a sample vb code.
Thanks
- jim
Answer:
In each workbook there is a module SAPBEX available with a routine SAPBEXonRefresh. There you have 2 variables queryID and resultArea. The resultArea of your workbook is actually complete at the moment this VB routine is accessed. You just need to adapt the first row of it.
cheers,
El Belgio