TempDBA
asked on
How to include filter in the column list
Hi Experts,
I am stucked with a problem.I want to know how can I include filtering option on any column so that users can view data that they want to see. i.e. Suppose my report has three columns, CustomerType, Orders, Quantity and I want not to filter the data from the stored procedure but need the user to filter out on the basis of their requirement, and again not by choosing the parameter, something like what we have in Excel sheet, the one I have attached here, how will I do that? I tried using filter option in the SSRS but that's not showing any option for the user. Rather its just doing filtering on the set of condtitions we are giving while preparing the report. Can someone help me out here? Please let me know if I am not clear. Example.xlsx Example.xlsx Example.xlsx
I am stucked with a problem.I want to know how can I include filtering option on any column so that users can view data that they want to see. i.e. Suppose my report has three columns, CustomerType, Orders, Quantity and I want not to filter the data from the stored procedure but need the user to filter out on the basis of their requirement, and again not by choosing the parameter, something like what we have in Excel sheet, the one I have attached here, how will I do that? I tried using filter option in the SSRS but that's not showing any option for the user. Rather its just doing filtering on the set of condtitions we are giving while preparing the report. Can someone help me out here? Please let me know if I am not clear. Example.xlsx Example.xlsx Example.xlsx
The only way to do such stuff is using , parameters or the visibility options
ASKER
So, we don't have any facility that excel sheet provides. In that case, what is the use of filter option?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>As for your requirement: perhaps it's an option for the users to first export the report to Excel and apply their custom filters in Excel?
okay. but was looking if something was similar in reporting service as well.
okay. but was looking if something was similar in reporting service as well.
ASKER
I've requested that this question be deleted for the following reason:
thanks everyone.. I appreciate and respect the effort you guys kept, but I still didn't get my answer.
thanks everyone.. I appreciate and respect the effort you guys kept, but I still didn't get my answer.
Sorry, but even though your problem is not solved and it wasn't mentioned specifically, you did actually get an answer. That answer is "it's not possible"...
See https://www.experts-exchange.com/help.jsp#hs=29&hi=405
See https://www.experts-exchange.com/help.jsp#hs=29&hi=405
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot.
Thanks TempDBA, that's a fair closure!
Thanks, hope you did what you wanted to do...or even close as SSRS has limitations.