Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

10 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 08:03 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 09:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 09:07 AM

    Post Author: amr_foci

    CA Forum: WebIntelligence Reporting

    could you use this formula in a variable?

    this may save time calculating cells again

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 10:03 AM

    Post Author: Nita_here

    CA Forum: WebIntelligence Reporting

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 10:10 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 11:12 AM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:44 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 05:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2008 at 04:14 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2008 at 07:46 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.