Post reply

SSRS report parameter -- avoid duplicate entry

  • February 11, 2009 at 6:51 pm

    #200256

    i am trying to create a report with the field which has duplicate entries.

    i want the duplicate not show up in the drop down

    For Example

    City is the parameter and a field in table

    Many records might contain NewYork as city but i want it to be displayed only once in the drop down

  • February 12, 2009 at 6:57 am

    #942809

    OK, if I follow you correctly you have a data set in which one of the fields is City, and you have a parameter that is a drop-down list of the possible values for City and you only want to have each city show up in this drop-down once.

    I would say that in the SELECT statement you use to get your list of possible cities make sure you use SELECT DISTINCT.

    If I misunderstood what you were asking for, I apologize.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply