Email Deleivery

Hi,
I am using Emai Delievery Subscription feature of MSRS 2000. I have a
requirement where I can use different "From" address for Different group of
reports. Currently as I know there is only one from Adress I can use through
the RSReportServer.config file. I tried making a copy of the "Report Server
Email" delievery extension(with different From Adress) within the config
file and renaming it to "Report Server Email2" hoping that it will give me
one more drop down item with extension "Report Server Email2" in the
subscription window but it doesnt. Looks like the Extension Name is critical.
Is there a easy way to achieve this requirement . I am just avoiding to
write my own custom deleivery estension.
I just need to have different "from" adress for my different reports.
for eg SalesReports from :SalesAdmin@.MyCompany.com
and MarketingReports from :MarketingAdmin@.Mycompany.com.
Thanks in advance,
Cheers,
siajHi, siaj
what's the criteria that determines which address to use? why do you
need multiple addresses?
I am afraid that, from what you've expressed so far, you're gonna need
a custom email delivery extension. You can easily write that since
you're just gonna extend the existing extension, then add an extra
config file where you can setup the different email accounts, and roll
some code to look up the correct email address based on a specified
criteria (such as the report name, or folder, etc.).
regards,
Thiago Silva|||Thanks Thiago...
I guess I will have to go the Custom Delivery extension route !!
:)
Cheers,
siaj
"tafs7" wrote:
> Hi, siaj
> what's the criteria that determines which address to use? why do you
> need multiple addresses?
> I am afraid that, from what you've expressed so far, you're gonna need
> a custom email delivery extension. You can easily write that since
> you're just gonna extend the existing extension, then add an extra
> config file where you can setup the different email accounts, and roll
> some code to look up the correct email address based on a specified
> criteria (such as the report name, or folder, etc.).
> regards,
> Thiago Silva
>

Email Alert

I'm trying to develop a email alert feature on my project. I was trying to approach with SQL trigger wich I think is the best option. Basically, when a new record is inserted into ad table, a email alert goes to peolpe who selected to receive alert wehen certain conditions are met. What would be the best approach? any examples?
ThanksThat sounds a lot likeSQL Server Notification Services, a free download if you are using SQL Server.
|||Thanks for the reply. Is MS Notification Services SP1 what I need?

Eliminating spaces left by collapsed drilldown option

I have a report which has the hidden/drilldown feature enabled when the
report is opened. The problem, visually, that I am having, is that the next
group's spaces are visible both on the rendered web page and the preview pane
in the Visual Studio. Does anyone know of a way to "collapse" the blank
lines (like in Crystal Reports) so that the items you can drilldown to
initially appear one right after another, only spreading out to accomodate
the information under each one when that particular group heading is expanded?
Thanks!Catadmin wrote:
> I have a report which has the hidden/drilldown feature enabled when
> the report is opened. The problem, visually, that I am having, is
> that the next group's spaces are visible both on the rendered web
> page and the preview pane in the Visual Studio. Does anyone know of
> a way to "collapse" the blank lines (like in Crystal Reports) so that
> the items you can drilldown to initially appear one right after
> another, only spreading out to accomodate the information under each
> one when that particular group heading is expanded?
> Thanks!
Put the table/matrix inside a rectangle and toggle the rectangle's
visibility.
Works for me
Highly Obscure

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