report manager parameters

Greetings...
I have a report that is going to be distributed daily. I need the subject of
the email to be something like, 'Sales Report for <date>' where date is the
date it was ran for. I tried using the report parameter but it only gave me
the parameter name, not the value. Does anyone know how to accomplish this?
Thanks,
--
Ben Sullins
Our Vacation Store
http://ovstravelfolio.com/Change expression to this:
= "Sales Report for " & parameters!paramname.value
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
news:2419A8DB-1C02-458D-A16B-20FC3B1C7DDD@.microsoft.com...
> Greetings...
> I have a report that is going to be distributed daily. I need the subject
of
> the email to be something like, 'Sales Report for <date>' where date is
the
> date it was ran for. I tried using the report parameter but it only gave
me
> the parameter name, not the value. Does anyone know how to accomplish
this?
> Thanks,
> --
> Ben Sullins
> Our Vacation Store
> http://ovstravelfolio.com/|||Not working...
I'm typing this into the subscriptions page in report manager, this is what
it looks like. I tried using the ampersand and the plus sign, both just
showed up exactly as I typed them.
="Combined Sales Master updated through " + Parameters!startdate.value
"Bruce L-C [MVP]" wrote:
> Change expression to this:
> = "Sales Report for " & parameters!paramname.value
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
> news:2419A8DB-1C02-458D-A16B-20FC3B1C7DDD@.microsoft.com...
> > Greetings...
> >
> > I have a report that is going to be distributed daily. I need the subject
> of
> > the email to be something like, 'Sales Report for <date>' where date is
> the
> > date it was ran for. I tried using the report parameter but it only gave
> me
> > the parameter name, not the value. Does anyone know how to accomplish
> this?
> >
> > Thanks,
> > --
> > Ben Sullins
> > Our Vacation Store
> > http://ovstravelfolio.com/
>
>|||I'm sorry, I missed about it being the subject of the email. I thought you
meant as the title of the report. I haven't tried to modify the email
subject. Sorry. You could have the subject of the email static and have the
title of the report (a textbox at the top of the report) have the
expression.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
news:2CCFC05A-BA10-4747-ABB9-EE044A2EA8F1@.microsoft.com...
> Not working...
> I'm typing this into the subscriptions page in report manager, this is
> what
> it looks like. I tried using the ampersand and the plus sign, both just
> showed up exactly as I typed them.
> ="Combined Sales Master updated through " + Parameters!startdate.value
> "Bruce L-C [MVP]" wrote:
>> Change expression to this:
>> = "Sales Report for " & parameters!paramname.value
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
>> news:2419A8DB-1C02-458D-A16B-20FC3B1C7DDD@.microsoft.com...
>> > Greetings...
>> >
>> > I have a report that is going to be distributed daily. I need the
>> > subject
>> of
>> > the email to be something like, 'Sales Report for <date>' where date is
>> the
>> > date it was ran for. I tried using the report parameter but it only
>> > gave
>> me
>> > the parameter name, not the value. Does anyone know how to accomplish
>> this?
>> >
>> > Thanks,
>> > --
>> > Ben Sullins
>> > Our Vacation Store
>> > http://ovstravelfolio.com/
>>|||You can use the @.ExecutionTime token in the subject to get the time the
report was run.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%239$3vzS9EHA.3616@.TK2MSFTNGP11.phx.gbl...
> I'm sorry, I missed about it being the subject of the email. I thought you
> meant as the title of the report. I haven't tried to modify the email
> subject. Sorry. You could have the subject of the email static and have
> the title of the report (a textbox at the top of the report) have the
> expression.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
> news:2CCFC05A-BA10-4747-ABB9-EE044A2EA8F1@.microsoft.com...
>> Not working...
>> I'm typing this into the subscriptions page in report manager, this is
>> what
>> it looks like. I tried using the ampersand and the plus sign, both just
>> showed up exactly as I typed them.
>> ="Combined Sales Master updated through " + Parameters!startdate.value
>> "Bruce L-C [MVP]" wrote:
>> Change expression to this:
>> = "Sales Report for " & parameters!paramname.value
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
>> news:2419A8DB-1C02-458D-A16B-20FC3B1C7DDD@.microsoft.com...
>> > Greetings...
>> >
>> > I have a report that is going to be distributed daily. I need the
>> > subject
>> of
>> > the email to be something like, 'Sales Report for <date>' where date
>> > is
>> the
>> > date it was ran for. I tried using the report parameter but it only
>> > gave
>> me
>> > the parameter name, not the value. Does anyone know how to accomplish
>> this?
>> >
>> > Thanks,
>> > --
>> > Ben Sullins
>> > Our Vacation Store
>> > http://ovstravelfolio.com/
>>
>