I’ve tried searching on the archives for info about this but have had no luck so far…I am trying to see if there is a way to better format user responses when displaying them on a report. Currently, BusObj concatenates the response with a semi-colon and creates one long text string. Is this our only option? We are using 4.1.2/Oracle8.
Also, I would like to put a cell in the page header that begins on page 2 (and repeats for the document) rather than page 1, similar to a feature in MS Word. Is this possible?
< I’ve tried searching on the archives for info about this but have had no < luck so far…I am trying to see if there is a way to better format user < responses when displaying them on a report. Currently, BusObj concatenates
< the response with a semi-colon and creates one long text string. Is this < our only option? We are using 4.1.2/Oracle8.
I don’t have instant access to Business Objects right now and don’t remember the exact syntax of the match command, but try a formula that is similar to this:
Match(UserResponse(Data Provider Name), “;” , “Custom String - Could be Space”)
The idea is to search for a ‘;’ (semicolon) in the result of the UserResponse function and replace that with your own custom string - could be a space.
In a message dated 98-09-23 17:40:46 EDT, you write:
Also, I would like to put a cell in the page header that begins on page 2
(and repeats for the document) rather than page 1, similar to a feature in MS Word. Is this possible?
Cori:
I don’t think that you can have a cell that does not exist on page 1, starts on page 2 and continues for the rest of the document. What you can do is create a variable (formula) that only displays something on Page 2 and up. Something like:
= If Page()=1 Then “” Else "Page " + Page() + " of " + NumberOfPages()
which will put page numbers on page 2 - n, but skip page 1. Replace the “Else…” clause with your desired result.
The cell you create should probably not have a border, or shading, or anything else that would call attention to it on the first page. Perhaps you could adjust that with an alterter, but I did not test that.