Hi SQL experts !
I am getting used to report developments under SSRS (2012, moving soon to 2016), but I have one insolvable problem.
To make it quick, my job is to migrate reports from Hyperion Interactive Reporting (know as BRIO) to SSRS. That one functionnality I am in trouble with was existing in BRIO, but I can't manage to do the same with SSRS.
Here is an example of an old report :
The user can choose to filter any fields he wants, with an operator of his choice. He can do that on the number of fields he wants, the selected filters are stored and shown at the right (it's in French btw, sorry for that). Then, he asks for execution and the tables will appear, with all the filters selected.
I was already in trouble making that same kind of filter working only one time, because of the operator. My solution was to create 3 parameters, including one with operators, and write all the possible cases in my SQL Stored Procedure.
For now in my reports I have 3 parameters to create that filter : Column name, operator, and value to filter (text area). But they only work one time ! They can't store a first filter, then a second, etc... and apply all of them when I ask for the report's display.
This is a very annoying situation, my actual reports are obviously not functionnal but I can't find any idea. Is there a way to do the same with SSRS ? Using multiple times the same parameters, or letting the users filter on the fields they want before of even after execution ? I couldn't find any proper way to do it anywhere on the net.
Thank you by advance for you help or ideas and greetings from Paris,