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
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?