SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Manager's Subscriptions Page column/field view


Report Manager's Subscriptions Page column/field view

Author
Message
DavidT-603995
DavidT-603995
SSC Veteran
SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)

Group: General Forum Members
Points: 201 Visits: 247
Hi

Does anyone know if you can configure the Subscriptions page of a Report Manager report, to add additional fields to it, such as the email subject line.

The reason is I have a report with several dozen subscriptions set up by multiple users, and the standard view of Description (which for emails is just the email address it is being sent to), and then just the run time and status, is not enough for users to be able to identify the difference between their groups of subscriptions.

If it was configurable to be able to add in the email subject line, this would help.

Possible?

Thanks
David
Daniel Bowlin
Daniel Bowlin
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8146 Visits: 2629
I don't think so, but I am not positive. However, I think you have a great idea. :-)

I couldn't build this without a fair amount of research, but I am reasonably sure you could build a report based on the report server db that could have the columns you want.
DavidT-603995
DavidT-603995
SSC Veteran
SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)

Group: General Forum Members
Points: 201 Visits: 247
Hi, Thanks for your reply.

I'm sure you're right that a report could be built to show the subscription details of a report or all reports, but could this be tied into the administration side of the subscriptions? ie allow users to identify their different subscriptions easily, so they can then chose the ones they want to administer?

Could the said report be used in place of the existing subscriptions page, but still allowing drill through(!), or could the standard report allow a hyperlink or drill through to the subscription editing details (again “!”).

Do you see the point, it's less about viewing the subscription list and more about identifying which subscription you want to edit if you have multiples with the same email name and run dates.

Any additional thoughts?

Thanks again.
David

ps. the below code shows the location for the subscription data.
Lifted from a posted script, apologies to the original poster, I cannot remember the source:



use reportserver
go

select
cat.Name,
u.username 'Report Author',
replace(S.[DeliveryExtension],'report server ','') 'Type',
S.[ExtensionSettings],
Parameters,
Modified.[UserName] 'Subscription Modifier/Creator',
S.[ModifiedDate],
replace(S.[Description],'send e-mail to ','') 'Distribution List',
S.[LastStatus],
CAT.[Path],
S.[LastRunTime]
from
[Subscriptions] S
inner join [Catalog] CAT on S.[Report_OID] = CAT.[ItemID]
inner join [Users] Owner on S.OwnerID = Owner.UserID
inner join [Users] Modified on S.ModifiedByID = Modified.UserID
inner join users u on cat.createdbyid = u.userid
left outer join [SecData] SD on CAT.PolicyID = SD.PolicyID AND SD.AuthType = 1
left outer join [ActiveSubscriptions] A with (NOLOCK) on S.[SubscriptionID] = A.[SubscriptionID]
where S.[LastStatus] not LIKE '%was written%' and S.[LastStatus] not LIKE '%mail sent%' and S.[LastStatus] not LIKE '%New Subscription%' and S.[LastStatus] not LIKE '%been saved%'
Order by s.lastruntime desc


oozlem.koc
oozlem.koc
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 26
Hi,

Did you find any solution about the email subject line?

Thanks
Daniel Bowlin
Daniel Bowlin
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8146 Visits: 2629
The only suggesion I have regarding Report Manager is the My Subscriptions link at the upper right. I believe that will limit the subscriptions to the user, but it may be that they had to set up the subscription for themselves in the first place. I'm not sure.

Other than that it sounds more like some custom ASP.NET or a simple app front end. Either way you are looking at some custom work.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search