default date in a subscription -- sql server reporting services

Penker
11/14/2004 11:11:07 PM

Hello!
I did try the functions you wrote - but it seems that i can not do that in a
subscription - only in the report parameter.
I want to be able to do that when i define a subscription...
Thanks Any Way and if you have other idea - i will be happy if you wrote back.
Thanks!

[quoted text, click to view]

Dejan Sarka
11/15/2004 4:31:35 PM

When you create a subscription, you have possibility to use the default
values of the report parameters (at the bottom of the "New Subscription"
page). So, just put the VB function in the expression for the default value
of the report parameter, and then use this default value in your
subscription.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

[quoted text, click to view]

Ben Sullins
12/22/2004 9:33:05 AM

I tried this several ways to accomplish this and have been unsuccessful. From
what i've read it seems you must set the default params in reoprt designer.
Still having trouble on how to accomplish that. But once I do here is the
function I had planned on using, if you figure out how to set the default
param values in report designer please post. Thanks...

=datetime.today.adddays(-1) --ive tested this in a textbox and it works...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : default date in a subscription