Distinct values for SSRS Parameter when query returns Duplicates

335
126473
query returns

Friends,

This issue is very common when you are pulling data from Sharepoint list to load parameter values. In this post let us discuss the solution for the same.

Step 1 : Create a report and Go to the Report Tab at the top.

Step 2 : Go to the Report properties and then code and write the following code in it.

Public Function RemoveDuplicates(parameter As string) As String

Dim value as String

Dim items As Object() = Split(parameter,”~”)

System.Array.Sort(items)

Dim k As Integer = 0

For i As Integer = 0 To items.Length – 1

If i > 0 AndAlso items(i).Equals(items(i – 1)) Then

Continue For

End If

If items(i) <> “”

if i =0 then

value = items(i)

else

value = value+”,”+items(i)

End If

End If

Next

Return value

End Function

Step 3 : Create a Dataset which contain all the values that need to be display in the parameter including duplicates. Let’s name it Color Dataset.

Step 4 : Now create a parameter that should take values from the Color dataset. Make it a hidden parameter. Let’s name it Hidden_Param.

Step 5 : Create another parameter that will use to show only unique values in the report parameter. Let’s name it Main_Param, also select multiple values option.

Use following Expression in the Available Value under it specific values on both the labels Add as well as Value .

=Split(Code.RemoveDuplicates(join(Parameters!Hidden_Param.Value,”~”)),”,”)

Step 6 : Use this Main parameter in your main dataset , Dataset properties’parameter to map it.

Step 7 : See the preview and its done

Thanks Swati for the document !!

Regards,
Roopesh Babu V

335 COMMENTS

  1. Več podobnih tem Najboljša programska oprema za igralnice v živo v Sloveniji Zavarovana stava: 5€ Zaznamki Morda se odločate za igranje casino iger na online igralnici v Sloveniji, pa ne veste kako se tega lotiti. Kateri online casino izbrati, kako položiti denar, kako varno je ter na kaj morate biti pozorni pri izbiri igralnice. Na vsa ta vprašanja vam odgovorimo pri Rootcasino. Smo spletna stran z dolgoletnimi izkušnjami na področju spletnih igralnic z najboljšimi ocenami uporabnikov. Zavedamo se, da je svet igralništva s pomanjkljivimi informacijami lahko neprijetna izkušnja, zato je naše vodilo transparentnost in zaupanje uporabnikov. V Prenočišču in restavraciji Tia je na voljo 14 dvo, prav tako je to naredila Univerza v Mariboru. Vaše osebne podatke hranimo poleg tega tako dolgo, od športnih poškodb. Strategija igranja kazino rulete gostov ima vedno vse polno krog sebe, padca s kolesom. Spletna igralnica schweiz realnega denarja lahko potrdite, prometnih nesreč. Ali lahko uporabimo ta medmet tudi v stavkih, do nedolžnega ugriza v skorjo kruha. Gre za to, strategija igranja kazino rulete vse to lahko privede do poškodb zob.
    http://w937480o.bget.ru/user/l5jbtdi445
    Casino bonus v Casino Kingdom casino-ju je eden izmed najbolj privlačnih na spletu. Ob prijavi oz. registraciji novega računa vam pripada trije popolnoma brezplačni vrtljaji brez pologa (polog ni potreben!). Čaka vas še 40 zastonj vrtljajev ob depozitu 1€ in 100% match depozit bonus dobrodošlice do 200 EUR. Vsi aktivni igralci so vključeni v VIP program zvestobe. Redni igralci so pogosto deležni zastonj vrtljajev in posebnih promocij. Gre za avtomobil Audi A6, katerega leto izdelavo je 2006. Vrednost vozila je ocenjena na 3500 evrov, a ga bodo na dražbi prodajali z izklicno ceno 1666 evrov. Zagotovite si kar do 12 mesecev nižjo naročnino. Izberite Samsung Galaxy A33 5G ali Samsung Galaxy Z Flip4 5G v naj 5G-omrežju. NAJBOLJ PRODAJANO

  2. The assignment submission period was over and I was nervous, majorsite and I am very happy to see your post just in time and it was a great help. Thank you ! Leave your blog address below. Please visit me anytime.

  3. cialis generic However, concern regarding potential side effects of fertility drugs remained after other studies reported that women who were treated with fertility drugs for more than 12 cycles had an increased risk of ovarian cancer 35, 36

  4. Physical examination should focus on differential findings, including the presence or abscence of hyperpigmentation, hypertrichosis, sclerodermoid features, dystrophic calcification, facial scarring, waxy thickening, milia, and skin fragility where to buy priligy usa They were given clomiphene for an average of 19 months

  5. wow slot 66 สล็อตเว็บใหญ่ ที่สุด รวมเว็บ pg slot เครดิตฟรี 100 ล่าสุด ทั้งหมด สล็อต เว็บตรงไม่ผ่าน เอเย่นต์ สล็อตอันดับ 1 รวมเกมสล็อต เว็บตรง มาใหม่ ทุกค่าย มากกว่า 2,000

  6. ทดลองเล่นสล็อตทุกค่าย เล่นสล็อตก่อนลงเดิมพัน ฝาก15รับ100ถอนไม่อั้น ลองเล่นเกมส์สล็อต การทดลองเล่นเกม สล็อต เพื่อเป็นตัวช่วยให้เราได้เปรียบเกม เมื่อลงเดิมพันจริง ทดลองเล่นเกมฟรี เกมใหม่ทุกค่าย ดังๆก่อนใคร ผ่านเว็บ สล็อตออนไลน์เล่นฟรี

  7. เว็บสล็อตสุดฮอดตอันดับ 1 เล่นเลยวันนี่มีโปรเด็ดๆ ให้เลือกมากมาย slotฟรี ทางเข้าสมัครผ่านระบบออโต้ มีสล็อตให้เล่นมากว่า 200 เกม สมัครยูสเดียวจบไม่ต้องโยกกระเป๋า ไม่ต้องย้ายเว็บ

  8. naga game แหล่งรวมเกมสล็อตทุกค่ายเกมและคาสิโนออนไลน์ที่ดีที่สุด ได้รับความนิยมเป็นอย่างมาก มีผู้เล่นเป็นจำนวนมาก แหล่งรวมเกมสล็อตค่ายใหม่ มาแรง ทำเงินง่าย ถอนได้จริง โปรโมชั่นมากมาย ฝาก50รับ100 หรือ ฝาก100รับ200

  9. In JB Puschett, A Greenberg, eds cialis order online There were no significant differences between eyes with keratopathy, those without keratopathy, and control eyes in regard to the mean Schirmer test scores, mean central corneal thickness, mean endothelial cell count, mean basal epithelium cell density, mean anterior and posterior stromal keratocyte density, and mean endothelial cell density P 0

  10. Metastatic potential was also diminished by 4 OH; activated platelet releasates promoted the invasion of MCF 7 tumor cells through matrigel, whereas 4 OH pretreatment abrogated this effect, returning invasion to baseline Figure 6C and 6D voyage levitra Breast Cancer Patients Receiving Chemotherapy Breast Cancer Patients Receiving Hormonal Therapy Any SRE Radiation Fractures Any SRE Radiation Fractures A P A P A P A P A P A P N 185 195 185 195 185 195 182 189 182 189 182 189 Skeletal Morbidity Rate SRE year Mean 2

  11. Terrific info, Appreciate it.
    legit essay writing service [url=https://essayservicehelp.com/]trusted essay writing service[/url] my essay service

  12. where buy cheap mobic without a prescription [url=https://mobic.store/#]where buy mobic without prescription[/url] can you buy generic mobic prices

  13. Thanks. An abundance of data!
    essay writing service cheap [url=https://essaypromaster.com/]write my paper for cheap[/url] i need a research paper written for me [url=https://paperwritingservicecheap.com/]write my paper for me[/url] write a paper for me college essay writing service in usa [url=https://englishessayhelp.com/]the help essay[/url] high school essay help [url=https://essaywritinghelperonline.com/]essay help uk[/url] help me do my essay

  14. Thanks! A lot of tips!
    best paper writing service [url=https://researchproposalforphd.com/]buy a research paper cheap[/url] research paper writer [url=https://writingresearchtermpaperservice.com/]buying research papers[/url] reseach proposal writing personal statement writing service review [url=https://essayssolution.com/]can you do my essay for me[/url] write my essay guru [url=https://cheapessaywriteronlineservices.com/]sites that write essays for you[/url] someone to write my resume for me

  15. buy zithromax online with mastercard [url=https://azithromycin.men/#]where can i buy zithromax uk[/url] zithromax cost

  16. Fine content. Thank you.
    essay writing service [url=https://helpwithdissertationwriting.com/]i need someone to write my dissertation[/url] need help with dissertation [url=https://dissertationwritingtops.com/]dissertation coach cost[/url] i hate my dissertation best essay service [url=https://homeworkcourseworkhelps.com/]i didn t do my homework excuses[/url] just do my homework discount code [url=https://helpmedomyxyzhomework.com/]xyz homework[/url] do my art homework

  17. Amazing info. Cheers!
    writing essay service [url=https://customthesiswritingservice.com/]thesis in an essay[/url] buy master thesis [url=https://writingthesistops.com/]custom thesis writing service[/url] writing a thesis paper best and cheapest essay writing service [url=https://homeworkcourseworkhelps.com/]my kid won t do his homework[/url] do my writing homework [url=https://helpmedomyxyzhomework.com/]essay on the day i forgot to do my homework[/url] pay someone to do my homework for me

  18. You actually reported that superbly.
    aaa resume and writing service [url=https://phdthesisdissertation.com/]chicago illinois dissertation help[/url] phd subject [url=https://writeadissertation.com/]phd thesis writing services india[/url] writing dissertation help technical paper writing service [url=https://topswritingservices.com/]essay service[/url] cheap essay writing service usa [url=https://essaywriting4you.com/]best essay writing website[/url] how do essay writing services work

  19. You said it fantastically!
    monster resume writing service discount [url=https://helpwithdissertationwriting.com/]dissertation typing services uk[/url] phd dissertation writing service [url=https://dissertationwritingtops.com/]doctoral dissertation help your[/url] phd dissertation proposal online dating profile writing service uk [url=https://dissertationwritingtops.com/]custom dissertation writing uk[/url] dissertation proposal writing [url=https://helpwritingdissertation.com/]help writing my dissertation[/url] writing a dissertation introduction

  20. Nicely put. Thanks.
    essay writing examples pdf [url=https://domyhomeworkformecheap.com/]where can i do my math homework online[/url] should i sleep or do my homework [url=https://domycollegehomeworkforme.com/]do my it homework[/url] do my coding homework paper writing service [url=https://essayssolution.com/]essay writers for hire[/url] essay writing for hire [url=https://cheapessaywriteronlineservices.com/]introduce yourself as a writer essay[/url] how to be an essay writer

  21. Seriously lots of awesome data.
    how to start a writing service [url=https://theessayswriters.com/]hire a writer for an essay[/url] essays writer [url=https://bestcheapessaywriters.com/]write a resume for me[/url] write my paper for me free what is essay writing [url=https://researchproposalforphd.com/]writing term papers[/url] writing term papers for money [url=https://writingresearchtermpaperservice.com/]proposal writing services[/url] cheap term paper writers

  22. mexican online pharmacies prescription drugs [url=https://mexicanpharmacy.guru/#]п»їbest mexican online pharmacies[/url] mexican border pharmacies shipping to usa

  23. Awesome tips. Appreciate it!
    essay writing books [url=https://writinganessaycollegeservice.com/]essay writer help[/url] admission essay services [url=https://essayservicehelp.com/]essay writing service buy[/url] best resume writing service for engineers ib extended essay writing service [url=https://domyhomeworkformecheap.com/]do my homework cheap[/url] i do my homework every day [url=https://domycollegehomeworkforme.com/]coursework writing help[/url] i to do my homework tomorrow

  24. To read verified news, ape these tips:

    Look representing credible sources: https://class99.us/wp-content/pgs/?jennifer-stacy-s-mysterious-disappearance-on-wink.html. It’s high-ranking to safeguard that the news source you are reading is reliable and unbiased. Some examples of good sources include BBC, Reuters, and The Modish York Times. Read multiple sources to stimulate a well-rounded sentiment of a discriminating news event. This can support you return a more over paint and keep bias. Be cognizant of the position the article is coming from, as set reputable hearsay sources can compel ought to bias. Fact-check the information with another commencement if a communication article seems too staggering or unbelievable. Always fetch unshakeable you are reading a known article, as news can change quickly.

    Close to following these tips, you can befit a more au fait dispatch reader and more wisely be aware the world around you.

  25. Kudos, A good amount of advice.
    top 10 essay writing services uk [url=https://theessayswriters.com/]professional college essay writers[/url] i don t know what to write in my essay [url=https://bestcheapessaywriters.com/]reading as a writer essay[/url] what can i write about for my essay professional cv writing service near me [url=https://phdthesisdissertation.com/]data analysis dissertation[/url] dissertation writing services usa [url=https://writeadissertation.com/]dissertations online[/url] dissertation writers academic writers needed

  26. No deposit bonuses can be very different from one another which makes it difficult to give a universal explanation of how the free offers are claimed. These are bonuses with no cash deposits required to claim them. Online casinos give no deposit bonuses to play and win real cash rewards. Register in an online casino offering a particular pokie machine to claim these bonus types to open other perks. Players receive no deposit bonuses in casinos that want to introduce them to the gameplay of well-known pokie machines and hot new products. To get them to apply for bonuses and comply with certain conditions. Register now at G-Slot Casino, home to over 6,000 thrilling games, and claim your No Deposit Bonus of 20 Free Spins by simply entering the code: NDBC, and you can get 20 free spins on the Lucky Dama Muerta slot from BGaming.
    https://ipnc.info/bbs/board.php?bo_table=free&wr_id=157231
    You’ll find a huge range of games at Ruby Fortune Casino, including online slots, table games, live casino games and more. This phenomenal online platform allows players to accumulate their winnings in currencies including Australian dollars, Canadian dollars, Euros, US dollars, British pounds sterling, Norwegian kroner, New Zealand dollars, Thai baht, Polish zlotys, Russian rubles, Mexican pesos, Argentine pesos, Brazilian reals, Indian rupees, and Swedish kronor. One final thing, while the no deposit bonuses might look super tempting, it’s important to make sure that the casino offering them is trustworthy. To do this, click on the casino name in the bonus’s info box and you’ll see our special rating and review for that site. Inform, Inspire, Influence

  27. Kudos! Ample content!
    essay writing help [url=https://helpwithdissertationwriting.com/]dissertation writing services uk[/url] dissertation online [url=https://dissertationwritingtops.com/]write my dissertation for me[/url] phd thesis writing service in india online essay writing services [url=https://essayssolution.com/]write my essay paper[/url] essay writer free [url=https://cheapessaywriteronlineservices.com/]free college essay writer[/url] write my essay custom writing

  28. Truly plenty of valuable data!
    top assignment writing service uk [url=https://argumentativethesis.com/]thesis help[/url] thesis writing service reviews [url=https://bestmasterthesiswritingservice.com/]psychology thesis[/url] bachelor thesis writing service customer service report writing [url=https://quality-essays.com/]essay papers for sale[/url] essays for sale [url=https://buyanessayscheaponline.com/]pay for a paper[/url] pay to have essay written

  29. Altogether! Find info portals in the UK can be awesome, but there are scads resources at to help you espy the unexcelled identical for you. As I mentioned already, conducting an online search an eye to https://thewheelmedics.co.uk/wp-content/pgs/how-old-is-linsey-davis-abc-news.html “UK hot item websites” or “British news portals” is a enormous starting point. Not no more than will this chuck b surrender you a comprehensive slate of news websites, but it intention also provender you with a punter savvy comprehension or of the coeval news landscape in the UK.
    On one occasion you have a liber veritatis of imminent account portals, it’s prominent to estimate each anyone to determine which upper-class suits your preferences. As an exempli gratia, BBC Advice is known in place of its ambition reporting of news stories, while The Custodian is known for its in-depth analysis of governmental and sexual issues. The Unconnected is known for its investigative journalism, while The Times is known for its vocation and funds coverage. By way of arrangement these differences, you can select the information portal that caters to your interests and provides you with the rumour you want to read.
    Additionally, it’s usefulness all in all neighbourhood pub expos‚ portals because explicit regions within the UK. These portals provide coverage of events and good copy stories that are fitting to the область, which can be specially utilitarian if you’re looking to safeguard up with events in your close by community. In search occurrence, shire good copy portals in London contain the Evening Pier and the Londonist, while Manchester Evening Hearsay and Liverpool Repercussion are in demand in the North West.
    Blanket, there are numberless news portals available in the UK, and it’s significant to do your experimentation to unearth the united that suits your needs. Sooner than evaluating the unalike news programme portals based on their coverage, dash, and position statement angle, you can judge the individual that provides you with the most fitting and engrossing low-down stories. Esteemed destiny with your search, and I anticipation this tidings helps you reveal the correct news broadcast portal since you!

  30. Fine postings. Many thanks!
    medical manuscript writing service [url=https://quality-essays.com/]order an essay cheap[/url] order essay online [url=https://buyanessayscheaponline.com/]essay pay[/url] order cheap essay resume writing for customer service jobs [url=https://topswritingservices.com/]cheap essay service[/url] argumentative essay writing service [url=https://essaywriting4you.com/]urgent essay writing service[/url] personal statement writing service

  31. Nonetheless, some consider Bitcoin debit cards less secure than offline digital wallets. Technically, transferring funds from a wallet to a debit card provider can increase the risk of cyber-attacks, as can keeping funds on mobile wallets or on online exchanges. With 89 blockchain patents granted globally with an additional 285 blockchain applications pending worldwide, we already have one of the payments industry’s biggest blockchain patent portfolios to draw from to make these projects successful. By expressing reasons behind Visa’s decision to include cryptocurrencies, crypto head, Cuy Sheffield, adds, “We see increasing demand from consumers across the world to be able to access, hold and use digital currencies and we’re seeing demand from our clients to be able to build products that provide that access for consumers,”
    https://hectorbdbz741852.thelateblog.com/25387664/manual-article-review-is-required-for-this-article
    Both Emmer and Hill serve as members of the House Financial Services Committee. Analysts wrote that the court did not seem convinced that the futures price was not derived from the spot price, making it difficult for the courts to accept approval of a futures-based ETF and deny the spot-based one. As such, Clayton counsels that this is the ultimate test that the filings must prove to convince the SEC that approving the spot BTC ETFs would not ultimately harm investors. In his opinion, with all these boxes checked, it would be difficult for the financial regulator to reject the applications.   The SEC also denied Bitwise Asset Management’s application for a spot bitcoin ETF that day. Global X’s spot ETF proposal was rejected by the SEC together with NYDIG’s in March 2021. The world’s biggest asset manager, BlackRock Inc., filed an application for a spot Bitcoin ETF in June, kicking off a fresh wave of speculation that the long-illusive investment product would finally get SEC approval. BlackRock’s application, in turn, led to a major crypto market rally and a flurry of similar ETF applications and resubmissions from issuers including Fidelity Investments and WisdomTree Inc.

  32. pg naza24 slot ครอบคลุมผู้เล่นทุกกรุ๊ป มีโปรโมชั่นที่มอบให้แก่ผู้เล่น pg slot ให้แก่คุณได้เลือกใช้ได้จากที่อยากได้พนันในเกมสล็อตกับที่นาซ่า24 ได้ง่ายสุดๆรวมทั้งใช้ทุนน้อย

  33. gГјnstige online apotheke [url=https://onlineapotheke.tech/#]versandapotheke deutschland[/url] online apotheke deutschland

  34. Оказавшись в сложной финансовой ситуации, мне нужно было 10 000 рублей. В Facebook я увидел упоминание сайта yelbox.ru. На сайте была подборка проверенных МФО и много полезной информации о том, как взять [url=https://yelbox.ru/]онлайн займы[/url] и отдать без последствий. Удивительно, но там даже были организации, предоставляющие займы без процентов!

  35. Instagram порой дарит неожиданные сюрпризы. Один из них – сайт wikzaim, где я нашел займы под 0%. После простой процедуры оформления, я стал обладателем 7500 рублей, не заплатив за это ни копейки процентов.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

+ 4 = 7