SSRS list parameter headscratcher

I'm trying to recreate an Access db list parameter in an SSRS05 report and am having a hard time duplicating a certain desired behavior.

Users must select one name from a (very long) parameter dropdown list. In Access, when they start to input text, values are sort of "predictively" highlighted as they type, e.g. they type s-m-i, and Smith appears as the highlighted option. In SSRS my parameter has the same list as its dataset, but as s-m-i is typed the selection wants to jump around in the list from S to M to I, without selecting Smith. (NB: I bet there is a correct name for this type of input menu, and I wish I knew what it is.)

Can a parameter that behaves the way the Access param does be created in SSRS 05?

Thanks.

Parents
  • I think what you are looking for is called auto complete which is not available to SSRS 2005. Although if you select the parameter and start typing, it will go to the first instance of that key combination so you don't have to scroll so far.

     

    Marty

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Thursday, July 08, 2010 1:01 PM
    To: Martin A. Jones
    Subject: [Tessitura Technical Forum] SSRS list parameter headscratcher

     

    I'm trying to recreate an Access db list parameter in an SSRS05 report and am having a hard time duplicating a certain desired behavior.

    Users must select one name from a (very long) parameter dropdown list. In Access, when they start to input text, values are sort of "predictively" highlighted as they type, e.g. they type s-m-i, and Smith appears as the highlighted option. In SSRS my parameter has the same list as its dataset, but as s-m-i is typed the selection wants to jump around in the list from S to M to I, without selecting Smith. (NB: I bet there is a correct name for this type of input menu, and I wish I knew what it is.)

    Can a parameter that behaves the way the Access param does be created in SSRS 05?

    Thanks.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Unknown said:
    I think what you are looking for is called auto complete which is not available to SSRS 2005.

    i was afraid of that.

    Unknown said:
    Although if you select the parameter and start typing, it will go to the first instance of that key combination so you don't have to scroll so far.

    Yeah, that helps, while we wait for auto complete, perhaps in SSRS08R2?

    Thanks for your reply.

Reply
  • Unknown said:
    I think what you are looking for is called auto complete which is not available to SSRS 2005.

    i was afraid of that.

    Unknown said:
    Although if you select the parameter and start typing, it will go to the first instance of that key combination so you don't have to scroll so far.

    Yeah, that helps, while we wait for auto complete, perhaps in SSRS08R2?

    Thanks for your reply.

Children
No Data