February 23, 2010 at 11:25 am
Hey all,
This probably isn't the perfect place for this question, but hopefully someone can answer me
If I have a report in SSRS with a table control which has a filter on it.. when does the filter get applied? After the data has all loaded, or before?
I'm writing a report from Dynamics AX which for some ungodly reason abandons all sensible notions in reporting and is based off some fairly archaic built in query which I can pull from.. I have created my query but I'm pulling back all info from a view without a date filter because making the date filter is crazy hard - so I put a =Year(Fields!EnteredDate) being equal to "2010" in the table filter in SSRS.. which is fine.. I can pull just 2010 records, but its taking forever to get there, and I suspect its because the filter is applied after the query has already run.
Based on the answer I'll know where I need to focus my time better..
Thanks!
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
February 24, 2010 at 7:36 am
Filters within the report, like on a table/tablix, are applied AFTER all the data is returned from the data source. You really want to pass a date parameter to your query.
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
February 24, 2010 at 7:38 am
thats what i figured from the slowness of the report.. was hoping otherwise of course
thanks for the reply jack 🙂
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply