trying to get the distinct values in the SSRS report parameter dropdown, but unable to work on the proper query

(0) Share

Report

Posted on by pskateel

102

trying to get the distinct values in the SSRS report parameter dropdown, but unable to work on the proper query

Bydefault it shows all the origin from each row, but i want to take distinct of it

used below property

The report is working fine filtering , the only need is it should show distinct values in the dropdown instead of all , tried many expression but it is throwing error

I have the same question (0)

All responses (6)

Answers (1)

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

Can you please show the query you used in Dataset1?

Was this reply helpful? Yes No
pskateel 102 on at

Like (0)

Report

i have added in the filter condition to filter this parameter

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

Hello,

Now I see. The way you might resolve your issue is:

1. Add a new Dataset that will use "distinct" to merge cs_origin value to get a distinct list of value.

2. Use that Dataset as a source for your dropdown.

Was this reply helpful? Yes No
pskateel 102 on at

Like (0)

Report

I have created dataset and i was able to distinct values from origin, but unless i select the origin from the dropdown it is not showing any data. is it possible to show all the data without selecting the origin

i have added to show all data in default values but it doesn't work

Was this reply helpful? Yes No
pskateel 102 on at

Like (0)

Report

I had few case which didnt had origin field value ,so it was not working, once i deleted all the blank origin case then it was showing all data bydefault.

i had added this xml query for excluding null value , but still if there is any row which has doesnt contain origin then data is not shown in report . not sure why after adding the below condtion still it is not showing all bydefault even if any origin has blank data.

[ <condition attribute="cs_origin" operator="not-in">]

<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">

<entity name="incident">

<attribute name="title"/>

<attribute name="ticketnumber"/>

<attribute name="createdon"/>

<attribute name="incidentid"/>

<attribute name="caseorigincode"/>

<attribute name="cs_origin"/>

<order descending="false" attribute="title"/>

<filter type="and">

<condition attribute="cs_origin" operator="not-in">

<value uitype="cs_origin" uiname="KR"></value>

</condition>

<condition attribute="cs_origin" operator="not-null"/>

<condition attribute="statecode" operator="ne" value="2"/>

</filter>

</entity>

</fetch>

Was this reply helpful? Yes No
pskateel 102 on at

Like (0)

Report

had blank values in 2nd dataset i created, so used <condition attribute="cs_origin" operator="not-null"/> this query in that dataset and it worked

Was this reply helpful? Yes No