August 21, 2013 at 2:25 pm
we already know these below filters but these will be applied before execution of the report.
Report Filter.
Dataset Filter
How to apply filters on top of the data which report returns??
I am just looking for having a filter like in Excel on top of the each column.
Is it possible from SSRS without using Parameters and Filters?
In summary i am giving the below information for more clarity..
How to apply filters in SSRS on top of the Report data which gets displayed in SSRS?
How ever I am looking the other option, for example in generally after downloading the report into some excel we will filter the data in excel according to our business needs.
Lets say i ran the report and that report got 20 fileds....so once user run the report and exported into excel he can filter the data on each field if he wants to filter.
In similar fashion when the report is executed, can the user do the filter on any field which he want?
August 21, 2013 at 2:44 pm
Hi Friends
Any inputs on this issues please?
August 21, 2013 at 3:09 pm
I don't believe that there is a way to do this natively with SSRS. You have to export to Excel for this functionality.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 21, 2013 at 3:11 pm
cnubabudwh (8/21/2013)
Hi FriendsAny inputs on this issues please?
Patience is a virtue. You have posted your question for not yet 15 minutes, and you're already sending out PM's and emails.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 21, 2013 at 3:15 pm
Thanks Jack,
I have also with same idea but would like to cross check with experts like you.
thanks for your kind response.
August 21, 2013 at 3:17 pm
Sorry for that
I am new to this fourm hence i just sent reply for some help.
generally i will post in sdn and will get reply in less than 5 minutes, hence i though it be good if i can follow up.
Anyways now onwards will not followup or email and will wait for the answer.
Sorry as this is first time please excuse my mistake 🙂
August 22, 2013 at 2:04 am
Hi Folks,
Before closing this thread just informing you all that this option is not possible through SSRS.
If any one have not agree with this then kindly let me know so that i will open this thread and will not close.
This might be helpful for others as well.
Thanks
August 22, 2013 at 2:05 am
cnubabudwh (8/22/2013)
Hi Folks,Before closing this thread just informing you all that this option is not possible through SSRS.
If any one have not agree with this then kindly let me know so that i will open this thread and will not close.
This might be helpful for others as well.
Thanks
You cannot close topics here 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2013 at 2:16 am
Oh is it,
Could you please kindly let me know when I am happy with the response and when i feel the solution is correct then how can i mark this question as answered?
So that others will be able to identify that this is correct answer and accordingly they can apply these methods in their work environment?
August 22, 2013 at 2:33 am
cnubabudwh (8/22/2013)
Oh is it,Could you please kindly let me know when I am happy with the response and when i feel the solution is correct then how can i mark this question as answered?
So that others will be able to identify that this is correct answer and accordingly they can apply these methods in their work environment?
You can't.
This is an actual forum, where topics are treated as discussions. Old-school isn't it? 🙂
If you want the question-answer format, the ask.sqlservercentral.com site provides this.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply