Reporting PWA HTML data?

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 BlakeAl
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
"scubaal" <al@.blakes.net> wrote in message
news:e0323a2a-37d7-4a85-b1c6-59d7ed10d65d@.s13g2000prd.googlegroups.com...
> 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|||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.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"scubaal" <al@.blakes.net> wrote in message
news:e0323a2a-37d7-4a85-b1c6-59d7ed10d65d@.s13g2000prd.googlegroups.com...
> 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