Reporting PWA HTML data?

[scubaal]

We are using the SQL Reporting services to report on PWA workspaces.
(Project Server 2007)
A number of workspaces have data items stored as multi-line Rich Text
- which becomes embedded HTML when stored to the database.

The problem is that when it is included in any SQLRS reports it looks
*awful* because the html tags are just embedded within the text,
rather than formatted.

I've seen a couple of posts on SQLRS which basically say 'tough luck
until SQL2008' which isnt very encouraging

Is this really true - is there really no way to format html within
SQLRS reports?

Seems like a pretty critical ommission.
Crystal reports can do this stuff standing on its head

Any ideas on how to format HTML text within a SQLRS report? (built in
functions, add-ins etc)

Thanks
Al Blake

 

[Gary L. Chefetz [MVP]]

Al

Certainly this post would be better placed on the dev group, but you might
even consider asking the question in the appropriate SQL group.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Bruce L-C [MVP]]

2008 will definitely have support for rich text. Not sure exactly what that
means though. For instance, does it mean you can have html from the database
and show that in a field? I don't know, but I sure hope to. I'm going to
investigate some out of my own curiosity on this.

But, for today, the only option is to strip HTML tags and convert the html
to straight text. Not sure if that will do it for you.