Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to create parameter without repeate the same value when we created datasource "Selection type as SHAREPOINT LIST"

Answered How to create parameter without repeate the same value when we created datasource "Selection type as SHAREPOINT LIST"

  • Wednesday, February 27, 2013 2:13 PM
     
     
    Sign In to Vote
    0

    I have created report by using Report Builder 3.0. I have created datasource "Selection Type as SHAREPOINT LIST". One column(Title) of that Sharepoint list is having repeated value,means that Tilte value is as

    Title

    A

    A

    B

    B

    B

    C

    C

    Also created the Parameter with that Title by using "GET VALUES FROM QUERY".The parameter is giving  the repeated value in drop down,Means Dropdown value is as A,A,B,B,B,C,C.

    But i need that drop down value should be A,B,C only. How to group by that when we we use "Selection type as SHAREPOINT LIST".I can use SPECIFY VALUES when we create parameter.But i want group by with GET VALUES FROM QUERY.

    Please do the needful.

    Kanthavel

     

All Replies