Add text to a business objects text box with a function

Andrewtow
Andrewtow used Ask the Experts™
on
Hi there.

I'm wanting to have a text box say "Last refresh time <date>"

Not sure how to do this.. thinking something along the lines of "[text saying last refresh time] =LastExecutionDate()" or something - but not sure of the syntax..
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
PrintDate and PrintTime are the formulas you need, so you can just convert them to strings and put it together in a formula:
"Last Refresh: " + CSTR(PrintDate) + " " + CSTR(PrintTime)
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
That works or create a text box on the report with the text you want then drag the PrintDate and PrintTime fields into it.  You can put spaces between the fields if you want.

mlmcc

Author

Commented:
Neither of these work.. it just displays the text "Last Refresh: " + CSTR(PrintDate) + " " + CSTR(PrintTime) in the text cell..

I'm using Business Objects Web Intelligence..

Author

Commented:
I figured out what you meant by adding strings, so you got the solution, thx. (could have done with a bit more explaining though, i'm a newb!)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial