Hello
I want to have a report query parameter which has many thousands of possible values (i.e. Customer Names). I need to provide the ability to allow a user to search for the customer they want and then have that customer's detail appear in the parameter.
Ideally I would like something like the ability to have a "Find" button next to the parameter that would kick off a "Find" report and then pass the value selected back to the original parameter.
The parameter in question is one of a numvber (6) on the actual report so have discounted the option of creating a "Find Customer" report as step 1 and then passing the selection forward to the actual report (Step 2) i.e. drill through.
Any thoughts/suggestions would be much appreciated as I know I will have many of these scenarios in the coming months as I will be using numerous parameters with large selection lists.
Thanks in advance
Eliot
No user is going to want a maseeev ddlist to scroll through.
Has anyone ever tried using code to do an ajax/google suggest type thing?
If so please post!
I think you are going to have to use cascading parameters
So free entry text param 1 allows the user to enter some of the name
param 2 is driven by this and does some sort of fuzzy matching to return a list of possible candidates LIKE 'param1' + '%' (soundex also might help)
|||Thanks for your reply.
Using Cascading parameters will work in some cases but not in this particular situation as I need to provide multiple ways to search for a customer. i.e. Surname, Customer Number, Postcode etc.
However, some of my scenarios could use cascading parameters.
Any other thoughts out there?
No comments:
Post a Comment