embedding html

Just curious if anyone has any hints to embed HTML directly into a report. I
am doing reports that will be exported to excel when run as a subscription
and using an index (which jump to bookmarks) and page breaks to get each
report onto new tabs.
My current report, done with a different tool, has 2 "Help" tabs that are
formatted text that describe how to interpret the report. I need to
replicate this in reporting services. One problem is that textbox in RS is
way too limited in its functionality.
I could probably link out to an HTML page, but I want the new help tabs to
export to excel along with the report.
Any ideas?I can't think of a way until HTML is supported in text boxes.
--
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
"asnewbie+rs=argh" <asnewbiersargh@.discussions.microsoft.com> wrote in
message news:DDC6A10A-32BE-43BE-9296-F2B64769DEAA@.microsoft.com...
> Just curious if anyone has any hints to embed HTML directly into a report.
> I
> am doing reports that will be exported to excel when run as a subscription
> and using an index (which jump to bookmarks) and page breaks to get each
> report onto new tabs.
> My current report, done with a different tool, has 2 "Help" tabs that are
> formatted text that describe how to interpret the report. I need to
> replicate this in reporting services. One problem is that textbox in RS
> is
> way too limited in its functionality.
> I could probably link out to an HTML page, but I want the new help tabs to
> export to excel along with the report.
> Any ideas?

Embedded images cause export to .pdf to fail.

I am using an embedded image of a signature on my report. It is a small
.jpg. When I run and print the report, everything is ok. When I try to
export it to pdf, the report stops rendering the report when it gets to the
image. I am using Adobe v.7. I tried this using Adobe v.5 and the whole
report renders except the signature image. Does anyone have an idea how i
can get around this?I found the answer was to change the embedded image from a .jpg format to a
.bmp format. I guess that adobe has a had time renedering images that were
in .jpg format.
"Chris Arnold" wrote:
> I am using an embedded image of a signature on my report. It is a small
> .jpg. When I run and print the report, everything is ok. When I try to
> export it to pdf, the report stops rendering the report when it gets to the
> image. I am using Adobe v.7. I tried this using Adobe v.5 and the whole
> report renders except the signature image. Does anyone have an idea how i
> can get around this?

Emailing

Not sure if this can be done but I have a report that gets run that has a
different page for each client it is run for. It doesnt necessarily have a
parameter. What my question is, is there a way to email each different page
to the specific client it is run for. Say I ran the report and it had 10
pages and on each page was a separate client. After the report is ran, how
can I get it to automatically send each specific page to its respectful
owner?I dont think it is a proper approach to do if the client doesn;t mind
or you Either seeing others information.
The proper approach should be have a parameter, Create subscriptions
for the 10 users.
Thats good
Thanks
Raj deep.A|||Clients dont want to see each others info and dont want others seeing their
info!
"RajDeep" <rajalapati@.gmail.com> wrote in message
news:c63098f5-ed9b-405d-851a-7f6e29f12769@.q27g2000prf.googlegroups.com...
>I dont think it is a proper approach to do if the client doesn;t mind
> or you Either seeing others information.
> The proper approach should be have a parameter, Create subscriptions
> for the 10 users.
> Thats good
> Thanks
> Raj deep.A|||On Apr 30, 5:58=A0pm, "Ben Watts" <lunuticsho...@.hotmail.com> wrote:
> Clients dont want to see each others info and dont want others seeing thei=r
> info!
> "RajDeep" <rajalap...@.gmail.com> wrote in message
> news:c63098f5-ed9b-405d-851a-7f6e29f12769@.q27g2000prf.googlegroups.com...
>
> >I dont think it is a proper approach to do if the client doesn;t mind
> > or you =A0Either seeing others information.
> > The proper approach should be have a parameter, Create subscriptions
> > for the 10 users.
> > Thats good
> > Thanks
> > Raj deep.A- Hide quoted text -
> - Show quoted text -
Are you running the Enterprise Editon? If so you MAY (running
Developer Edition here so don't know for sure whether you can or not)
be able to accomplish what you want with a data driven subscription.
Even if you can, I'm thinking you'll still need to parameterize your
query.
Without Enterprise, I agree with Rajdeep. You're going to have to use
a parameter for client ID and then probably create separate
subscriptions for each client.sql

Email task - no error - no mail

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

'

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

An added question: Since the mail task is directly bind with the SMTP I can send emails from anonymous email as the "from email id". Is this an issue in my server configuration or in SSIS "send task"?

sql

Email task - no error - no mail

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

'

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

An added question: Since the mail task is directly bind with the SMTP I can send emails from anonymous email as the "from email id". Is this an issue in my server configuration or in SSIS "send task"?

email subscriptions disabled

What options do I have if email subscriptions on my companies report server have been disabled. I need to run a report daily which will send to a list of receipents. The email feature would be perfect for this but our company (10000+ people) do not want our email systems clogged with big reports.

Hi,
you can enable email subscription modifying RsReportServer.config :
...............
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>YOUSMTPSERVER</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName>AAAA</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
........
Then, in email subscription configuration (http://localhost/reports....)
you check that the email sent contains link to report.

Email Subscription not working - help please

Nothing shows up under the "Last Run" column. No error msg or entry in
reporting services or SMTP log.
Looks like reporting server is completly ignoring the subscription entry.
I'm using "once" option and selecting a time just 10-15 minutes ahead.
Here are the entries in my RSReportServer.config file:
----
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>150.8.111.82</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>altbill@.discountcar.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
----
What could be wrong... any ideas...
Thanks
AJHi, I have the exact same problem. I'm running win2003, and you?
"Amit Jain" wrote:
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>
>|||I've tried it on Win2K server and Win2K professional, same issue on both
installations.
"Hennie" <Hennie@.discussions.microsoft.com> wrote in message
news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
> Hi, I have the exact same problem. I'm running win2003, and you?
> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server Email"
>> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> <DefaultHostName></DefaultHostName>
>> <PermittedHosts></PermittedHosts>
>> </RSEmailDPConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="NULL"
>> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> </Delivery>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>|||I fixed it by starting the ReportServer service. I should've have checked
it before posting.
"AJ" <amitjn_ca@.yahoo.ca> wrote in message
news:uIW6bH7AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> I've tried it on Win2K server and Win2K professional, same issue on both
> installations.
> "Hennie" <Hennie@.discussions.microsoft.com> wrote in message
> news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
>> Hi, I have the exact same problem. I'm running win2003, and you?
>> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription
>> entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server Email"
>> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> <DefaultHostName></DefaultHostName>
>> <PermittedHosts></PermittedHosts>
>> </RSEmailDPConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="NULL"
>> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> </Delivery>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>
>|||In general, when you encounter issues like this, check the reporting
services log files. You should see a event polling message and status for
any notifications that are entered. This will also tell you if there are
errors. If you do not see any service log files, you'll need to start the
service called reportserver
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>|||Like Lukasz says, check the report Server Log, if any error occured you will
find them there, in the first example of Amit i would suggest looking in the
logs of the SMTP Server (For example you could send the EMail temporary to
an virtual SMTP Server where you have full control of and relay it to the
productive server to check the logs) or just to check if the SMTP Server
accepted relayed EMails to conenct to the mail server via telnet.
--> telnet Mailserver 25
Rest can be found here:
http://www.yuki-onna.co.uk/email/smtp.html
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Koen" <Koen@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F6365949-8F76-41B7-B74A-182A7A5869C6@.microsoft.com...
> Is there an internal clock or so in reporting services ? Because i'm
> facing
> the same problem, but when i check my log files, i see that the time when
> these files were created is impossible (eg: 2 AM, when nobody's at the
> office
> and the server is shut down).
> Thanks in advance
> "Lukasz Pawlowski [MSFT]" wrote:
>> In general, when you encounter issues like this, check the reporting
>> services log files. You should see a event polling message and status
>> for
>> any notifications that are entered. This will also tell you if there are
>> errors. If you do not see any service log files, you'll need to start
>> the
>> service called reportserver
>> -Lukasz
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
>> news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
>> > Nothing shows up under the "Last Run" column. No error msg or entry in
>> > reporting services or SMTP log.
>> > Looks like reporting server is completly ignoring the subscription
>> > entry.
>> > I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> > Here are the entries in my RSReportServer.config file:
>> > ----
>> > <Extensions>
>> > <Delivery>
>> > <Extension Name="Report Server FileShare"
>> > Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> > <MaxRetries>3</MaxRetries>
>> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> > <Configuration>
>> > <FileShareConfiguration>
>> > <ExcludedRenderFormats>
>> > <RenderingExtension>HTMLOWC</RenderingExtension>
>> > <RenderingExtension>NULL</RenderingExtension>
>> > </ExcludedRenderFormats>
>> > </FileShareConfiguration>
>> > </Configuration>
>> > </Extension>
>> > <Extension Name="Report Server Email"
>> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> > <MaxRetries>3</MaxRetries>
>> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> > <Configuration>
>> > <RSEmailDPConfiguration>
>> > <SMTPServer>150.8.111.82</SMTPServer>
>> > <SMTPServerPort></SMTPServerPort>
>> > <SMTPAccountName></SMTPAccountName>
>> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> > <SMTPUseSSL></SMTPUseSSL>
>> > <SendUsing></SendUsing>
>> > <SMTPAuthenticate></SMTPAuthenticate>
>> > <From>altbill@.discountcar.com</From>
>> > <EmbeddedRenderFormats>
>> > <RenderingExtension>MHTML</RenderingExtension>
>> > </EmbeddedRenderFormats>
>> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> > <ExcludedRenderFormats>
>> > <RenderingExtension>HTMLOWC</RenderingExtension>
>> > <RenderingExtension>NULL</RenderingExtension>
>> > </ExcludedRenderFormats>
>> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> > <DefaultHostName></DefaultHostName>
>> > <PermittedHosts></PermittedHosts>
>> > </RSEmailDPConfiguration>
>> > </Configuration>
>> > </Extension>
>> > <Extension Name="NULL"
>> > Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> > </Delivery>
>> > ----
>> > What could be wrong... any ideas...
>> > Thanks
>> > AJ
>> >
>>

E-mail subscription not a option

Hi,
I'am running reporting services 2000 and I'am having a problem with e-mail
subscriptions. Here the low down.
My reports run without any problems but when I click on new subscription the
only option available is Report server file share. There's no option for
E-mail. At one point I was able to select the e-mail option but decided to
re-do my 2003 server. Any help with this issue would be more than welcomed.Hi,
Fairly simple. Go to ReportServer directory and open RSreportserver.config
search for <Delivery> and inside that find for "Report Server Email" and add
the required things like from:, SMTP server, account name etc...
and restart the reporting server once; you should be getting this option as
well.
Amarnath
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Amarnath,
I've tried that serveral times already and still the e-mail option is not
available. I'am on a corporate domain. Keep in mind that the option was there
a one time, but after I re-did the server I noticed this problem. This is the
delivery section from my RSreportserver.config:
<Delivery>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtprelay.montefiore.org</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
"Amarnath" wrote:
> Hi,
> Fairly simple. Go to ReportServer directory and open RSreportserver.config
> search for <Delivery> and inside that find for "Report Server Email" and add
> the required things like from:, SMTP server, account name etc...
> and restart the reporting server once; you should be getting this option as
> well.
> Amarnath
> "Robert Douglas" wrote:
> > Hi,
> >
> > I'am running reporting services 2000 and I'am having a problem with e-mail
> > subscriptions. Here the low down.
> >
> > My reports run without any problems but when I click on new subscription the
> > only option available is Report server file share. There's no option for
> > E-mail. At one point I was able to select the e-mail option but decided to
> > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Hi Robert,
Try giving IP address in <SMTPServer> section. I faced the same problem.
Amarnath
"Robert Douglas" wrote:
> Amarnath,
> I've tried that serveral times already and still the e-mail option is not
> available. I'am on a corporate domain. Keep in mind that the option was there
> a one time, but after I re-did the server I noticed this problem. This is the
> delivery section from my RSreportserver.config:
> <Delivery>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From></From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
>
> "Amarnath" wrote:
> > Hi,
> > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > search for <Delivery> and inside that find for "Report Server Email" and add
> > the required things like from:, SMTP server, account name etc...
> > and restart the reporting server once; you should be getting this option as
> > well.
> > Amarnath
> >
> > "Robert Douglas" wrote:
> >
> > > Hi,
> > >
> > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > subscriptions. Here the low down.
> > >
> > > My reports run without any problems but when I click on new subscription the
> > > only option available is Report server file share. There's no option for
> > > E-mail. At one point I was able to select the e-mail option but decided to
> > > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Same problem
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Well I managed to get the e-mail option back but e-mail still not working.
I'll keep on trying.
"Amarnath" wrote:
> Hi Robert,
> Try giving IP address in <SMTPServer> section. I faced the same problem.
> Amarnath
> "Robert Douglas" wrote:
> > Amarnath,
> >
> > I've tried that serveral times already and still the e-mail option is not
> > available. I'am on a corporate domain. Keep in mind that the option was there
> > a one time, but after I re-did the server I noticed this problem. This is the
> > delivery section from my RSreportserver.config:
> >
> > <Delivery>
> > <Extension Name="Report Server Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> > <SMTPServerPort></SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate></SMTPAuthenticate>
> > <From></From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > <DefaultHostName></DefaultHostName>
> > <PermittedHosts></PermittedHosts>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="NULL"
> > Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> > </Delivery>
> >
> >
> > "Amarnath" wrote:
> >
> > > Hi,
> > > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > > search for <Delivery> and inside that find for "Report Server Email" and add
> > > the required things like from:, SMTP server, account name etc...
> > > and restart the reporting server once; you should be getting this option as
> > > well.
> > > Amarnath
> > >
> > > "Robert Douglas" wrote:
> > >
> > > > Hi,
> > > >
> > > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > > subscriptions. Here the low down.
> > > >
> > > > My reports run without any problems but when I click on new subscription the
> > > > only option available is Report server file share. There's no option for
> > > > E-mail. At one point I was able to select the e-mail option but decided to
> > > > re-do my 2003 server. Any help with this issue would be more than welcomed.

Email Subscription

Hi There,
Is it posible to create a subscribers list during run time of the report?
How can I specify that while creating a sbuscription in Report Manager?.
For Example,
I've a report which takes 3 parameters. Date1,Date2,EmpID.
The report has to send to only one user thru depending on the EmpID parameter. How can I specify the query while creating the subscription?.
If this can not be done thru subscription. Can this can be done on DeliveryExtension. Any code samples?.
Any help would be much appreciated!.
Thanks in advance.Data Driven Subscriptions can accomplish this. Look at the following
article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_manager_v1_9syq.asp
You can not dynamically change the delivery extension though.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:26B225A6-AA5D-4630-ABA8-D119D3E03087@.microsoft.com...
> Hi There,
> Is it posible to create a subscribers list during run time of the report?
> How can I specify that while creating a sbuscription in Report Manager?.
> For Example,
> I've a report which takes 3 parameters. Date1,Date2,EmpID.
> The report has to send to only one user thru depending on the EmpID
parameter. How can I specify the query while creating the subscription?.
> If this can not be done thru subscription. Can this can be done on
DeliveryExtension. Any code samples?.
> Any help would be much appreciated!.
> Thanks in advance.
>|||Hi Daniel,
I've tried this before I put this query on Newsgroup.
I find the difficulty in specifying the query in the subscription:
select email from tbl_subscribers where uid=@.EmpID(Which is Report Parameter).
can I do this, if so how can I specify the query. The above query is not validating & gives an error message "@.EmpID must be declared".
Thnaks.
"Daniel Reib [MSFT]" wrote:
> Data Driven Subscriptions can accomplish this. Look at the following
> article:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_manager_v1_9syq.asp
> You can not dynamically change the delivery extension though.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> news:26B225A6-AA5D-4630-ABA8-D119D3E03087@.microsoft.com...
> > Hi There,
> >
> > Is it posible to create a subscribers list during run time of the report?
> >
> > How can I specify that while creating a sbuscription in Report Manager?.
> >
> > For Example,
> >
> > I've a report which takes 3 parameters. Date1,Date2,EmpID.
> >
> > The report has to send to only one user thru depending on the EmpID
> parameter. How can I specify the query while creating the subscription?.
> >
> > If this can not be done thru subscription. Can this can be done on
> DeliveryExtension. Any code samples?.
> >
> > Any help would be much appreciated!.
> >
> > Thanks in advance.
> >
>
>|||Sorry. I hope I can not use Data Driven Subscription, since I don't have "Enterprise Edition of SQL Server 2000". I've only Standard Edition.
Is there any other way I can accomplish the task & any samples?.
Thanks.
"Daniel Reib [MSFT]" wrote:
> Data Driven Subscriptions can accomplish this. Look at the following
> article:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_manager_v1_9syq.asp
> You can not dynamically change the delivery extension though.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> news:26B225A6-AA5D-4630-ABA8-D119D3E03087@.microsoft.com...
> > Hi There,
> >
> > Is it posible to create a subscribers list during run time of the report?
> >
> > How can I specify that while creating a sbuscription in Report Manager?.
> >
> > For Example,
> >
> > I've a report which takes 3 parameters. Date1,Date2,EmpID.
> >
> > The report has to send to only one user thru depending on the EmpID
> parameter. How can I specify the query while creating the subscription?.
> >
> > If this can not be done thru subscription. Can this can be done on
> DeliveryExtension. Any code samples?.
> >
> > Any help would be much appreciated!.
> >
> > Thanks in advance.
> >
>
>|||Unfortunately there is no real way to accomplish this in the Standard
Edition. You would have to create a subscription for each user.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:1824340C-E14E-470F-835C-FE8DC3904ABF@.microsoft.com...
> Sorry. I hope I can not use Data Driven Subscription, since I don't have
"Enterprise Edition of SQL Server 2000". I've only Standard Edition.
> Is there any other way I can accomplish the task & any samples?.
> Thanks.
> "Daniel Reib [MSFT]" wrote:
> > Data Driven Subscriptions can accomplish this. Look at the following
> > article:
> >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_manager_v1_9syq.asp
> >
> > You can not dynamically change the delivery extension though.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> > news:26B225A6-AA5D-4630-ABA8-D119D3E03087@.microsoft.com...
> > > Hi There,
> > >
> > > Is it posible to create a subscribers list during run time of the
report?
> > >
> > > How can I specify that while creating a sbuscription in Report
Manager?.
> > >
> > > For Example,
> > >
> > > I've a report which takes 3 parameters. Date1,Date2,EmpID.
> > >
> > > The report has to send to only one user thru depending on the EmpID
> > parameter. How can I specify the query while creating the subscription?.
> > >
> > > If this can not be done thru subscription. Can this can be done on
> > DeliveryExtension. Any code samples?.
> > >
> > > Any help would be much appreciated!.
> > >
> > > Thanks in advance.
> > >
> >
> >
> >|||Ohh...Thnaks Daniel.
"Daniel Reib [MSFT]" wrote:
> Unfortunately there is no real way to accomplish this in the Standard
> Edition. You would have to create a subscription for each user.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> news:1824340C-E14E-470F-835C-FE8DC3904ABF@.microsoft.com...
> > Sorry. I hope I can not use Data Driven Subscription, since I don't have
> "Enterprise Edition of SQL Server 2000". I've only Standard Edition.
> >
> > Is there any other way I can accomplish the task & any samples?.
> >
> > Thanks.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Data Driven Subscriptions can accomplish this. Look at the following
> > > article:
> > >
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_manager_v1_9syq.asp
> > >
> > > You can not dynamically change the delivery extension though.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> > > news:26B225A6-AA5D-4630-ABA8-D119D3E03087@.microsoft.com...
> > > > Hi There,
> > > >
> > > > Is it posible to create a subscribers list during run time of the
> report?
> > > >
> > > > How can I specify that while creating a sbuscription in Report
> Manager?.
> > > >
> > > > For Example,
> > > >
> > > > I've a report which takes 3 parameters. Date1,Date2,EmpID.
> > > >
> > > > The report has to send to only one user thru depending on the EmpID
> > > parameter. How can I specify the query while creating the subscription?.
> > > >
> > > > If this can not be done thru subscription. Can this can be done on
> > > DeliveryExtension. Any code samples?.
> > > >
> > > > Any help would be much appreciated!.
> > > >
> > > > Thanks in advance.
> > > >
> > >
> > >
> > >
>
>

Email Notification

Hi
I run a query against sysjobs table to turn off the email notification, but
still i am getting notification from jobs. Do I need to update any other
table while updating the sysjobs. I had the same issue when i was running a
query against sysjobschedules to reset the active start time . Any
suggestions are appreciable
Regards
SwamiDont know what you did to SysJobs for this, but you probably need to go to
each job and delete the entry from the notifications tab.
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:FB94A9AA-62EE-402C-9A2F-9399A30724F9@.microsoft.com...
> Hi
> I run a query against sysjobs table to turn off the email notification,
> but
> still i am getting notification from jobs. Do I need to update any other
> table while updating the sysjobs. I had the same issue when i was
> running a
> query against sysjobschedules to reset the active start time . Any
> suggestions are appreciable
> Regards
> Swami

Email Notification

Hi
I run a query against sysjobs table to turn off the email notification, but
still i am getting notification from jobs. Do I need to update any other
table while updating the sysjobs. I had the same issue when i was running a
query against sysjobschedules to reset the active start time . Any
suggestions are appreciable
Regards
Swami
Dont know what you did to SysJobs for this, but you probably need to go to
each job and delete the entry from the notifications tab.
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:FB94A9AA-62EE-402C-9A2F-9399A30724F9@.microsoft.com...
> Hi
> I run a query against sysjobs table to turn off the email notification,
> but
> still i am getting notification from jobs. Do I need to update any other
> table while updating the sysjobs. I had the same issue when i was
> running a
> query against sysjobschedules to reset the active start time . Any
> suggestions are appreciable
> Regards
> Swami

Email Notification

Hi
I run a query against sysjobs table to turn off the email notification, but
still i am getting notification from jobs. Do I need to update any other
table while updating the sysjobs. I had the same issue when i was running
a
query against sysjobschedules to reset the active start time . Any
suggestions are appreciable
Regards
SwamiDont know what you did to SysJobs for this, but you probably need to go to
each job and delete the entry from the notifications tab.
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:FB94A9AA-62EE-402C-9A2F-9399A30724F9@.microsoft.com...
> Hi
> I run a query against sysjobs table to turn off the email notification,
> but
> still i am getting notification from jobs. Do I need to update any other
> table while updating the sysjobs. I had the same issue when i was
> running a
> query against sysjobschedules to reset the active start time . Any
> suggestions are appreciable
> Regards
> Swami

Email From address needs to change

Does anyone know how to run reporting services so it can change the From
address for each report it sends. I need to use mutiple From addresses
depending what the report is.Could someone please reply to this posting as I need to know the answer as
well :-)
Thank you,
Lisa
"gamsql" wrote:
> Does anyone know how to run reporting services so it can change the From
> address for each report it sends. I need to use mutiple From addresses
> depending what the report is.

Email Delivery

I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?

If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?

Thanks,

Sam

No there is no such functionality. As you are creating a subscription, as job is created at the SQL Server Agent Service which will keep track of the execution of it, therefore setting the value to a past datetime won′t effect the execution.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

email address domain strip of query

Could this query be made more efficient?
It takes ages to run it. It strips of everything from an email address and keeps only the domain.

SUBSTRING(Mailaddress, CHARINDEX('@.', Mailaddress) + 1, CHARINDEX('.', SUBSTRING(Mailaddress, CHARINDEX('@.', Mailaddress) + 1, 100)) - 1) AS mail_domaingot 2005? string manipulation is faster in CLR.|||unfortunately no i don't. I may upgrade soon but for now it is 2000 im using.|||I assume that if you take this column out of the select list, the plan remains the same, but the query time goes up? Does the query time remain the same when you add the raw email address to the select list (and comment out all the substringing)? I am wondering, if you accidentally got a covering index on all of the fields not associated with the email addresses, or maybe the query is using different indexes for the query with all the substrings.

Also, not to be a nit picker, but which part of the domain are you after? An email address can be very complex. My brother has an email address that ends in @.haystack.mit.edu. Some of our British posters would have addresses like @.company.co.uk. I am guessing you would be interested in the "mit" or the "company", but not in "co' or "haystack".|||yes its from select list and no joins so it should be very fast. I se now that i have to make this to work with thoose split domain names aswell... damn :)

My question about the query was more kinda of " is this a stupid way to do this"?
i can live with the time it takes to run this query it is after al quite a large table.

thx for your help

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!!!!!

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
Thanks
We are running SQL2K SP4 on a windows 2000 server.
"A.B." wrote:

> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks
|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks
|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:

> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>
>
|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...[vbcol=seagreen]
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:

> What if you remote desktop to the server using another machine? Is it slow
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>
>
|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...[vbcol=seagreen]
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:

> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>
>

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
ThanksWe are running SQL2K SP4 on a windows 2000 server.
"A.B." wrote:
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:
> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> > My EM and QA have started to run really slowly have have tried to find the
> > problem but I cannot seem to find it. Does anybody have any suggestions on
> > where to look to solve this problem?
> >
> > Thanks
>
>|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
>> A.B,
>> Are other applications on your machine running slowly as well? Does this
>> happen to other machines? Check out your resource usage on your machine
>> using Task Manager.
>> HTH
>> Jerry
>> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>> > My EM and QA have started to run really slowly have have tried to find
>> > the
>> > problem but I cannot seem to find it. Does anybody have any suggestions
>> > on
>> > where to look to solve this problem?
>> >
>> > Thanks
>>|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:
> What if you remote desktop to the server using another machine? Is it slow
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> > The CPU usage is low and the Memory usage is 1580636K/1942920K
> > They seem to work fine if I go to the server but if I remote desktop to
> > them
> > they are slow. Our network is working fine though so i dont think it is
> > that.
> > I am stumped. This just started happening 2 days ago.
> >
> > "Jerry Spivey" wrote:
> >
> >> A.B,
> >>
> >> Are other applications on your machine running slowly as well? Does this
> >> happen to other machines? Check out your resource usage on your machine
> >> using Task Manager.
> >>
> >> HTH
> >>
> >> Jerry
> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> >> > My EM and QA have started to run really slowly have have tried to find
> >> > the
> >> > problem but I cannot seem to find it. Does anybody have any suggestions
> >> > on
> >> > where to look to solve this problem?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
>> What if you remote desktop to the server using another machine? Is it
>> slow
>> from that machine as well?
>> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>> > The CPU usage is low and the Memory usage is 1580636K/1942920K
>> > They seem to work fine if I go to the server but if I remote desktop to
>> > them
>> > they are slow. Our network is working fine though so i dont think it is
>> > that.
>> > I am stumped. This just started happening 2 days ago.
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> A.B,
>> >>
>> >> Are other applications on your machine running slowly as well? Does
>> >> this
>> >> happen to other machines? Check out your resource usage on your
>> >> machine
>> >> using Task Manager.
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>> >> > My EM and QA have started to run really slowly have have tried to
>> >> > find
>> >> > the
>> >> > problem but I cannot seem to find it. Does anybody have any
>> >> > suggestions
>> >> > on
>> >> > where to look to solve this problem?
>> >> >
>> >> > Thanks
>> >>
>> >>
>> >>
>>|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:
> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
> >I will have to try this tomorrow. Everybody has gone home and there are no
> > computers for me to use right now. I will respond tomorrow.
> >
> > "Jerry Spivey" wrote:
> >
> >> What if you remote desktop to the server using another machine? Is it
> >> slow
> >> from that machine as well?
> >>
> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> >> > The CPU usage is low and the Memory usage is 1580636K/1942920K
> >> > They seem to work fine if I go to the server but if I remote desktop to
> >> > them
> >> > they are slow. Our network is working fine though so i dont think it is
> >> > that.
> >> > I am stumped. This just started happening 2 days ago.
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> A.B,
> >> >>
> >> >> Are other applications on your machine running slowly as well? Does
> >> >> this
> >> >> happen to other machines? Check out your resource usage on your
> >> >> machine
> >> >> using Task Manager.
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> >> >> > My EM and QA have started to run really slowly have have tried to
> >> >> > find
> >> >> > the
> >> >> > problem but I cannot seem to find it. Does anybody have any
> >> >> > suggestions
> >> >> > on
> >> >> > where to look to solve this problem?
> >> >> >
> >> >> > Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
ThanksWe are running SQL2K SP4 on a Windows 2000 server.
"A.B." wrote:

> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that
.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:

> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>
>|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...[vbcol=seagreen]
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
>|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:

> What if you remote desktop to the server using another machine? Is it slo
w
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>
>|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...[vbcol=seagreen]
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
>|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:

> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>
>

Eliminate duplicates from datasource

Hi All,

I have a SP, which i run inside a for loop.

I am running the SP for all the products in a listbox.

So for each product i am having the feature extracted through the SP

But some features are the same for 2, 3 products.

So in the datatable, i am getting the featrues repeated.

IS there any way to eliminate the duplicates from datatable, from server side?

Hope i am not confusing.

Eg: product1 -- test1, test2, test3

product2 -- test2, test4

so the datatable has -- test1, test2, test3, test2, test4

-- i have to eliminate one test2 from this.

Any ideas?

Thanks

Can you just use a SELECT DISTINCT in your stored procedure or whatever you generate your datatable from?

Jeff