You can change the width of this line with specific property (lineheigt) on that TABLEROW object. You must complete the "write" expression on that property and the results are fine.
For example you can use the function posted below to get the number of occurence of char(13) character.
TABLEROW1.LineHeight= n*(1-occurs(@.yourstring,char(13))
Create function occurs
(
@.iStr varchar(4000),
@.fStr varchar(100)
)
Returns smallint As
Begin
Declare @.rStr varchar(100)
Select @.rStr = case when charindex(left(@.fStr,1),@.fStr,2)>0 then stuff(@.fStr,charindex(left(@.fStr,1),@.fStr,2),0,'~') else Replicate('~',datalength(@.fStr)+1) end
Return(datalength(Replace(Replace(@.iStr,@.fStr,@.rStr),@.fStr,@.rStr)) - datalength(@.iStr))
End
No comments:
Post a Comment