Non-Breaking Space in Calculated Field

[brucepeaslee]

I have a field that computes how long an issue has been pending:

CASE

WHEN (IsDate([@field:Date_Closed])=0) THEN 

stuff('_Days',1, 0, Ltrim(STR(DateDiff(day,[@field:Date_To_HOA],GetUTCDate()))))

ELSE stuff(' ',1,0,'(Closed)')

END

Note that I have an underscore before 'Days' in the first stuff function. If I leave this out, the result appears on two lines if the number of days exceeds 99.

101

Days

I tried putting   there, but that didn't work. I have also been unable to make the column wider, which might solve the problem.

[ShWolf]

Hi,

It would be easier if you provide link to your DataPage.

You can try to change Wrap Text to No Wrap in the style wizard (Result Page -> Table Layout -> Data Cells)

Let me know if this help.

[brucepeaslee]

"No Wrap" impacts all the columns, so that won't work. Here is the link: http://hydeparkvallejo.com/IssueTrax4Leads.html

Thanks.

[ShWolf]

Hi,

As a workaround, try to pass an empty parameter to the Calculated field label which will increase column size.

By the way, I've tried to create a DataPage with your data and it looks fine

Maybe problem in your style. Try to create a new style without any changes and apply it to this DataPage.

Let me know if this helps.