Append hyphen automatically after the wrapping of text in the dimension field

[Former Member]

Post Author: Nita_here

CA Forum: WebIntelligence Reporting

I want to Append hyphen automatically after the wrapping of text in the dimension field.

e.g the text reads "I want to wrap this text". then if cell width exceeds after "I want to wrap" then it should be displayed like this "I want to wrap-" "this text".

Thanks in advance,

Nita

[Former Member]

Post Author: monjes

CA Forum: WebIntelligence Reporting

If it's auto-adjusting the column width, your "Autofit width" is probably turned on. Turn it off by going to the Display property called "Autofit width" for that column.

[Former Member]

Post Author: Rohini

CA Forum: WebIntelligence Reporting

Hi Nita,

It might be late... but if you still have this problem, then probably you can try as follows:

The column in which you would like to wrap the text, you can split it into 2 variables. for eg. A = @B + @C. Then define @B in terms of left(A,12) and @C = ' - ' + substr(A,12). Then replace the column with the wrap text with A.

Thanks,

Rohini.

[Former Member]

Post Author: Nita_here

CA Forum: WebIntelligence Reporting

Thanks for your input.

Let me tell you what I have understood. I will create a variable having the formula (which i have earlier written) in universe. Whenever i need to use the formula in infoview, I will call the variable instead. That's fine. But again, I will have the same problem. If I do any change in infoview level, the cell width is bound to change as it is not the free standing cell, its a column among othe one. e.g.

A B C

1 2 3

4 5 6

(you can think B as the column). Any change(addition, deletion of columns) will certainly change the cell width of B. So, again I need to calculate the things, which i dont want.

Nita_here: I manually calculated that after 12 characters, the cell wraps the text.

I wonder if there would be a way to do the things dynamically.

Thanks in advance,

Nita

[Former Member]

Post Author: amr_foci

CA Forum: WebIntelligence Reporting

there is no way for universe to check the cell width in infoview, wat i meant that you add this formula you done before in the universe level

[Former Member]

Post Author: Nita_here

CA Forum: WebIntelligence Reporting

I have really no idea in this case, how universe will check whether the total number of characters in a cell is exceeding the cell width in infoview?

[Former Member]

Post Author: amr_foci

CA Forum: WebIntelligence Reporting

there is no way to do this at the universe level?

thats may fix much of problems

[Former Member]

Post Author: Nita_here

CA Forum: WebIntelligence Reporting

But I dont want to do the calculation manually, is there anyway to handle it automaticaly.

[Former Member]

Post Author: amr_foci

CA Forum: WebIntelligence Reporting

could you use this formula in a variable?

this may save time calculating cells again

[Former Member]

Post Author: Nita_here

CA Forum: WebIntelligence Reporting

I have already set the properties as 'Wrap Text'. But the problem is, I want to automatically append the hyphen after the text is wrapped. The text is not always same.

I used this kind of solution:

I manually calculated that after 12 characters, the cell wraps the text. So, I am applying the following logic: =If(Length(Trim([dim_obj]))>12;Substr( Trim([dim_obj]);1;10)"-"Substr( Trim([dim_obj]);10;Length(Trim([dim_obj])));[dim_obj])

But this solution is not flexible. When I append, change or delete cells, the cell width will change and again i need to manually calculate all things.

Thanks,

NIta

[Former Member]

Post Author: amr_foci

CA Forum: WebIntelligence Reporting

choose the cell you want to wrap. and go to the "properties" panel , expand "text format" and then Flag "Wrap text" to yes

good luck