SSRS Reports: Date Parameters not filtering report data

%3CLINGO-SUB%20id%3D%22lingo-sub-199517%22%20slang%3D%22en-US%22%3ESSRS%20Reports%3A%20Date%20Parameters%20not%20filtering%20report%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199517%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20SSRS%20Reports%20for%20which%20my%20source%20is%20a%20Tabular%20Model.%26nbsp%3B%20when%20I%20create%20a%20dataset%20%2C%20an%20MDX%20query%20is%20generated%20automatically.%20Now%20my%20requirement%20is%20that%20I%20want%20to%20add%20two%20date%20parameters%20(Start%20and%20end%20dates)%20using%20a%20date%20picker%20and%20use%20them%20to%20filter%20records.%20Also%20I%20do%20not%20have%20date%20dimension%20table%20in%20my%20model.%20All%20I%20have%20is%20different%20date%20fields%20in%20our%20base%20tables%20and%20so%20would%20apply%20this%20filter%20on%20any%20required%20date%20fields.%3C%2FP%3E%3CP%3EThis%20works%20fine%20if%20I%20use%20filters%20on%20dataset%20using%20the%20date%20parameters.%20But%20the%20draw%20back%20is%20it%20fails%20on%20bigger%20data%20sets%20as%20SSRS%20try%20to%20fetch%20all%20the%20records%20and%20then%20applies%20the%20filters.%3C%2FP%3E%3CP%3Eso%20I%20am%20looking%20for%20a%20method%20to%20include%20these%20date%20parameters%20inside%20MDX%20query%20so%20that%20it%20filters%20the%20records%20and%20then%20fetches%20only%20qualifying%20records%20to%20SSRS.%20But%20I%20am%20unable%20to%20achieve%20this%20as%20of%20now.%20I%20have%20already%20posted%20this%20question%20in%20msdn%20forum%20and%20placing%20that%20thread%20here%20for%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fsqlserver%2Fen-US%2Fd3a826d3-d0c7-4cf6-8e03-6f0b63afb42b%2Fssrs-report-not-able-to-filter-records-uisng-date-range-paramters-ssas-tabular-model-as-source%3Fforum%3Dsqlanalysisservices%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fen-US%2F40d1c01a-20eb-4f86-9efe-64bfc9ea362b%2Fssrs-performance-issue-with-date-parameters%3Fforum%3Dsqlreportingservices%26amp%3Bprof%3Drequired%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20some%20one%20help%20me%20in%20achieving%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20Regards%2C%3C%2FP%3E%3CP%3EBalaji%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

 

I am working on SSRS Reports for which my source is a Tabular Model.  when I create a dataset , an MDX query is generated automatically. Now my requirement is that I want to add two date parameters (Start and end dates) using a date picker and use them to filter records. Also I do not have date dimension table in my model. All I have is different date fields in our base tables and so would apply this filter on any required date fields.

This works fine if I use filters on dataset using the date parameters. But the draw back is it fails on bigger data sets as SSRS try to fetch all the records and then applies the filters.

so I am looking for a method to include these date parameters inside MDX query so that it filters the records and then fetches only qualifying records to SSRS. But I am unable to achieve this as of now. I have already posted this question in msdn forum and placing that thread here for reference.

 

https://social.msdn.microsoft.com/Forums/en-US/40d1c01a-20eb-4f86-9efe-64bfc9ea362b/ssrs-performance...

 

can some one help me in achieving this? 

 

Thanks and Regards,

Balaji