reporting services - Can I get a tab to display in a rendered report? -


I have created an RDL report and do not appear in the reports generated after presenting any tab character within my returned data. Is it possible to display tab character? (Users want to show the basic formatting of their 'Comment' field.) The tabs added to RDL are retained, but the data was being snatched by those rendering engines.

The problem is that SSRs are providing output like HTML, which constantly ignores white space And treats the tab as a single space.

Perhaps the best you can hope for is either to replace the tab in your SQL query or to place it inline in your textbox. I had the same problem, where I had some HTML tags which were necessary to be stripped and I had to do it through inline substitution.

You should be able to change the tab with non-breaking space. Perhaps the obvious replacement is: & amp; Nbsp; & Amp; Nbsp; & Amp; Nbsp; & Amp; Nbsp; & Amp; Nbsp;

Your replacement will look something like this:

= Change (MyTable.FieldName, Chr (9), "& amp; nbsp; & amp; nbsp; ; & Amp; nbsp; & quot;)

If you do this in SQL, then something like this will appear:

REPLACE ( MyTable.FieldName, CHAR (9), '& amp; nbsp; & amp;; & nbsp; & amp; nbsp; & amp; nbsp;')

How do you make inline replacement You can see more examples about this.


Comments

Popular posts from this blog

windows - Heroku throws SQLITE3 Read only exception -

lex - Building a lexical Analyzer in Java -

python - rename keys in a dictionary -