BusinessObjects Board

Chaging Object value at Universe

building reports crystal reports legacy
#1

Hi All,

Iam having an Object “ServerName” in teh universe and that name will be in this format “Primary:A001-DBS0384-S:NT”

Now i want this Name should be displaye as “A001-DBS0384-S” so i have used the Subsrt function
substr(‘abcd:ef’,1,instr(‘abcd:ef’,’:’)-1)

to remove the Primary: and :NT from the server name .its working fine but the main concern is that the Query performace as bee Decreased alot
can anyone sugest me if there is anything alternative to concatenate the ServerName and the query performace should also be Good.

Thanks in Advance,
Kumar.

kumarpjp (BOB member since 2009-04-13)

#2

Are you doing the Substr in the Universe or in the report?

-Dell

hilfy :us: (BOB member since 2007-04-16)