Showing posts with label subject. Show all posts
Showing posts with label subject. Show all posts

Monday, March 19, 2012

Displaying Report Parameters in File Name

Does anyone know if it is possible to set up a subscription that includes
report parameters in the subject line when emailing a report or report link?
Thanks for the help!!
AnthonyThe only way to accomplish this is to use data driven subscriptions. Even
with this approach you would need to write your query to build up the
subject line.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:8396CC2A-C4C2-4477-AA68-E1508A7159AD@.microsoft.com...
> Does anyone know if it is possible to set up a subscription that includes
> report parameters in the subject line when emailing a report or report
> link?
> Thanks for the help!!
> Anthony|||Ok that is the only way I could think of. Thanks!
"Daniel Reib [MSFT]" wrote:
> The only way to accomplish this is to use data driven subscriptions. Even
> with this approach you would need to write your query to build up the
> subject line.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:8396CC2A-C4C2-4477-AA68-E1508A7159AD@.microsoft.com...
> > Does anyone know if it is possible to set up a subscription that includes
> > report parameters in the subject line when emailing a report or report
> > link?
> >
> > Thanks for the help!!
> >
> > Anthony
>
>

Friday, February 17, 2012

display multi value parameters in textbox

Hello,

I have the following problem.

i have a report where you need to fill in a few parameters

start date, end date and subject selection.

the subject selection is a multivalue paramter (select all, param1, param2, param3)

the multivalue parameter is based on another dataset with paramid as value field and paramdescription as value label.

in my report i want to display something like this :

from startdate to enddate

summary for campaign(s) : selected parameters.

in the selected parameters is can display a =join(Parameter!campaig.value) but this only returns the 32bit guid.

instead i would like it to display the parameterdescription label.

anybody has some ideas ?

greetings

vince

Hi Vince,

I think using the expression =Join(Parameters!campaign.Label) should give you the desired result.

-Aayush