Can Code be used to define parameters in a subscription?

I am trying to create an email subscription that runs every Monday for the previous week. To do this I was trying to set the start date parameter to dateadd("d", -7, today()) and the end date parameter to dateadd("d", -1, today()). However, every time I change it to anything but a static date value, the screen refreshes and changes the code back to the default date.

I know I can set the defaults to the previous week in the report itself but I already have another subscription that runs the same report as MTD so the parameter defaults are set to that. The only other way I can think to accomplish this is to create a copy of the report with the only difference being parameter defaults (which I don't think is a good solution).

Any suggestions are welcome.

You said that you have the other report run for MTD. What do you mean by that?|||Sorry, Month To Date (MTD)|||Does anyone know if this is possible? I still have not found a solution.

Can Anyone help us

Hi,
I encounter a problem when setting a subscription in rs(with sp2)
:
Failure sending mail: The server rejected the sender address. The
server response was: 503 Authentication needed for local user.
this is my configuration in rsreportserver.config:
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>mail.gillion.com.cn</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate>0</SMTPAuthenticate>
<From>houlh@.gillion.com.cn</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>
IS anythig wrong?
thx a lot!It sounds like your SMTP server requires authentication. RS only support
anonymous and NTLM authentication. If you server uses NTLM then you need to
make sure the user that the ReportServer service runs under has permission
to send mail. If you server requires basic auth then you can use the local
SMTP server to relay the messages. Set the SMTPServerPickupDirectory to the
local SMTP's pickup directory and the SendUsing element to 1. Then
configure the local SMTP server to relay the messages.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"weiyf" <weiyf@.gillion.com.cn> wrote in message
news:%23oQUFspYFHA.3356@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I encounter a problem when setting a subscription in rs(with sp2)
> :
> Failure sending mail: The server rejected the sender address. The
> server response was: 503 Authentication needed for local user.
> this is my configuration in rsreportserver.config:
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>mail.gillion.com.cn</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate>0</SMTPAuthenticate>
> <From>houlh@.gillion.com.cn</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>
> IS anythig wrong?
> thx a lot!
>

calling subscription via the web service

I'd like to force a subscription to run in an adhoc fashion using the web
service provided. Is this possible? If not, does anyone know a work around
to make this happen?Create the subscription as a TimedSubscription with a schedule that fires
once in the past. When you want the schedule to fire, call FireEvent
passing in TimedSubscription and the id of the subscription.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Stewart" <ChrisStewart@.discussions.microsoft.com> wrote in message
news:D8586F2B-EC5B-421B-A167-9A312FCFB8E5@.microsoft.com...
> I'd like to force a subscription to run in an adhoc fashion using the web
> service provided. Is this possible? If not, does anyone know a work
> around
> to make this happen?

Calling Subscription screen inside Report viewer

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

Assuming a clickable link is an appropriate solution here, and assuming that these are RDLs rather than RDLCs (which it seems they are), and if you really want to do it inside the report definition itself, realize that the subscription page is just like any other URL.

You should be able to have a textbox that says "click here to go to the subscriptions page for this report" that navigates to a URL using something similar to this expression for the navigation link:

Code Snippet

="http://YourServer/Reports/Pages/Report.aspx?ItemPath=" &
Globals!ReportFolder & "/" & Globals!ReportName
& "&SelectedTabId=SubscriptionsTab"

... but there is no real advantage to putting this inside the report, IMHO. Why not just something like this expression as a hyperlink in the header of your ReportViewer ASPX page?

>L<

|||

Hello Lisa,

thanks for looking at my problem. you solution works but still have a problem. when i use a link as you suggested in my report viewer the user gets the subscription page but after he completes he is redirected again to show Report manager with all reports.

I have a.rdl file which i show in my web page. but i use this http://<servername>/reportserver?folder name/reportname

this gives me control to show only report with out showing the report manager's header and other details.

eg http://gloss.asp.net/ReportServer?%2fDMS_Reports%2fHB107_Dashboard&rcocMap=false

/Soni

|||

Chandresh, if you don't want them to see the report manager, you shouldn't be sending them to the report manager <s>.

You can interrogate current subscriptions, using the RS SOAP interfaces. You then display whatever limited interface to your users you want, and provide any updates back to RS with SOAP interfaces. Doesn't this make more sense?

>L<

|||

hi again,

many thanks, do you know where can i find more documentation on using RS SOAP API

/Chandresh soni

|||You could start here... http://msdn2.microsoft.com/de-de/library/ms155376.aspx

Or here http://msdn2.microsoft.com/de-de/library/ms155376.aspx

>L<

Calling Subscription screen inside Report viewer

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

Assuming a clickable link is an appropriate solution here, and assuming that these are RDLs rather than RDLCs (which it seems they are), and if you really want to do it inside the report definition itself, realize that the subscription page is just like any other URL.

You should be able to have a textbox that says "click here to go to the subscriptions page for this report" that navigates to a URL using something similar to this expression for the navigation link:

Code Snippet

="http://YourServer/Reports/Pages/Report.aspx?ItemPath=" &
Globals!ReportFolder & "/" & Globals!ReportName
& "&SelectedTabId=SubscriptionsTab"

... but there is no real advantage to putting this inside the report, IMHO. Why not just something like this expression as a hyperlink in the header of your ReportViewer ASPX page?

>L<

|||

Hello Lisa,

thanks for looking at my problem. you solution works but still have a problem. when i use a link as you suggested in my report viewer the user gets the subscription page but after he completes he is redirected again to show Report manager with all reports.

I have a.rdl file which i show in my web page. but i use this http://<servername>/reportserver?folder name/reportname

this gives me control to show only report with out showing the report manager's header and other details.

eg http://gloss.asp.net/ReportServer?%2fDMS_Reports%2fHB107_Dashboard&rcocMap=false

/Soni

|||

Chandresh, if you don't want them to see the report manager, you shouldn't be sending them to the report manager <s>.

You can interrogate current subscriptions, using the RS SOAP interfaces. You then display whatever limited interface to your users you want, and provide any updates back to RS with SOAP interfaces. Doesn't this make more sense?

>L<

|||

hi again,

many thanks, do you know where can i find more documentation on using RS SOAP API

/Chandresh soni

|||You could start here... http://msdn2.microsoft.com/de-de/library/ms155376.aspx

Or here http://msdn2.microsoft.com/de-de/library/ms155376.aspx

>L<