Embedding reporting services as a standalone product

Hi,
In the application that I am working on, we currently use Crystal Reports as
the embedded reporting engine. I am trying to evaluate if we should move
over to Microsoft Reporting Services. However, one thing confuses me. It
seems Microsoft Reporting Services will work only as a server under IIS.
This will not work for our customers. I am wondering if Reporting Services
has any embedded component much like Crystal Reports that we could use.
Thank you in advance for your help.
SunnyVersion 2 will have a web form and a winform that does not require the
server (works with the server if there but does not require it).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sansanee" <sansanee@.nospam.com> wrote in message
news:%23LD40RJ3EHA.1144@.TK2MSFTNGP09.phx.gbl...
> Hi,
> In the application that I am working on, we currently use Crystal Reports
as
> the embedded reporting engine. I am trying to evaluate if we should move
> over to Microsoft Reporting Services. However, one thing confuses me. It
> seems Microsoft Reporting Services will work only as a server under IIS.
> This will not work for our customers. I am wondering if Reporting Services
> has any embedded component much like Crystal Reports that we could use.
> Thank you in advance for your help.
> Sunny
>

Embedded Fonts anytime soon?

Hi,
Does anyone know if Microsoft is planning to support embedded fonts in the
near future?
We have been using Crystal Reports for our reporting. We are trying out
Reporting Services for the new reports and we like what we see so far, but
there is one major issue: embedded fonts.
We have lots of customers lined up that require the use of OCRA and Barcode
fonts in their pdf documents. Installing these fonts on each client machine
is not an option.
If there is no such plan to include embedded fonts in the near future, we
may have to go back to Crystal Reports.
Thanks,
George
Thanks,
GeorgeGeorge,
From what I understand, the font must be installed on the report server
itself and of course, you must have had it installed on your designer
workstation when you designed the report. Have you done a test?
As an example, we use the font Ariel Unicode to properly display our
diatrics properly - but the legal way to have this font is to install
Microsoft Word - so we now have our customers install MS Word 2003 on the
web server to get this font.
=-Chris
"george tharakan" <georgetharakan@.discussions.microsoft.com> wrote in
message news:C7373491-754E-4F4F-A277-7BF35840E4E5@.microsoft.com...
> Hi,
> Does anyone know if Microsoft is planning to support embedded fonts in the
> near future?
> We have been using Crystal Reports for our reporting. We are trying out
> Reporting Services for the new reports and we like what we see so far, but
> there is one major issue: embedded fonts.
> We have lots of customers lined up that require the use of OCRA and
> Barcode
> fonts in their pdf documents. Installing these fonts on each client
> machine
> is not an option.
> If there is no such plan to include embedded fonts in the near future, we
> may have to go back to Crystal Reports.
> Thanks,
> George
> Thanks,
> George|||Hi Chris,
I do have the font installed on the reportserver and on the designer
workstation. My reports are exported to PDF. When I view the reports on my
machine I get to see the Barcode and OCRA fonts. When I view the report on a
machine which doesnt have these fonts , the fonts just don't show up. The
issue has to do with embedding fonts with the pdf, in which case the fonts
will show up on all client machines. I know that currently RS doesnt support
embedding fonts. There were some rumours that they might consider something
in a future release. Would just like to hear from them regarding a more
specific timeframe.
If it's like in a couple of months, we could wait, else we have to do this
in crystal.
Thanks|||George - what would happen if you save that PDF file on your local machine,
then go over to the machine that doesn't have this font and open the PDF
document - does it render the PDF correctly?
=-Chris
"george tharakan" <georgetharakan@.discussions.microsoft.com> wrote in
message news:53CD3E02-4BE2-4B5A-A337-EC0D5D005739@.microsoft.com...
> Hi Chris,
> I do have the font installed on the reportserver and on the designer
> workstation. My reports are exported to PDF. When I view the reports on my
> machine I get to see the Barcode and OCRA fonts. When I view the report on
> a
> machine which doesnt have these fonts , the fonts just don't show up. The
> issue has to do with embedding fonts with the pdf, in which case the fonts
> will show up on all client machines. I know that currently RS doesnt
> support
> embedding fonts. There were some rumours that they might consider
> something
> in a future release. Would just like to hear from them regarding a more
> specific timeframe.
> If it's like in a couple of months, we could wait, else we have to do this
> in crystal.
> Thanks|||Chris,
No lucj with that either. The pdf shows correctly only on the machine that
has the font installed.
Thanks,
George

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