Remove From My Forums

HTML Markup

Question
0

Sign in to vote

I am creating a dashboard view in PWA that includes multiple lines fields. For some reason it showing the HTML Markups. For example <p> <P/>. Please let me know if there is a way to disable this Markups from appearing in the Dashboard and only show the data as we format it in the Project Detail Page.

Thank you,

Aiza

Tuesday, August 5, 2014 3:06 PM

Answers

0

Sign in to vote
To remove them from SSRS see the examples below:

VB: http://www.epmpartners.com.au/blog/removing-unwanted-html-contents-from-sql-server-reporting-services-srs-reports/

via SQL: http://www.aspdotnet-suresh.com/2014/04/sql-server-remove-html-tags-from-string.html

Or you can render the HTML tags:

http://technet.microsoft.com/en-us/library/dd207057(v=sql.110).aspx

http://dinesql.blogspot.co.uk/2010/05/reporting-services-2008-showing-html.html

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS
- Proposed as answer by Guillaume Rouyre [MBA, MVP, MCC]MVP Tuesday, August 5, 2014 3:38 PM
- Marked as answer by PWMatherMVP Tuesday, August 5, 2014 8:55 PM
Tuesday, August 5, 2014 3:25 PM
0

Sign in to vote
Hello,

I know how you have got multiline text fields in the Project Center view... these originally started as single line of text fields, you added them to the PWA view then changed them to multiline once they were added to the view - its the only way.

As multiline fields cannot be added to Project Center views by default the grid will not render the HTML tags - it is not designed to.

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS
- Marked as answer by PWMatherMVP Tuesday, August 5, 2014 8:55 PM
Tuesday, August 5, 2014 8:40 PM

All replies

0

Sign in to vote

Hello,

What reporting technology are you using? If using SSRS you can remove the HTML or render it.

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

Tuesday, August 5, 2014 3:13 PM
0

Sign in to vote

yes i am using SSRS.

Tuesday, August 5, 2014 3:14 PM
0

Sign in to vote

The markups are appearing in Project Center also

Tuesday, August 5, 2014 3:16 PM
0

Sign in to vote
To remove them from SSRS see the examples below:

VB: http://www.epmpartners.com.au/blog/removing-unwanted-html-contents-from-sql-server-reporting-services-srs-reports/

via SQL: http://www.aspdotnet-suresh.com/2014/04/sql-server-remove-html-tags-from-string.html

Or you can render the HTML tags:

http://technet.microsoft.com/en-us/library/dd207057(v=sql.110).aspx

http://dinesql.blogspot.co.uk/2010/05/reporting-services-2008-showing-html.html

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS
- Proposed as answer by Guillaume Rouyre [MBA, MVP, MCC]MVP Tuesday, August 5, 2014 3:38 PM
- Marked as answer by PWMatherMVP Tuesday, August 5, 2014 8:55 PM
Tuesday, August 5, 2014 3:25 PM
0

Sign in to vote

Thanks Paul. Now how do I remove the Markups from PWA - Project Center columns...

Thanks again for your help.

Tuesday, August 5, 2014 3:55 PM
0

Sign in to vote

Never seen HTML mark up in PWA Project Center views, please can include a screen shot? what types of fields are they?

Thanks

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

Tuesday, August 5, 2014 3:59 PM
0

Sign in to vote

Here is an example.

The field are from multiple lines field.

Tuesday, August 5, 2014 4:58 PM
0

Sign in to vote

Hello,

Multiline text fields cant be added to Project Center views though? Is that definitely a Project Center view? They can only be added to PDPs.

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

Tuesday, August 5, 2014 5:50 PM
0

Sign in to vote

Hello Paul,

I was able to make it add to the project center view that is in the image, but it appears that the problem is internal to the database.

Once agian thank you.

Aiza

Tuesday, August 5, 2014 8:16 PM
0

Sign in to vote
Hello,

I know how you have got multiline text fields in the Project Center view... these originally started as single line of text fields, you added them to the PWA view then changed them to multiline once they were added to the view - its the only way.

As multiline fields cannot be added to Project Center views by default the grid will not render the HTML tags - it is not designed to.

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS
- Marked as answer by PWMatherMVP Tuesday, August 5, 2014 8:55 PM
Tuesday, August 5, 2014 8:40 PM
0

Sign in to vote

That makes sense. The only way is to whenever someone makes an update to the field in PDP they will need to open the Edit in HTML and remove the markups, but the data will be display as a paragraph block in both the PDP and Project Center.

Tuesday, August 5, 2014 8:53 PM
1

Sign in to vote

If you ever have the need to put these fields in Excel reports, see this article for removing the tags. Essentially, you convert the rtf field to XML and query out the text value. http://aboutmsproject.com/converting-rtf-to-text-in-sql-revisited/

Treb Gatte, Project MVP | Twitter | http://www.tumbleroad.com

Wednesday, August 6, 2014 8:04 PM

Answered by:

HTML Markup

Question

Answers

All replies