RS stripping spaces from my text

Yello,
We have a very simple report that lists the contents of a table called
GenericReport that contains one field of varchar(120). All the report needs
to do is list the records in this table.
Unfortunately, I'm finding that RS will pick up the text from a record, and
strip out any spaces at the beginning. Which in turns destroys the
formating of the text - removing any indents created by padding with spaces.
The report doesn't do it when previewed from the designer, but does it when
rendered in the browser via report manager.
Anyone have experience of this, or know how to stop it.
Thanksbump
"Martin Cross" <martincross@.vardells.com> wrote in message
news:ubJdNSTpEHA.1164@.TK2MSFTNGP10.phx.gbl...
> Yello,
> We have a very simple report that lists the contents of a table called
> GenericReport that contains one field of varchar(120). All the report
> needs to do is list the records in this table.
> Unfortunately, I'm finding that RS will pick up the text from a record,
> and strip out any spaces at the beginning. Which in turns destroys the
> formating of the text - removing any indents created by padding with
> spaces.
> The report doesn't do it when previewed from the designer, but does it
> when rendered in the browser via report manager.
> Anyone have experience of this, or know how to stop it.
> Thanks
>
>|||The behavior your are encountering is a result of how IE handles adjacent
whitespace characters.
We have looked into changing this behavior but doing so introduces worse
problems with regards to search and wordwrap.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Cross" <martincross@.vardells.com> wrote in message
news:ubJdNSTpEHA.1164@.TK2MSFTNGP10.phx.gbl...
> Yello,
> We have a very simple report that lists the contents of a table called
> GenericReport that contains one field of varchar(120). All the report
needs
> to do is list the records in this table.
> Unfortunately, I'm finding that RS will pick up the text from a record,
and
> strip out any spaces at the beginning. Which in turns destroys the
> formating of the text - removing any indents created by padding with
spaces.
> The report doesn't do it when previewed from the designer, but does it
when
> rendered in the browser via report manager.
> Anyone have experience of this, or know how to stop it.
> Thanks
>
>|||Is it possible to include adjacent " " elements in a textbox to display
whitespace beyond one space? Or any html tags to be included in the
displayed report?
My problem is that I have multiple row groups in a matrix report. I'm
trying to provide headers for the row groups. The column headers for each
row group have been merged into one textbox which I can't split. If I could
insert spaces, I could at least provide a spaced string with labels
positioned above the row groups. It is confusing to the user to have
multiple row groups with no headers above them.
Thanks
Bill
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:exKUjGXpEHA.132@.TK2MSFTNGP14.phx.gbl...
> The behavior your are encountering is a result of how IE handles adjacent
> whitespace characters.
> We have looked into changing this behavior but doing so introduces worse
> problems with regards to search and wordwrap.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Martin Cross" <martincross@.vardells.com> wrote in message
> news:ubJdNSTpEHA.1164@.TK2MSFTNGP10.phx.gbl...
> > Yello,
> > We have a very simple report that lists the contents of a table called
> > GenericReport that contains one field of varchar(120). All the report
> needs
> > to do is list the records in this table.
> >
> > Unfortunately, I'm finding that RS will pick up the text from a record,
> and
> > strip out any spaces at the beginning. Which in turns destroys the
> > formating of the text - removing any indents created by padding with
> spaces.
> >
> > The report doesn't do it when previewed from the designer, but does it
> when
> > rendered in the browser via report manager.
> >
> > Anyone have experience of this, or know how to stop it.
> >
> > Thanks
> >
> >
> >
>|||I've tried replacing spaces with but Reporting Services converts this to
when it renders the report. So, obviously it's converting certain
characters to their HTML code values but not spaces. Has anyone found a way
to write into a report and have it render as a space?
Thanks,
Mark
"bill" wrote:
> Is it possible to include adjacent " " elements in a textbox to display
> whitespace beyond one space? Or any html tags to be included in the
> displayed report?
> My problem is that I have multiple row groups in a matrix report. I'm
> trying to provide headers for the row groups. The column headers for each
> row group have been merged into one textbox which I can't split. If I could
> insert spaces, I could at least provide a spaced string with labels
> positioned above the row groups. It is confusing to the user to have
> multiple row groups with no headers above them.
> Thanks
> Bill
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> news:exKUjGXpEHA.132@.TK2MSFTNGP14.phx.gbl...
> > The behavior your are encountering is a result of how IE handles adjacent
> > whitespace characters.
> > We have looked into changing this behavior but doing so introduces worse
> > problems with regards to search and wordwrap.
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Martin Cross" <martincross@.vardells.com> wrote in message
> > news:ubJdNSTpEHA.1164@.TK2MSFTNGP10.phx.gbl...
> > > Yello,
> > > We have a very simple report that lists the contents of a table called
> > > GenericReport that contains one field of varchar(120). All the report
> > needs
> > > to do is list the records in this table.
> > >
> > > Unfortunately, I'm finding that RS will pick up the text from a record,
> > and
> > > strip out any spaces at the beginning. Which in turns destroys the
> > > formating of the text - removing any indents created by padding with
> > spaces.
> > >
> > > The report doesn't do it when previewed from the designer, but does it
> > when
> > > rendered in the browser via report manager.
> > >
> > > Anyone have experience of this, or know how to stop it.
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
>
>