Browsing All posts tagged under »Date Parameter«

Using the DatePicker in SSRS with MDX

March 22, 2011

4

This post, continuing on from the previous post https://jsimonbi.wordpress.com/2011/03/22/using-a-date-parameter-in-ssrs-with-mdx/, shows how to use the DatePicker functionality within SSRS as a parameter for an MDX query. First we set up the Date parameter, which we will call pDate. We change the data type to Date, and leave all other tabs with the default settings. We then […]

Using a Date Parameter in SSRS with MDX

March 22, 2011

2

There are two ways of using a date parameter within SQL Server Reporting Services for reports using SSAS as the source. I’d firstly like to thank my friend Boyan Penev for helping me out with some MDX questions I’ve had – please visit his excellent blog: http://www.bp-msbi.com/ The first method is to use a MDX […]