Showing posts with label displays. Show all posts
Showing posts with label displays. Show all posts

Wednesday, March 21, 2012

Rich Textbox Value in Reporting Services Report

I am looking to create a a report that displays a value that has been
saved to a database using a rich text box (Infragistics
WebHtmlEditor). The database (SQL server) value is a string that
contains HTML markup (ex: <strong>test</strong>). Is it possible for
reporting services to parse this markup and display the formatted text
within the report?On Sep 25, 2:49 pm, jkpo...@.gmail.com wrote:
> I am looking to create a a report that displays a value that has been
> saved to a database using a rich text box (Infragistics
> WebHtmlEditor). The database (SQL server) value is a string that
> contains HTML markup (ex: <strong>test</strong>). Is it possible for
> reporting services to parse this markup and display the formatted text
> within the report?
This link might be helpful.
http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for the link.|||On Sep 27, 12:03 pm, jkpo...@.gmail.com wrote:
> Thanks for the link.
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Friday, March 9, 2012

Re-use data from SqlDataSource

I have a page containing a FormView, which gets its data from a SqlDataSource control and displays details of a job. Two of the fields are location and job title. I want to re-use this data to create a dynamic page title. I know I can do this by setting the Page.Title to what I want to, but do I have access to the data outside of the FormView to which the data source is bound? If so how? Or will I have to perform an additional SELECT statement to get this data again?

Hi

No need to perform additional Select statement. You can access the FormView data in DataBound event. Try the following code:

protected void FormView1_DataBound(object sender, EventArgs e) { Page.Title = ((Label)(FormView1.Row.FindControl("column1Label"))).Text; }
Hope this helps.

|||

Brilliant. I've got that working nicely now, and discovered more events to play withBig Smile

Thank you.