Showing posts with label email. Show all posts
Showing posts with label email. Show all posts

Wednesday, March 28, 2012

One EMail for Multiple Notification Types

I have 5 notification classes that a user can subscribe to. If they subscribe to 2 different notification types, can notifications from both of those subscriptions be sent in one e-mail?

I understand digesting but I think it only applies to combining multiple notifications within a given notification class. True?

Any idea if I can notification from 2 different notification classes into one e-mail to the subscriber?

Thanks, Dan

Hi Dan -

You're right, there's nothing built into SSNS that will allow you to digest notifications across different notification classes. There reason is that those notification classes could vary widely in their composition.

HTH...

Joe

One EMail for Multiple Notification Types

I have 5 notification classes that a user can subscribe to. If they subscribe to 2 different notification types, can notifications from both of those subscriptions be sent in one e-mail?

I understand digesting but I think it only applies to combining multiple notifications within a given notification class. True?

Any idea if I can notification from 2 different notification classes into one e-mail to the subscriber?

Thanks, Dan

Hi Dan -

You're right, there's nothing built into SSNS that will allow you to digest notifications across different notification classes. There reason is that those notification classes could vary widely in their composition.

HTH...

Joe

Monday, March 26, 2012

On-Demand E-Mail Delivery

Hi,
Is there a way to deliver reports via email without any subscriptions?
Because, most of the time the reports users will send will only be sent once
and if i create a subscription for each of these i'll end up with hunders of
necessary subscriptions.
Any comments and ideas are welcome. Thanks in advance.
Best regards,
VolkanI solved the problem. In case someone faces a similar situation, i'll write
down my solution for future reference. It's not exactly how i wanted it to be
but at least it works.
01. Create a TimedSubscription and store its subscription ID. (Schedule
value doesn't matter, we'll delete it anyway after email is sent)
02. Call FireEvent method of the ReportingService class with EventData
parameter set to subscription ID.
03. Get subscription list and check if the event is triggered by checking
the LastExecuted property of the subscription object.
04. If the subscription is executed call DeleteSubscription
Maybe there's a better way out there but until i find it i'll stick with
this even tough it has some drawbacks.
Regards.

on EXEC a sp

Please provide more information for others to better understand you problem.
Do you want to send the email when the procedure returns certain result? How
often is the procedure being run? Where exactly is the information regarding
sending the email?
AnithAnith,
Yes, I would like the sp to send an email when the results = TIME. The sp
can be executed using the Agent Job and should be executed daily at 00:01.
Thank you.
"Anith Sen" <anith@.bizdatasolutions.com> escribi en el mensaje
news:edX7krOWGHA.4652@.TK2MSFTNGP04.phx.gbl...
> Please provide more information for others to better understand you
> problem. Do you want to send the email when the procedure returns certain
> result? How often is the procedure being run? Where exactly is the
> information regarding sending the email?
> --
> Anith
>

Friday, March 23, 2012

OmitDocumentMap

I have a report on reporting server that I need to email as excel file weekly.
As default it comes with document map as the first excel tab when exported
which I need to stop from happening.
I have found on the internet that I can use this
<DeviceInfo><OmitDocumentMap>true</OmitDocumentMap></DeviceInfo>
but I dont know where to put it, I tried putting it in different places in
the xml but no good it keeps coming back with errors such as
Deserialization failed: The element 'Report' in namespace
'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'
has invalid child element 'DeviceInfo'
So please can anyone tell me exactly where does the device info need to go?bump
"jl45" wrote:
> I have a report on reporting server that I need to email as excel file weekly.
> As default it comes with document map as the first excel tab when exported
> which I need to stop from happening.
> I have found on the internet that I can use this
> <DeviceInfo><OmitDocumentMap>true</OmitDocumentMap></DeviceInfo>
> but I dont know where to put it, I tried putting it in different places in
> the xml but no good it keeps coming back with errors such as
> Deserialization failed: The element 'Report' in namespace
> 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'
> has invalid child element 'DeviceInfo'
> So please can anyone tell me exactly where does the device info need to go?
>

OmitDocumentMap

I have a report on reporting server that I need to email as excel file weekly.
As default it comes with document map as the first excel tab when exported
which I need to stop from happening.
I have found on the internet that I can use this
<DeviceInfo><OmitDocumentMap>true</OmitDocumentMap></DeviceInfo>
but I dont know where to put it, I tried putting it in different places in
the xml but no good it keeps coming back with errors such as
Deserialization failed: The element 'Report' in namespace
'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'
has invalid child element 'DeviceInfo'
So please can anyone tell me exactly where does the device info need to go?HTML Viewer Commands (rc:)
You use HTML Viewer commands to tell SSRS 2005 how to render the report. You
can use the commands to control how the viewer appears to the user, as well
as to control certain aspects of how the report appears in the viewer.
-- Shows or hides the report document map.
rc:DocMap=true
Reeves
"jl45" wrote:
> I have a report on reporting server that I need to email as excel file weekly.
> As default it comes with document map as the first excel tab when exported
> which I need to stop from happening.
> I have found on the internet that I can use this
> <DeviceInfo><OmitDocumentMap>true</OmitDocumentMap></DeviceInfo>
> but I dont know where to put it, I tried putting it in different places in
> the xml but no good it keeps coming back with errors such as
> Deserialization failed: The element 'Report' in namespace
> 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'
> has invalid child element 'DeviceInfo'
> So please can anyone tell me exactly where does the device info need to go?
>

Monday, February 20, 2012

Old asp pro trying to learn asp.net... having some problems, Help!

Hello everyone! Many thanks in advance for taking the time to help me out. I'll also apologize upfront for the longwinded email, but I seem to be really stuck in a rut. I've been writing web apps for 3+ years in ASP and am finally taking the leap into ASP.net (a bit behind the curve, i know). I have a few books and have gone over the tutorials on this site. I am realizing that the syntax (if using VB) is much the same, but also realize how much richer asp.net is in comparison to traditional ASP.

I'm having some major issues in my learning process that stem from using the tutorials and attempting to be efficient with VS2003. I feel as though I'm missing something fundamental that could be causing my problems. My area of focus right now is data access, using connections, adapters and datasets.

The tutorials on this site show all of the examples by hardcoding the data access into the ASPX page. The tutorials have me importing the proper namespaces for data and sqldata access at the top of the page. This seems to work fine and dandy if I were to be coding my pages from a standard text editor, but I would like to use the richness of the VB.NET studio gui to expedite my work.

My first problem lies if I try to manually code the data access in the private class defined for the page in the codebehind section. Because it will not allow me to import multiple namespaces, the only way I get it to work would be to include the complete namespace for the object I'm trying to use (ie: system.data.sqlclient.sqconnection). On top of this, the datasets I define aren't available as options when I try to bind them to objects in the GUI.

On the flip side, I tried to use the SQLconnection, Dataadapter, etc objects in the gui, but I can't seem to find where the code is dynamically written for these, nor how I can, for example make this sort of connection use an application-variable level connection string. The only way I can see to make this would be to define the connection for each web form, which seems silly when I'm trying to deploy each solution multiple times with different databases.

I apologize for my ignorance, as this is probably fairly simple to overcome. If someone could point out what I'm doing wrong, or point me in the right direction, I'd be very appreciative. I am sick of spinning my wheels with this, and keep getting tempted to go back to using traditional ASP, just so I can get my job done.

Thanks again,

TbldevHave you had a look at the starter kits available on this site?

ASP.NET Starter Kits|||Try these url they have all you need to get up to speed with complete application development which is different from the demos in books. The current Dotnetnuke has a solution(SLN) file that you can open that separates all the different sections of the application into Modules. Remember to download the latest verson, start with the Dotnetnuke Documentation white Papers. The other two links are to the future of Asp.net, ASP.NET 2.0 and the ease of use. Hope this helps.

http://www.dotnetnuke.com

http://lab.msdn.microsoft.com/vs2005/

http://beta.asp.net/GuidedTour/

Kind regards,
Gift Peddie