questions tags users I have a requirement from our client regarding one of the SSRS reports which we are developing for them having multivalue parameter seperated by commas accepting real time parameter entries like below
i have policy no. values like 546546,16464 in the parameter which the user want to search. He can enter more such values to get the recordes as there are around 5lkh records which is not feasible to search for user in the dropdown list. Can anyone provide SSRS solution on this. I dnt have any access to change or make any sort of procedure in the oracle db. I want to do this only in SSRS.. Is this possible???? It will be helpful also if i can get google like search option for automatic dropdown list while typing the content in the search box.
Can you use a conditional parameter list to reduce the amount of policy numbers returned? If not then this doesn't sound like something the SSRS could do. You might want to create a custom application that will allow the user to search for the policy number and then pass that in the url to the report. With the custom application you could look at something like Jquery to read a table of policies and present the most relevant value. Does that help at all?