Field Names that contain the Pound (#) symbol

I'm trying to generate some reports from our AS400 mainframe using OLE
DB. The problem is some of the fields have a name like josel#. For
some reason, the Report builder in VS.net 2003 adds a space between
the # and the characters. I've tried adding [] around the field but
the as400 does not like that. Has anyone had any experience with this
problem?
BartIs this happening in generic query designer?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<Bart> wrote in message news:nahu915fhecll9qe7hvdpmm82uhsak6md8@.4ax.com...
> I'm trying to generate some reports from our AS400 mainframe using OLE
> DB. The problem is some of the fields have a name like josel#. For
> some reason, the Report builder in VS.net 2003 adds a space between
> the # and the characters. I've tried adding [] around the field but
> the as400 does not like that. Has anyone had any experience with this
> problem?
> Bart|||have you set the language for the report to the correct language?

Few Design and Programming Questions

I have a few questions regarding reports that I haven't found answers after a
little searching. Thanks for any help!
1. I need to create a few reports with some repeating pages. For example, in
one of them I need to have a cover page, then couple content pages, then a
summary page. I need to double print the content pages. There must be a
better way to achive this than manually copy-and-paste to duplicate those
pages in the report design, is there?
2. Is there a way to embed a PDF file into the report somehow? Say, at the
end of each report, I need to include a few pages of static information. Can
I somehow have the report server to pull out a PDF file instead of putting
those text into the report design?
3. Can I include other reports in a report?
4. Is there a way to control printing of the reports after I exported them
into PDF for printing? Say, I want page 3 and 4 print on both side of the
paper. I don't think this is possible, but asking to make sure.
5. Can I control the size of the parameter input area of the report at the
top portion of the report server? I need to disply 8 input boxes. Users need
to scroll down in the parameter area to see the last 2.
Thanks!No reply yet : ]
Does anyone know something about my question #2?
Or any suggestions on how to deal with complexed text/table formatting with
VS .NET 2003 report designer? It is so hard to make things look right, that's
why I wanted to just "attach" a PDF or word file for those static text.
"Xonic" wrote:
> I have a few questions regarding reports that I haven't found answers after a
> little searching. Thanks for any help!
> 1. I need to create a few reports with some repeating pages. For example, in
> one of them I need to have a cover page, then couple content pages, then a
> summary page. I need to double print the content pages. There must be a
> better way to achive this than manually copy-and-paste to duplicate those
> pages in the report design, is there?
> 2. Is there a way to embed a PDF file into the report somehow? Say, at the
> end of each report, I need to include a few pages of static information. Can
> I somehow have the report server to pull out a PDF file instead of putting
> those text into the report design?
> 3. Can I include other reports in a report?
> 4. Is there a way to control printing of the reports after I exported them
> into PDF for printing? Say, I want page 3 and 4 print on both side of the
> paper. I don't think this is possible, but asking to make sure.
> 5. Can I control the size of the parameter input area of the report at the
> top portion of the report server? I need to disply 8 input boxes. Users need
> to scroll down in the parameter area to see the last 2.
> Thanks!

feedback after printing

helloo all,
i am using client side printing to print my reports
i need after printing report to get a feedback if the report is printed or not
if client side printing will not help me is there are any way to do that ?
thanks
Bolosfrom web application
i had use the url access for the client side printing
so it return the activex of it as the resut
same as if u print form the report manager
if u have any ideas just tell me
"Mike Morisoli" wrote:
> Bolos, can I ask how you are managing the client side printing? Is this
> from IE or from a WinForm?
> Thanks, Mike
> "Bolos wageh" <Boloswageh@.discussions.microsoft.com> wrote in message
> news:6F5946AD-E430-41BE-91BE-D74C9DDE55DF@.microsoft.com...
> > helloo all,
> >
> > i am using client side printing to print my reports
> > i need after printing report to get a feedback if the report is printed or
> > not
> >
> > if client side printing will not help me is there are any way to do that
> > ?
> >
> > thanks
> > Bolos
>
>

Feedback after one week of using

Hi all,
Just installed the software on Monday and I already have 2 reports in the
production. This software is so amazing, I did a little demo today at work
and everyone was shocked to see that it took me only 15 minutes to author
one simple report with no line of code! It's very easy to use, I think
coming up with the query is hard. I still think it needs some improvements,
i.e. calendar control (this is a must in any report, I don't believe they
didn't think of it when they released the software!)
I still have some questions though:
1. Since we have SQL and Web servers in the DMZ (they belong to DMZ domain),
we don't want to have users (on separate domain) log on (using DMZ domain
account - no trust allowed) to view and subscribe reports. Is there a way to
set anonymous access to default reports, except for few reports and certain
features that we want to lock out from anonymous users? This helps us a lot
with maintenance and support.
2. Can I connect to 2 or more datasources in the same report?
Thanks in advance for the help.
SQL Server Reporting Services ROCKS!Thanks for using our product.
1. Allowing both anonymous and authenticated access would require to
configure IIS to accept both anonymous and windows integrated
authentication. We found this configuration to be very confusing and asking
customers to avoid it. If you allow both, internet explorer will not know
which one to use. This will cause unstable behavior, sometimes it will try
to go as anonymous and sometimes will ask for user name and password.
One way to solve this problem is to install another report server and point
it to the same database. Then allow only anonymous access on one RS and only
integrated authentication on another. After that you can give rights to
account under which IIS runs anonymous user for some reports. Note that if
you use different boxes for this, you'll have to make this used a domain
user known to both boxes and SQL.
2. Yes, this is possible.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"VNN" <VNN@.hotmail.com> wrote in message
news:enXXJ7lCFHA.1268@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Just installed the software on Monday and I already have 2 reports in the
> production. This software is so amazing, I did a little demo today at work
> and everyone was shocked to see that it took me only 15 minutes to author
> one simple report with no line of code! It's very easy to use, I think
> coming up with the query is hard. I still think it needs some
improvements,
> i.e. calendar control (this is a must in any report, I don't believe they
> didn't think of it when they released the software!)
> I still have some questions though:
> 1. Since we have SQL and Web servers in the DMZ (they belong to DMZ
domain),
> we don't want to have users (on separate domain) log on (using DMZ domain
> account - no trust allowed) to view and subscribe reports. Is there a way
to
> set anonymous access to default reports, except for few reports and
certain
> features that we want to lock out from anonymous users? This helps us a
lot
> with maintenance and support.
> 2. Can I connect to 2 or more datasources in the same report?
> Thanks in advance for the help.
> SQL Server Reporting Services ROCKS!
>|||Hello Dmitry,
I can echo the comments of VNN. I am into my second week using RS,
apart from initial hiccups of installation, development has been rapid.
I am eagerly awaiting SP2 to see if they can add some features which i
feel can make my life easier.
As you mentioned multiple installations of RS pointing to same DB, I
would like to know more about this.
I am trying to deploy my reports on a remote server. But i am not sure
to use the existing RS DB on a machine in my domain or
Create a new RS db on the server.
Would like to know how to go about
1. Using the existing DB
2. Creating a new DB on the server.
In case of creating a new DB is there a way I can export all the
reports I created on my local machine to the new report server ?
What are the security/account types/auth/IIS issues I need to take care
of.
I am gonna do the installation tommorow and trying to get as much info
as possible.
Thx
Bofo|||When multiple servers are sharing the same SQL DB that is called a web farm
configuration. It is more complicated to setup and it is more expensive (you
have to have an enterprise server license). For what you are doing you
definitely do not need to do this and I would recommend against it (even if
you are already using enterprise). In your case it is best to have
development and production separate. It is very easy to deploy all reports
again. RS has multiple configurations you can deploy to (I have three). You
can deploy all your reports or you can deploy just the ones you need (select
the ones to deploy, right mouse click deploy).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1107497967.753916.202930@.l41g2000cwc.googlegroups.com...
> Hello Dmitry,
> I can echo the comments of VNN. I am into my second week using RS,
> apart from initial hiccups of installation, development has been rapid.
> I am eagerly awaiting SP2 to see if they can add some features which i
> feel can make my life easier.
> As you mentioned multiple installations of RS pointing to same DB, I
> would like to know more about this.
> I am trying to deploy my reports on a remote server. But i am not sure
> to use the existing RS DB on a machine in my domain or
> Create a new RS db on the server.
> Would like to know how to go about
> 1. Using the existing DB
> 2. Creating a new DB on the server.
> In case of creating a new DB is there a way I can export all the
> reports I created on my local machine to the new report server ?
> What are the security/account types/auth/IIS issues I need to take care
> of.
> I am gonna do the installation tommorow and trying to get as much info
> as possible.
>
> Thx
> Bofo
>

Features request

Hi all.
I've been working with RS for a month or so migrating all our client-side
reports (MS Access) to server-side (RS). I have a bunch of them to be
converted yet but I think I have some experience and can do some suggestions
to a product that is a very good product to be the 1st version. I hope next
version in SQL Server 2005 improves some things like:
* Add the option to select a RGB color for using it as transparency for the
Image control: You can add transparencies to the images themselves when
using GIF or PNG formats. However when images are bitmaps, since bitmap
format does not have support for transparency layers, it would be usefull to
have that support from RS itself.
* Render to .SNP format (MS Access Snapshot format).
* Within the VS IDE, when you copy a group of controls and paste them in
another report, they are not located at the same X,Y positions as they were
in the original report, but at the middle/center of the space they have been
inserted into (parent). I think that report designers would prefer to paste
the copied controls in the place they were instead of another coordinates
that sometimes are not aligned to the grid either (even though align to grid
is active).
* When you copy a control named MyUserRenamedControl1 (a textbox for
instance) and paste into the same report, since that control name is already
used, the new control is named TexboxX (being X a free number that makes the
name unique in the report). I think that if report designers have renamed a
default name component to another name (for whatever the reason), the IDE
should try to keep the same name and add numbers to the end of the name that
the designer has selected. In this case the names of new controls should be
MyUserRenamedControl2, MyUserRenamedControl3, etc.
* Rounded corners for rectangles, components for circles, ellipses, oblique
text (number of degrees selectable). This might be of less use for many
people, mainly when they use RS to generate pure-listing reports. However if
you use RS to generate invoices or other kind of documents that need quality
and be visually attractive, this kind of improvements would help a lot.
Regards and congratulations for such a good work.Also, report headers and footers, to supplement page headers and
footers.|||Report headers and footers are equivalent to objects that appear before any
data regions.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Parker" <psmith@.iquest.net> wrote in message
news:1116090620.154601.166470@.g49g2000cwa.googlegroups.com...
> Also, report headers and footers, to supplement page headers and
> footers.
>

Favorite reports

Is there any to let users have a folder of favorite reports?
I tried using "My Reports" folder, but the security required to allow a
user to see the option to create a linked report created too much of a
security risk.
Any ideas?Users could use the IE favorites, create a group there and simply add the
reports as you would any other web site...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Geddes" <john_g@.alamode.com> wrote in message
news:OxZbNxB9EHA.2900@.TK2MSFTNGP09.phx.gbl...
> Is there any to let users have a folder of favorite reports?
> I tried using "My Reports" folder, but the security required to allow a
> user to see the option to create a linked report created too much of a
> security risk.
> Any ideas?
>

Faster than Access?

I currently have an Access database that has numerous forms, tables, reports, etc. Although it works fine over our LAN, it is very slow when accessed from a second site over our VPN. Will migrating this application to SQL Server give me faster response?
Ken
Probably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)
|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken

Faster than Access?

I currently have an Access database that has numerous forms, tables, reports, etc. Although it works fine over our LAN, it is very slow when accessed from a second site over our VPN. Will migrating this application to SQL Server give me faster response?
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken

Faster than Access?

I currently have an Access database that has numerous forms, tables, reports
, etc. Although it works fine over our LAN, it is very slow when accessed f
rom a second site over our VPN. Will migrating this application to SQL Serv
er give me faster response?
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken

Faster Printouts In Dotmatrix

Is it possible to format the crystal reports to take faster printouts in dotmatrix, if yes then how?
Thanks
krishnanblrYes, you can get speed of Dos mode printing.

Install a Dot matrix printer driver (Eg.Epson-Ex-1000)
In the report, set font of ALL columns to Roman 12/10 cpi or Sanserif 12/10 cpi or Draft 10 cpi or Draft 12 cpi.

In the printer setup dialog, don't forget to select
Device Options - Print Quality - Draft.
-Madhu :wave:|||Thanks for the reply, i will try and get back on this. thanks again :)

Fast Printing from Crystal report 9.0

Hi,
We have created an application in VB 6, MS ACCESS 2000 and all the reports we created in CRYSTAL REPORT 9.0. Now our customer is complaining that printing speed is very slow. IS there any way to fasten the printing speed of Crystal report ?Instal Generic Printer and adjust the report accordingly. in this case you will not able to print graphics line etc. but printing is very very fast. The printer driver exists in windows. i have also applied this thing in my projects (with crystal 8.0).|||Originally posted by jimman
Hi,
We have created an application in VB 6, MS ACCESS 2000 and all the reports we created in CRYSTAL REPORT 9.0. Now our customer is complaining that printing speed is very slow. IS there any way to fasten the printing speed of Crystal report ?

Hi,

Use Printer support fonts, you can find out the printer icon contains in the front of the font name.|||HI,

I think the best way to achieve fast printing is to print in DOS format; for this u will have to export the report into text file and using Bat file print this report..

try and see..

swapnil

Failure sending mail: The system cannot find the path specified.

I have had a development XP workstation with RS2000 and IIS sending reports via email for 6 months straight with no problems.

Today my subscriptions are failing with

Failure sending mail: The system cannot find the path specified.

Been searching and digging for hours, and if anyone has any ideas they are greatly appreciated.

I need some info to troubleshoot...

Replicate the issue, then go the Report Server log (ReportServer_xxx_xxx.log) and email the log to me for review. markcam80@.hotmail.com

What I will be looking for is explicit error messages versus the displayed message.

|||Thanks for the help but it seems we had a domain controller misbehaving.

Failure of report mail delivery

Hi all!
I am running reports with RS 2000. All of htem are subscribed for e-mail
delivery.
For a large report I get the following error:
â'Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x800ccc6d. The server response was 552 message line
is too longâ'
What do I need ot configure in order to deliver this reports successfully.
Thank you
ElenaIt sounds like the size of the message is too large for you SMTP
server. Your mail server administrator probably has a size limit set
for an individual message.
In your email subscription, are you sending the report as an
attachment or just including it in the body of the mail?
Regards,
Shane.
You can either get your mail administrator to increase the size limit
or send
On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> Hi all!
> I am running reports with RS 2000. All of htem are subscribed for e-mail
> delivery.
> For a large report I get the following error:
> "Failure sending mail: The message could not be sent to the SMTP server. The
> transport error code was 0x800ccc6d. The server response was 552 message line
> is too long"
> What do I need ot configure in order to deliver this reports successfully.
> Thank you
> Elena|||I am sending in Web Archive format.
It is sent as a body of the mail. Actually I never considered as sending as
attachment.
Where can I adjust the settings for sending report as attachment?
Elena
"shanejokeeffe" wrote:
> It sounds like the size of the message is too large for you SMTP
> server. Your mail server administrator probably has a size limit set
> for an individual message.
> In your email subscription, are you sending the report as an
> attachment or just including it in the body of the mail?
> Regards,
> Shane.
> You can either get your mail administrator to increase the size limit
> or send
> On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > Hi all!
> > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > delivery.
> > For a large report I get the following error:
> > "Failure sending mail: The message could not be sent to the SMTP server. The
> > transport error code was 0x800ccc6d. The server response was 552 message line
> > is too long"
> > What do I need ot configure in order to deliver this reports successfully.
> > Thank you
> >
> > Elena
>
>|||In the Subscription properties page, there is a drop-down list called
"Render Format". By default this will have a value of Web Archive.
Just change it to Excel or PDF to send the report as an attachment.
Regards,
Shane.
On Apr 17, 1:00 pm, Elena <E...@.discussions.microsoft.com> wrote:
> I am sending in Web Archive format.
> It is sent as a body of the mail. Actually I never considered as sending as
> attachment.
> Where can I adjust the settings for sending report as attachment?
> Elena
> "shanejokeeffe" wrote:
> > It sounds like the size of the message is too large for you SMTP
> > server. Your mail server administrator probably has a size limit set
> > for an individual message.
> > In your email subscription, are you sending the report as an
> > attachment or just including it in the body of the mail?
> > Regards,
> > Shane.
> > You can either get your mail administrator to increase the size limit
> > or send
> > On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > > Hi all!
> > > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > > delivery.
> > > For a large report I get the following error:
> > > "Failure sending mail: The message could not be sent to the SMTP server. The
> > > transport error code was 0x800ccc6d. The server response was 552 message line
> > > is too long"
> > > What do I need ot configure in order to deliver this reports successfully.
> > > Thank you
> > > Elena|||Thanks a lot. It is working.
Elena
"shanejokeeffe" wrote:
> In the Subscription properties page, there is a drop-down list called
> "Render Format". By default this will have a value of Web Archive.
> Just change it to Excel or PDF to send the report as an attachment.
> Regards,
> Shane.
> On Apr 17, 1:00 pm, Elena <E...@.discussions.microsoft.com> wrote:
> > I am sending in Web Archive format.
> > It is sent as a body of the mail. Actually I never considered as sending as
> > attachment.
> > Where can I adjust the settings for sending report as attachment?
> >
> > Elena
> >
> > "shanejokeeffe" wrote:
> > > It sounds like the size of the message is too large for you SMTP
> > > server. Your mail server administrator probably has a size limit set
> > > for an individual message.
> >
> > > In your email subscription, are you sending the report as an
> > > attachment or just including it in the body of the mail?
> >
> > > Regards,
> >
> > > Shane.
> >
> > > You can either get your mail administrator to increase the size limit
> > > or send
> > > On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > > > Hi all!
> > > > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > > > delivery.
> > > > For a large report I get the following error:
> > > > "Failure sending mail: The message could not be sent to the SMTP server. The
> > > > transport error code was 0x800ccc6d. The server response was 552 message line
> > > > is too long"
> > > > What do I need ot configure in order to deliver this reports successfully.
> > > > Thank you
> >
> > > > Elena
>
>|||Apparently, changing it to Excel does not help. Is there a bug in which the
reporting service is putting excel in the body?
Regards,
David
"shanejokeeffe" wrote:
> In the Subscription properties page, there is a drop-down list called
> "Render Format". By default this will have a value of Web Archive.
> Just change it to Excel or PDF to send the report as an attachment.
> Regards,
> Shane.
> On Apr 17, 1:00 pm, Elena <E...@.discussions.microsoft.com> wrote:
> > I am sending in Web Archive format.
> > It is sent as a body of the mail. Actually I never considered as sending as
> > attachment.
> > Where can I adjust the settings for sending report as attachment?
> >
> > Elena
> >
> > "shanejokeeffe" wrote:
> > > It sounds like the size of the message is too large for you SMTP
> > > server. Your mail server administrator probably has a size limit set
> > > for an individual message.
> >
> > > In your email subscription, are you sending the report as an
> > > attachment or just including it in the body of the mail?
> >
> > > Regards,
> >
> > > Shane.
> >
> > > You can either get your mail administrator to increase the size limit
> > > or send
> > > On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > > > Hi all!
> > > > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > > > delivery.
> > > > For a large report I get the following error:
> > > > "Failure sending mail: The message could not be sent to the SMTP server. The
> > > > transport error code was 0x800ccc6d. The server response was 552 message line
> > > > is too long"
> > > > What do I need ot configure in order to deliver this reports successfully.
> > > > Thank you
> >
> > > > Elena
>
>