distinct mvp

hi all,
i use a query that returns a set of projects and customers for my
report. i am using a multi value parameter to filter the projects in
the data. because the grouping is done in the report itself, when i
try to set the mvp from my query each project apears multiple times on
the dropdown list. is there a way to get the distinct projects from
the query? - to get each project to apear once?.
i dont want to create another dataset to get the distinct projects
becuase the query is quite heavy.
or maybe is there a way to create another dataset to query from my
main dataset?
thanks in advance
offaYou can't do a query on an existing dataset. For my parameter lists I have
dedicated datasets. Perhaps if all the query is doing is getting is the
distinct projects it won't be a compute intensive query. Also, you might
want to see what sort of index you have on the table.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<offa23@.hotmail.com> wrote in message
news:1188265077.769587.273140@.k79g2000hse.googlegroups.com...
> hi all,
> i use a query that returns a set of projects and customers for my
> report. i am using a multi value parameter to filter the projects in
> the data. because the grouping is done in the report itself, when i
> try to set the mvp from my query each project apears multiple times on
> the dropdown list. is there a way to get the distinct projects from
> the query? - to get each project to apear once?.
> i dont want to create another dataset to get the distinct projects
> becuase the query is quite heavy.
> or maybe is there a way to create another dataset to query from my
> main dataset?
> thanks in advance
> offa
>

Displaying Multi parameter info : Report builder

Hi All,

Is there is any way to display the User selected parameter information if the parameter is multiselect ?

I was able to display if the parameter is single valued but if it is multivalued (list), i was not able to .

Any help is greatly appreciated.

Regards,

Can you elaborate your question?

Regards,
Ramesh KS

|||

Hi!

Join([your parameter, either value or label], [your delimiter]), will do the trick for you.

//H?kan

|||

Hi.

Thanks a lot , it worked.

|||

HI Bala_SSRS:

Could You Post Your Sources for a code sample ?

TKS

|||

Here is the sample code

=String.Format("Organization Name: {0}",Join(Parameters!OrganizationName.Value,";"))

Thanks,

Bala

Display selected multivalue parameters

I would like to display the selections made for a parameter in a multi select dropdown.

If i do as following for a textbox..doesnt work.

=Parameters!STORELOCATION.Label.ToString

I would like the labels to be displayed as below.

Report is for the following stores: abc, xyz

Pls help!

Use this expression...

=Join(Parameters!Storelocation.label, ", ")

|||Thank you !! This works..

Display selected multivalue parameters

I would like to display the selections made for a parameter in a multi select dropdown.

If i do as following for a textbox..doesnt work.

=Parameters!STORELOCATION.Label.ToString

I would like the labels to be displayed as below.

Report is for the following stores: abc, xyz

Pls help!

Use this expression...

=Join(Parameters!Storelocation.label, ", ")

|||Thank you !! This works..

Display multi value parm in text box

Is there a way to dsiplay all the values of a multi value parm in a text box?

Yes. Set value to =Join(Parameter!Name.Value,", ")

This will give you a comma seperated list. If you want another seperator, simply change what is in the quotes.

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

Display multi value parameter LABEL

Hello.
I have a multi value parameter in my report.
I want to know how can I display all of the selected values in this
parameter in a text box.
Whan I try to use this parameter in a textBox it automaticly take the
value:
Parameter.param.Value(0) Whice take only the first select value.
Is there a simple way of doing it?
Thanks.Ok.
I found it -
=3DJoin(Parameter!param1.value,",")
Thanks.
nicknack =D7=9B=D7=AA=D7=91:
> Hello.
> I have a multi value parameter in my report.
> I want to know how can I display all of the selected values in this
> parameter in a text box.
> Whan I try to use this parameter in a textBox it automaticly take the
> value:
> Parameter.param.Value(0) Whice take only the first select value.
> Is there a simple way of doing it?
> Thanks.|||On Mar 6, 7:26 am, "nicknack" <roezo...@.gmail.com> wrote:
> Ok.
> I found it -
> =3DJoin(Parameter!param1.value,",")
> Thanks.
> nicknack =D7=9B=D7=AA=D7=91:
> > Hello.
> > I have a multi value parameter in my report.
> > I want to know how can I display all of the selected values in this
> > parameter in a text box.
> > Whan I try to use this parameter in a textBox it automaticly take the
> > value:
> > Parameter.param.Value(0) Whice take only the first select value.
> > Is there a simple way of doing it?
> > Thanks.
Good thing to know.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||What if the user selects All and the list of items is very long. For example
vendors you sell their items? How can you show "All Vendors" instead of the
very long list of names. It overruns the report.
--
cjm
"EMartinez" wrote:
> On Mar 6, 7:26 am, "nicknack" <roezo...@.gmail.com> wrote:
> > Ok.
> > I found it -
> > =Join(Parameter!param1.value,",")
> >
> > Thanks.
> >
> > nicknack ×?ת×?:
> >
> > > Hello.
> > > I have a multi value parameter in my report.
> > > I want to know how can I display all of the selected values in this
> > > parameter in a text box.
> > > Whan I try to use this parameter in a textBox it automaticly take the
> > > value:
> > > Parameter.param.Value(0) Whice take only the first select value.
> >
> > > Is there a simple way of doing it?
> >
> > > Thanks.
>
> Good thing to know.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||If, for example, you had a list of 25 vendors you could use:
= IIF(Parameters!Vendors.Count = 25, "All Vendors",
(JOIN(Parameters!Vendors.Label, ", ")))
Just adjust the number the .Count equals to the total number of values in
your parameter list.
"cmayers" wrote:
> What if the user selects All and the list of items is very long. For example
> vendors you sell their items? How can you show "All Vendors" instead of the
> very long list of names. It overruns the report.
> --
> cjm
>
> "EMartinez" wrote:
> > On Mar 6, 7:26 am, "nicknack" <roezo...@.gmail.com> wrote:
> > > Ok.
> > > I found it -
> > > =Join(Parameter!param1.value,",")
> > >
> > > Thanks.
> > >
> > > nicknack ×?ת×?:
> > >
> > > > Hello.
> > > > I have a multi value parameter in my report.
> > > > I want to know how can I display all of the selected values in this
> > > > parameter in a text box.
> > > > Whan I try to use this parameter in a textBox it automaticly take the
> > > > value:
> > > > Parameter.param.Value(0) Whice take only the first select value.
> > >
> > > > Is there a simple way of doing it?
> > >
> > > > Thanks.
> >
> >
> > Good thing to know.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. SQL Server Developer
> >
> >

Display Multi Value parameter in the report as a field

Hi,
I would like to show the Multi value parameter values in my report in the
title.
How can i display all value with comma separated. like If the user selects 4
values of out of 100 , I have to show the report title like "Event
Data:comp1, comp2.."
Regards,
Sriman.Use the Join.String(Parameter!MyParameter.Value,",") method
Michael
"Sriman" wrote:
> Hi,
> I would like to show the Multi value parameter values in my report in the
> title.
> How can i display all value with comma separated. like If the user selects 4
> values of out of 100 , I have to show the report title like "Event
> Data:comp1, comp2.."
>
> Regards,
> Sriman.|||In the expression I have written like this..
=Join.String(Parameters!paramComputerName.Value,",") and got this error
[BC30516] Overload resolution failed because no accessible 'Join' accepts
this number of arguments
Regards,
Sri
"Michael C" wrote:
> Use the Join.String(Parameter!MyParameter.Value,",") method
> Michael
> "Sriman" wrote:
> > Hi,
> >
> > I would like to show the Multi value parameter values in my report in the
> > title.
> > How can i display all value with comma separated. like If the user selects 4
> > values of out of 100 , I have to show the report title like "Event
> > Data:comp1, comp2.."
> >
> >
> > Regards,
> > Sriman.|||try just using Join() instead of Join.String(). How many entries from the
multi value are they picking?
"Sriman" wrote:
> In the expression I have written like this..
> =Join.String(Parameters!paramComputerName.Value,",") and got this error
> [BC30516] Overload resolution failed because no accessible 'Join' accepts
> this number of arguments
> Regards,
> Sri
> "Michael C" wrote:
> >
> > Use the Join.String(Parameter!MyParameter.Value,",") method
> >
> > Michael
> >
> > "Sriman" wrote:
> >
> > > Hi,
> > >
> > > I would like to show the Multi value parameter values in my report in the
> > > title.
> > > How can i display all value with comma separated. like If the user selects 4
> > > values of out of 100 , I have to show the report title like "Event
> > > Data:comp1, comp2.."
> > >
> > >
> > > Regards,
> > > Sriman.|||thank you.
join() worked fine to me.
"Michael C" wrote:
> try just using Join() instead of Join.String(). How many entries from the
> multi value are they picking?
>
> "Sriman" wrote:
> > In the expression I have written like this..
> > =Join.String(Parameters!paramComputerName.Value,",") and got this error
> > [BC30516] Overload resolution failed because no accessible 'Join' accepts
> > this number of arguments
> >
> > Regards,
> > Sri
> >
> > "Michael C" wrote:
> >
> > >
> > > Use the Join.String(Parameter!MyParameter.Value,",") method
> > >
> > > Michael
> > >
> > > "Sriman" wrote:
> > >
> > > > Hi,
> > > >
> > > > I would like to show the Multi value parameter values in my report in the
> > > > title.
> > > > How can i display all value with comma separated. like If the user selects 4
> > > > values of out of 100 , I have to show the report title like "Event
> > > > Data:comp1, comp2.."
> > > >
> > > >
> > > > Regards,
> > > > Sriman.