Drop List problem

Hi,

When I'm creating a dropdown list prompt from a field which has large number of distinct values (OrgUnit codes etc.) I get an empty list.

Can anyone advice on this issue ?

Is your drop down list bound to a dataset.

Thanks,

vnswathi.

|||

Hi,

We are using Cognos right now and moving to SSRS. In Cognos we don't have this problem and this problem occur in SSRS with all kind of field types if it has large amount of distinct values. Maybe it's a restriction in SSRS ? and if so, maybe you know the upper limit ?

Thanks,

Yuval

|||

hi

i dont think there would be any problem with the fields size

u need to create a separate dataset for the drop down list prompt.

and then choose the from query parameter...

hope it solves your issue.

regards,

www.snktheone.com