Variables in a text

building reports webintelligence
1

I have certain report variables such as start date and end date. I wish to use them in a text

say:
" The report is between [Min_start_date] and [Max_Start_Date]"

How do I do the same in WEBI XI.
In full client I believe that we could add a %age or a $ sign and it would work.

apoorv (BOB member since 2005-08-30)

2

Hi,

If both objects are string that this will work:

="The report is between " + [Min_start_date] + " and " + [Max_Start_Date]

If the objects are of a date type then you need to convert them to strings using FormatDate() function first and then do the concatenations with other string(s) using “+”

Marek Chladny :slovakia: (BOB member since 2003-11-27)