embed barcode in pdf

We export a report (pdf format) from Reporting Services that contains
barcodes. If someone tries to view the pdf on a computer that doesn't have
the barcode font loaded it doesn't show up. Is there a way to embed the
barcode image in the pdf?
Thanks,
TimPerhaps someone else will jump in but I am pretty sure there is no way to
embed the font in RS 2005.
RS 2008 will have barcode support (part of the Dundas controls that
Microsoft purchased and is including in RS 2008). This support will allow
you to get around this problem. Today your only choice is to have anyone
that needs to print barcodes to have the font on their machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tim Kelley" <tkelley@.company.com> wrote in message
news:u4W0JmwpIHA.4292@.TK2MSFTNGP04.phx.gbl...
> We export a report (pdf format) from Reporting Services that contains
> barcodes. If someone tries to view the pdf on a computer that doesn't
> have the barcode font loaded it doesn't show up. Is there a way to embed
> the barcode image in the pdf?
> Thanks,
> Tim
>

Emailing a Report on the Fly

Hi,
I am rendering a report in PDF Format using web services API using a click
of a button which its doing perfectly.
As soon as this report is rendered in PDF format, Is there a way to send
him a particular user this report by Email thru C# FrontEnd.
An Email has to be sent when a report is rendered by the user automatically
using WebServices API.
plz put some sample code as well.
I am doing from C# in Winforms
Thanks For ur help
Thanks
Chandra
--
Message posted via http://www.sqlmonster.comThis is not built into RS so you would need to call the mail library
yourself. We would like to add a "send now" feature but it won't make it
into SQL 2005.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chandra Kotha via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:fb6aea0a57554e4cbbda5c3bef6d90ff@.SQLMonster.com...
> Hi,
> I am rendering a report in PDF Format using web services API using a click
> of a button which its doing perfectly.
> As soon as this report is rendered in PDF format, Is there a way to send
> him a particular user this report by Email thru C# FrontEnd.
> An Email has to be sent when a report is rendered by the user
> automatically
> using WebServices API.
> plz put some sample code as well.
> I am doing from C# in Winforms
> Thanks For ur help
> Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com|||Thanks very much I will be using Mail API from C#.NET
--
Message posted via http://www.sqlmonster.com

Email format for Reporting Services

Hi, this question is related to Reporting Services on SQL Server 2000. When creating a report and setting it to send via email as an attached excel spreadsheet, the email is in the format HTML. Does anyone know if it possible to default this format to something else like Rich Text. I have a feeling that this might involve a change to the RSEmailDPConfiguration within the RSReportServer.config file but am not sure which tag needs changing or adding.

Any help/suggestions greatfully received.According to documentation:

rsreportserver.config

EmbeddedRenderFormats

Specifies the rendering format used to encapsulate a report within the body

of an e-mail message. Images within the report are subsequently embedded within

the report. Valid values are MHTML and HTML4.0.

Does not look like you'll get Rich Text in an email without some custom code.

cheers,
Andrew|||

RTF is not supported by out-of-the-box RS. Theoretically you can write your own renderer but it's a difficult task, plus then you'll need to write custom delivery provider to support it as well. Support for RTF is in the wish list for the next RS version.

|||Thanks for both of your comments. I had a feelling it might be a custom option.

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

Email delivery, rendering format problem

Hi,

Im trying to set up so the report gets delivered to specified email addresses with the rendering format set to Web Archive.

The problem is, it wont deliver the background of the report. We really need the background to be yellow (company color) i have tried with both the backgroundcolor setting and backgroundimage setting with repeat =true, but it just delivers the email as transparent(white) background.

Anyone know how to solve this?

regards,
xenojust seem like it is impossible. For those with similiar problem in the future, here is the work-around that i used:
Put a rectangle on your form that stretches 100% with and height of the form and put all objects within it. Make sure it will be resizable to fit.

I dont like it at all, but hey...cant waste too much time on these things when the clock is ticking.
.xeno

EMail Delivery Format Problems

I have installed RS with SP1. I can send e-mails with reports attached to
it, but when I open the attachment I only see garbage, no matter what kind
of format I select (excel, pdf, etc.).
Any ideas?. Should I change something into the configuration files?
Thanks,
DanielYou might be running into the encoding issue. You can either install this
hotfix:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774 (Ignore the
fact that it is about Lotus, the real issue is an encoding issue)
Or you can install SP2:
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel M" <dmongeb@.hotmail.com> wrote in message
news:u$JutcWYFHA.3164@.TK2MSFTNGP09.phx.gbl...
>I have installed RS with SP1. I can send e-mails with reports attached to
>it, but when I open the attachment I only see garbage, no matter what kind
>of format I select (excel, pdf, etc.).
> Any ideas?. Should I change something into the configuration files?
> Thanks,
> Daniel
>

Email Attachment Problem

Hi all,
I create a subscription to send the report (in pdf format) to users once every week. The subscription works, all users manage to receive the email but some of them do not have the pdf file attached to the email. Anyone know what is wrong?

DarenSounds like a firewall setting blocking attachments on those emails.|||

Hi,

just wondering if you found a fix for this problem cause I have te same problem.

I noticed that the problem somehow connects to Outlook, cause when i retreve the mail in my Web-mailclient I get an attachment and in my version of Outlook (version 2003 English) there is the attachment and the size of the mail remains the same..

Lucas

|||Hi IjoNL,
I could not find any solution to it, but there's a temporary solution to this is ask the person to try and forward the email they received in outlook then they will find the attachment file there.

Daren

Email Attachment Problem

Hi all,
I create a subscription to send the report (in pdf format) to users once every week. The subscription works, all users manage to receive the email but some of them do not have the pdf file attached to the email. Anyone know what is wrong?

DarenSounds like a firewall setting blocking attachments on those emails.|||

Hi,

just wondering if you found a fix for this problem cause I have te same problem.

I noticed that the problem somehow connects to Outlook, cause when i retreve the mail in my Web-mailclient I get an attachment and in my version of Outlook (version 2003 English) there is the attachment and the size of the mail remains the same..

Lucas

|||Hi IjoNL,
I could not find any solution to it, but there's a temporary solution to this is ask the person to try and forward the email they received in outlook then they will find the attachment file there.

Daren

Email adddress format validation question

Trying to find the best way to vaildate email formats when importing records to result tables etc... the first seems to run faster, but it seems too easy, like something is getting missed.

Does anyone know if using:

WHERE email LIKE '%@.%.%'

instead of using:

WHERE
( CHARINDEX(' ',LTRIM(RTRIM([email]))) = 0
AND LEFT(LTRIM([email]),1) <> '@.'
AND RIGHT(RTRIM([email]),1) <> '.'
AND CHARINDEX('.',[email],CHARINDEX('@.',[email])) - CHARINDEX('@.',[email]) > 1
AND LEN(LTRIM(RTRIM([email]))) - LEN(REPLACE(LTRIM(RTRIM([email])),'@.','')) = 1
AND CHARINDEX('.',REVERSE(LTRIM(RTRIM([email])))) >= 3
AND (CHARINDEX('.@.',[email]) = 0 AND CHARINDEX('..',[email]) = 0) )

is any better, or are they both pretty much bring back the same result sets?

Thanks for sharing your insight.Looks like T-SQL from where I am standing. Moving to SQL Server. Any mod spot something I missed please relocate.|||The latter is more thorough but restrictive. You may also get false positives (for example my email address ends .uk). You don't need to use LEFT and RIGHT - you can use LIKE (especially for the LEFT since it is then sargable) so it could be more efficient. Perhaps create more of a mask (off the top of my head)

LIKE '_%@._%.__%'
Min 1 char then @. then min 1 char then . then min 2 chars.

HTH|||most people use regex for this kind of thing, although you don't have that option in t-sql.

The regex for the RFC 822 definition of what constitutes a valid address is amusing, see link below.

http://www.regular-expressions.info/email.html|||Great insights! I didnt think about the .uk etc.... Thanks! And I've never used regex before. Thanks so much for the link! I will read up on it! Thank you both!!!!!

email a pdf report

I don't know if this is a bug or not. I have SP1 and used the web
service to render the report in PDF format. The report renders fine
but when I click on the email button it asks me if I want to email the
url or the report itself. I choose the latter. When it attached the
report in the email, I notice that the extension of the report is aspx
and not PDF. So, I test the email by sending it to myself. I have to
save the report as PDF extension in order to view as PDF otherwise it
me garbage. I wonder this is a bug. Thanks.I assume you are using your own ASP.NET application that calls the RS web
service then displays the result to your users. Your application needs to
set the ContentType property of the ASP.NET response object, and perhaps the
content-disposition HTTP header. Doing this will tell IE how to display the
data your page is returning.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:ADB7C080-8FC7-49DE-89FA-0104A9FF0915@.microsoft.com...
> This is happening to me too...
> "powerranger" wrote:
> > I don't know if this is a bug or not. I have SP1 and used the web
> > service to render the report in PDF format. The report renders fine
> > but when I click on the email button it asks me if I want to email the
> > url or the report itself. I choose the latter. When it attached the
> > report in the email, I notice that the extension of the report is aspx
> > and not PDF. So, I test the email by sending it to myself. I have to
> > save the report as PDF extension in order to view as PDF otherwise it
> > me garbage. I wonder this is a bug. Thanks.
> >

EM and QA displays different format for a date field

Hi,
I have a datetime field with a value '1/1/02'. EM display it as 1/1/02 But
Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT * FROM
Table1)
So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
PC does the same.
Thanks.You have a problem under standing of what a data value is and how it is
stored. It is actually just stored as numeric value, denoting offsets from
some time in the reasonably distant past. Format is based on the user. QA
uses a standard value, mostly because when you are using QA the goal is
usually to see ALL of the data.
Enterprise manager is probably using your system settings. When you
actually use the data, you can format it as you wish.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
news:OqYzX0yUFHA.2136@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a datetime field with a value '1/1/02'. EM display it as 1/1/02
> But Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT *
> FROM Table1)
> So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
> PC does the same.
> Thanks.
>|||Chrissi,
Different clients display things differently, with the possible
excepting of strings made up of printable ASCII with codes
from 32 to 127.
If you want the datetime displayed in a particular format, I'd
suggest you select CONVERT(varchar(40),yourDatetimeColumn,X
XXX),
where XXXX is the appropriate SQL Server format code (see the
Books Online article CAST and CONVERT).
If you do this, you won't be able to "edit" the datetime values
in Enterprise Manager, but that's not a good idea anyway. Better
to make changes programmatically with UPDATE or INSERT
statements.
Steve Kass
Drew University
Chrissi wrote:

>Hi,
>I have a datetime field with a value '1/1/02'. EM display it as 1/1/02 Bu
t
>Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT * FROM
>Table1)
>So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
>PC does the same.
>Thanks.
>
>