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

Reporting Items Toolbox

I am new to reporting services. Just installed the BI Dev Studio onto my SQL 05 machine. Everything is working fine. I can via the wizard create a basic report that connect to a SQL data store, runs a query, renders etc.

My problem - the BI Studio will not give me anything active in the toolbox. If I pull up the toolbox it shows me the general tab and that's it. If I do a 'show all' on the toolbox it will show me all available tabs in VS...including the one I want 'Report Items'. However all controls in the Report Items (pointer, textbox, line, table, matrix, etc.) are grayed out. As far as I can tell this means I would have to directly change the RDL in order to customize my report. I feel like I am missing something basic here.

Thanks in advanced for any insight.

Basic to say the least...Took me a couple hours for me to decide I might need to look around and install additional components from the install disc...which made me decide to close my BI Studio....which promptly asked me if I wanted to stop debugging...which prompted me to scream.

Not sure how debug started running in the first place I would have never thought to run debug on RDL. Anyway lame post. Sorry.