Post reply

Prevent repeating space characters from being stripped from rendered report?

  • March 24, 2009 at 6:36 pm

    #219416

    I think this might just be an IE issue, but I am at a loss to control it and it is impacting reports with position sensitive strings.

    A simple example - create a report from this simple sql statement. Deploy and look at the output in a web browser (I am using IE7).

    select space(4)+'1' as str_len5

    And maybe try this: add a column to the report layout with row value as

    =Len(reportitems!str_len5.Value)

    Open report in browser, for me, the '1' character is left justified, yet the length is reported as 5 characters. It trims in the middle of strings too:

    select 'B'+space(4)+'1' as str_len5

    (redeploy) and report displays 'B 1' for me.

    Tried to export original report to xml and to csv, then I used notepad to open the xml and finding str_len5 shows <Detail str_len5=" 1" in the notepad window. Opening same xml in ie7 shows <Detail str_len5="1"

    Is it possible to prevent repeating space characters (white-space) from being stripped from rendered report?

  • March 24, 2009 at 6:53 pm

    #965748

    isn't it an html issue, where html does not respect whitespace, carriage returns, line feeds or tabs?

    so you need to replace spaces with & n b s p ; or char(160) to get the layout desired?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 27, 2009 at 4:57 pm

    #967797

    This function in the textbox worked. & n b s p did not work in the place of

    chr(160).

    =Replace(Fields!str_len5.Value, " ", Chr(160))

    Thanks this solved the problem, put me on the right track.

    🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply