Question:
Hi,
is there any way to modify the text displayed (not assigned or #) in a query when the characteristic is not reported?
Our client want blank to be displayed instead.
Thanks in advance.
Sheila.[/img]
Answer:
Hi,
This is snatched from www.sap.com/community, so its not my solution, but it seems to work:
_________________________________________________________
I think the best method is using VBA - here an example how to replace "Not assigned" with " "
You find the programming in the Excel Workbook:
Tools --> Macros --> Visual Basic Editor (or Alt+F11)
Then create a "Module" in "VBA Project (Workbook-ID)" where you can input the VBA-Code on the right side of the screen.
After saving, the VBA-Code is active for the relevant Workbook.
Example Code:
Sub SAPBExonrefresh(queryID As String, resultArea As Range)
For Each c In resultArea
If c.Value = "Not assigned" Then
c.Value = " "
End If
Next
End Sub
__________________________________________________________
The entire thread can be found here -> http://www.sap.com/community/int/forums/ShowPost.aspx?PostID=183382#184974
Regards,
-Jacob