ssrs dropdown not displaying

(0) Share

Report

Posted on by jhowe

1,205

Hi all,

I have a stored procedure which is filling a parameter dataset. For some reason it's not showing the dropdown??? This is driving me crazy, i've tried deleting, readding etc. i'm stumped...

7416.Capture2.PNG

So the report that is running the data is provided by a stored procedure.

This stored procedure/report has a parameter @Customer VARCHAR(6)

The values for the stored procedure/report are being provided by another stored procedure which is simply retrieving customer records/ID's.

7356.Capture.PNG

Normally a drop down is just created and the user can select a value from the dropdown and this value is passed into the @Customer parameter...

*** UPDATE ***

Think i've found the issue... i'm not sure what's causing it though. If I preview the report customer drop down works fine. The length however is massive and wouldn't be surprised if it's overrunning the limit for rendering the display... How is the length of the dropdowns created? What does SSRS renderer use to display length of field?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

What do you mean with "...stored procedure which is filling a parameter dataset" ?

Please, can give us more details ?

Was this reply helpful? Yes No
Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

What datatype are you binding with this ACCNo field. Your more information will help us to guide you properly.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

as per my understanding dropdown option depends on EDT of the contract parameter

Please verify and update us more details how you have implemented the ACCNo: parameter

Was this reply helpful? Yes No
Suggested answer

Deepak Agarwal 8,602 on at

Like (0)

Report

Hi Jhowe,

I hope you are aware of use of EDTs for drop down option. However in SSRS reports sometimes changes will not reflect untill or unless you will restart the reporting services-> than re deploy the opject.

You can try this, hope this will help.

Was this reply helpful? Yes No
jhowe 1,205 on at

Like (0)

Report

Hi all thanks for your responses. I've updated my original post with additional info/screenshots.

Hi could someone help me with this please it's fairly urgent...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Did you ever figure this out? I am having the same issue. When I preview the report in AX, the multiselect dropdown does not work. When I preview it in Visual Studio, it works. Driving me crazy.

Was this reply helpful? Yes No
jhowe 1,205 on at

Like (0)

Report

I have a feeling that the a certain value that my query is retrieving is overrunning the display limit for the dropdown... I'm going to try and put in a char limit with a convert or something and see how that affects it... Will report my findings.

Was this reply helpful? Yes No
Verified answer

jhowe 1,205 on at

Like (1)

Report

My suspicions were correct. It looks like the dropdown box has a character limit of 20. When I imposed a character limit the dropdown returned. Hope this helps!

Was this reply helpful? Yes No