Parameter on Option Set shows long pick list in SSRS

(0) Share

Report

Posted on by Mick_4711

552

Hi together,

I was building a Report and everything's fine with this.
I integrated a parameter on option set "lead source".
When I start the report I get a long large list with multiple values like shown in the screenshot.
As don't want to set pre-defined values and still want to take the values from database, I want to find a solution for this.
Does anybody have an idea how to solve this?

Best regards
Mick

This is my parameter

1715.parameter.PNG

DataSet1 is the pre-filtering dataset:

8662.DataSet.PNG

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Alex Fun Wei Jie 33,628 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I am using account as an example.

I have many account records with classification = "Default value"

I am using below code

and the result would be only one data

Code for you to copy

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true"> <entity name="account"> <attribute name="accountclassificationcode" />  </entity> </fetch>

Was this reply helpful? Yes No
Mick_4711 552 on at

Like
a
(0)

Report
Copy link

Link copied!

H8780.DataSet.PNG"prettyprint linenums"><fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true"> <entity name="lead"> <attribute name="leadid" /> <attribute name="leadsourcecode" /> </entity> </fetch>

Was this reply helpful? Yes No