Embed HTML tags into report fields

I have a need to render data returned from a relational DB with spacing intact. The application is a viewer for input data so the end user can determine if the input data is different than the file layout specified so the data will be parsed correctly, so spacing is critical.

I changed to a fixed-pitch font to ensure that the text records align properly in VS (which they do), but when I render to HTML, the spaces collapse (of course). PDFs render correctly, but we were trying for HTML output.

Is there any way to replace the native spaces with   so it will render correctly in HTML? From the other posts, it seems not, but I want to double check.

If anyone knows of a way to do this, I would appreciate any insight.

Thx.See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx.sql

Embed HTML tags into report fields

I have a need to render data returned from a relational DB with spacing intact. The application is a viewer for input data so the end user can determine if the input data is different than the file layout specified so the data will be parsed correctly, so spacing is critical.

I changed to a fixed-pitch font to ensure that the text records align properly in VS (which they do), but when I render to HTML, the spaces collapse (of course). PDFs render correctly, but we were trying for HTML output.

Is there any way to replace the native spaces with   so it will render correctly in HTML? From the other posts, it seems not, but I want to double check.

If anyone knows of a way to do this, I would appreciate any insight.

Thx.See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx.

Email from Report Viewer?

Hello all,
This is a really dumb question and I am sure that the answer is No, but I
have to ask it to see what other options/solutions might be available to me.
A client currently uses a Crystal Report Viewer control that allows users to
email an exported report from a desktop application. They want to move to
SSRS 2005, with a ASP.NET 2.0 front end. I would like to use the Report
Viewer control that comes with ASP.NET 2.0.
Is there any way to get a report, which is created dynamically (the rdl is
created dynamically based on user preferences and doesn't "live" on the
reporting services server) emailed to a list of email addresses?
Since the report is created dynamically and doesn't live on the Reporting
Services Server, it doesn't look like scheduling is an option...
Thanks!
-BrianThis is not directly supported, but you could support it in some fashion in
your app. Just place a button in you app to email the report. Then call
RenderReport on the viewer object and render to the desired format (not html
since there is no server for the images, but pdf or excell will work). Your
app can then just email the report. Of course your app needs to handle
setting up the connection to the smtp server to send the email, but you
could probably hook into outlook if you really needed to.
I hope that help.s
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:3B131BB4-2517-42E0-A47E-CD59003ABC0C@.microsoft.com...
> Hello all,
> This is a really dumb question and I am sure that the answer is No, but I
> have to ask it to see what other options/solutions might be available to
> me.
> A client currently uses a Crystal Report Viewer control that allows users
> to
> email an exported report from a desktop application. They want to move to
> SSRS 2005, with a ASP.NET 2.0 front end. I would like to use the Report
> Viewer control that comes with ASP.NET 2.0.
> Is there any way to get a report, which is created dynamically (the rdl is
> created dynamically based on user preferences and doesn't "live" on the
> reporting services server) emailed to a list of email addresses?
> Since the report is created dynamically and doesn't live on the Reporting
> Services Server, it doesn't look like scheduling is an option...
> Thanks!
> -Brian|||Hi,
Also have a look at creating your own export extensions. It may initially be
long-winded but you could get it to do exactly what you want it to.
Regards
John.
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:3B131BB4-2517-42E0-A47E-CD59003ABC0C@.microsoft.com...
> Hello all,
> This is a really dumb question and I am sure that the answer is No, but I
> have to ask it to see what other options/solutions might be available to
> me.
> A client currently uses a Crystal Report Viewer control that allows users
> to
> email an exported report from a desktop application. They want to move to
> SSRS 2005, with a ASP.NET 2.0 front end. I would like to use the Report
> Viewer control that comes with ASP.NET 2.0.
> Is there any way to get a report, which is created dynamically (the rdl is
> created dynamically based on user preferences and doesn't "live" on the
> reporting services server) emailed to a list of email addresses?
> Since the report is created dynamically and doesn't live on the Reporting
> Services Server, it doesn't look like scheduling is an option...
> Thanks!
> -Brian

Email Export?

Hello,

In the Crystal Report Viewer control, there is a way to export a report to the file format of choice (i.e. pdf or xls) and have it emailed.

This is probably a stupid question, but I have to ask it...

Is there a way to have an exported report in SSRS 2005 emailed without saving the report and then attaching it to an email?

I know about the scheduling services, but that will not work for me as my reports are created dynamically and displayed throught the ASP.NET 2.0 Report Viewer Control.

Thanks!!!

-Brian

Hi,

Have you tried Report Subscription using "Report Server E-mail" option? In BOL this is discussed under "E-Mail Delivery in Reporting Services". While configuring reports to be sent as an email you can include the report as a link or/and as an attachment.

HTH

Uday

|||

There is no supported email export. If you use the Viewer controls then your app could export the report and then send the email. Your app would have to take care of all smtp settings however.

-Daniel

|||

Thanks for the response Uday, but as noted in my original post, the report is created dynamically and not a published report. I cannot use the Scheduling/Subscription functionality...

-Brian

|||

Not built-into the ReportViewer control. Since you are sitting in code already, it is possible to wire this up really quickly using the classes in the System.Web.Mail namespace.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am guessing I would need to use the ReportViewer's RenderStream method, but I cannot find good documentation on the parameters that are needed to call this method (i.e. streamId, mimeType, etc...). Which ones are required? I know what each does from the MSDN documentation, but I am looking for an example of this in use.

I am calling the RenderStream method and passing in empty strings (String.Empty) for each of the parameters and I am getting the following error:

"The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"

Any Ideas?

Thanks!

-Brian

Email Export?

Hello,

In the Crystal Report Viewer control, there is a way to export a report to the file format of choice (i.e. pdf or xls) and have it emailed.

This is probably a stupid question, but I have to ask it...

Is there a way to have an exported report in SSRS 2005 emailed without saving the report and then attaching it to an email?

I know about the scheduling services, but that will not work for me as my reports are created dynamically and displayed throught the ASP.NET 2.0 Report Viewer Control.

Thanks!!!

-Brian

Hi,

Have you tried Report Subscription using "Report Server E-mail" option? In BOL this is discussed under "E-Mail Delivery in Reporting Services". While configuring reports to be sent as an email you can include the report as a link or/and as an attachment.

HTH

Uday

|||

There is no supported email export. If you use the Viewer controls then your app could export the report and then send the email. Your app would have to take care of all smtp settings however.

-Daniel

|||

Thanks for the response Uday, but as noted in my original post, the report is created dynamically and not a published report. I cannot use the Scheduling/Subscription functionality...

-Brian

|||

Not built-into the ReportViewer control. Since you are sitting in code already, it is possible to wire this up really quickly using the classes in the System.Web.Mail namespace.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am guessing I would need to use the ReportViewer's RenderStream method, but I cannot find good documentation on the parameters that are needed to call this method (i.e. streamId, mimeType, etc...). Which ones are required? I know what each does from the MSDN documentation, but I am looking for an example of this in use.

I am calling the RenderStream method and passing in empty strings (String.Empty) for each of the parameters and I am getting the following error:

"The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"

Any Ideas?

Thanks!

-Brian