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.
It is not “exactly” auto-complete, but if you type the characters in quick succession, you can get to a value that is several letters deep. I haven’t been very successful past three characters though. In 2008 I’m able to type “GIK” and get to this selection below GOV (this listed is sorted by fund_no) in the screenshot:
This works in 2005 and 2008.
I’m not sure what changes may be forthcoming in future versions.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones Sent: Thursday, July 08, 2010 3:46 PM To: Ryan Creps Subject: RE: [Tessitura Technical Forum] SSRS list parameter headscratcher
I don't know if it is available in 2008 yet, maybe Ryan Creps knows since he has been playing with it. Ryan ??
Marty
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Thursday, July 08, 2010 2:01 PM To: Martin A. Jones Subject: RE: [Tessitura Technical Forum] SSRS list parameter headscratcher
Marty Jones: I think what you are looking for is called auto complete which is not available to SSRS 2005. i was afraid of that. Marty Jones: 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 Jones:
I think what you are looking for is called auto complete which is not available to SSRS 2005.
i was afraid of that.
Marty Jones: 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.
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.
From: Marty Jones <bounce-martyjones7649@tessituranetwork.com> Sent: 7/8/2010 1:18:14 PM
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.
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
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: It is not “exactly” auto-complete, but if you type the characters in quick succession, you can get to a value that is several letters deep. I haven’t been very successful past three characters though. In 2008 I’m able to type “GIK” and get to this selection below GOV (this listed is sorted by fund_no) in the screenshot:
Cool, the three-fast-chars trick does work, in a browser, though I find it doesn't in the Preview tab in Visual Studio (not the first thing I've noticed like that!)
Thanks, guys.