"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/

"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/
>>
>>
>>

"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/
>>>
>>>
>>>
>
>