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
order ondansetron 8mg online cheap buy ondansetron 8mg pill bactrim 960mg pill
accutane 40mg generic accutane 10mg uk azithromycin 250mg usa
albuterol price ventolin 2mg oral augmentin 625mg drug
buy generic prednisolone 10mg prednisolone 5mg drug buy lasix pill
provigil 200mg us order provigil 100mg generic cost lopressor 100mg
where can i buy ivermectin for humans ivermectin dosage chart for humans cheap ivermectin for dogs
propranolol us purchase carvedilol without prescription buy coreg 25mg for sale
oxybutynin 5mg ca purchase oxybutynin online cheap buy oxcarbazepine 600mg pills
order cefdinir 300 mg online pantoprazole 40mg price buy pantoprazole 20mg generic
buy dapsone 100mg for sale tenormin tablet order tenormin 100mg
order alfuzosin 10mg without prescription order alfuzosin 10mg for sale buy diltiazem 180mg sale
buy generic ezetimibe order zetia 10mg without prescription buy methotrexate medication
phenergan for sale phenergan without prescription prices of cialis
coumadin 2mg tablet metoclopramide 20mg drug buy allopurinol no prescription
order zyrtec 10mg online atomoxetine us sertraline 100mg pill
buy cenforce 50mg sale aralen cost buy glycomet 500mg
generic escitalopram 10mg buy naltrexone 50 mg sale generic revia 50mg
tadalafil price us cialis sales buy ed pills online usa
ivermectin 3mg price isotretinoin pills buy isotretinoin 10mg for sale
prednisolone usa purchase prednisolone pills furosemide where to buy
buy generic albuterol levothyroxine for sale levoxyl sale
doxycycline 100mg drug amoxiclav cost buy clavulanate online cheap
order atenolol 50mg pills cost femara femara oral
synthroid 150mcg ca buy clomid pills buy vardenafil online cheap
metformin brand glycomet 1000mg for sale amlodipine 10mg ca
order praziquantel 600mg for sale microzide oral cyproheptadine ca
order lisinopril generic omeprazole 10mg for sale buy metoprolol 100mg generic
order lyrica 150mg generic pregabalin 150mg without prescription buy dapoxetine 90mg generic
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
crestor 10mg price buy ezetimibe pill motilium for sale online
ranitidine 150mg tablet celecoxib 100mg drug celebrex price
clopidogrel oral fluvoxamine brand ketoconazole over the counter
order duloxetine 40mg order generic cymbalta 20mg piracetam 800mg usa
The ventricular arrhythmias were responsive to intravenous amiodarone cheap generic cialis
bystolic 20mg brand nebivolol price order clozaril without prescription
cost tegretol 200mg buy tegretol 200mg generic lincomycin 500mg
cialis oral cialis 40mg cheap sildenafil 50mg usa
analyzed 7 metastatic ER breast cancer patients previously exposed to aromatase inhibitors AIs who had an initial response to AI, but subsequently developed resistance 23 can you buy cialis online
metronidazole order online buy sulfamethoxazole online buy cephalexin 125mg online
buy vermox online mebendazole 100mg oral how to buy tadalis
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.
buy avana 100mg without prescription order avana 100mg pill diclofenac 100mg pills
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
order amoxicillin online buy clarithromycin without a prescription clarithromycin 250mg cost
purchase careprost buy bimatoprost tablets order desyrel 50mg pill
how to buy catapres order generic meclizine tiotropium bromide drug
There is no way to rescind a tadbir once he has made it cialis 5mg best price b Ibuprofen in aqueous HCl buffer pH 1
order sildenafil 50mg generic order generic sildenafil 100mg order sildalis pill
generic cialis cost Can drinking a lot of water get rid of yeast infection
cheap leflunomide viagra 100mg oral buy azulfidine for sale
isotretinoin 40mg pill buy generic amoxil over the counter purchase zithromax online cheap
how much does ivermectin cost deltasone usa order deltasone without prescription
furosemide ca furosemide 100mg us order ventolin 2mg generic
order levitra generic buy hydroxychloroquine 400mg online order plaquenil 200mg
order vardenafil 10mg order vardenafil 10mg generic purchase hydroxychloroquine online
buy asacol 800mg online purchase mesalamine online order generic avapro 150mg
buy benicar for sale order divalproex 250mg generic purchase divalproex generic
purchase acetazolamide pill diamox 250 mg us buy generic azathioprine
Very interesting information! Perfect just what I was looking for! My site: online gambling in the philippines
order generic coreg 25mg order coreg generic buy chloroquine 250mg generic
order lanoxin 250 mg for sale order molnunat 200mg sale buy molnunat 200mg pills
buy naprosyn cheap lansoprazole 30mg canada lansoprazole 30mg ca
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