how to display calender control in mdx reports

Question

how to display calender control in mdx reports

Answer 1

Hi Vijay,

I am assuming when you say calendar control, you are referring to a datetime parameter on a report that uses MDX to fetch data from a cube. The only way I can think of having a calendar control on a report is for a parameter that's of datetime data type.

When you add a parameter to your report, just change its Data Type to Date / Time.

Now when you preview your report, you will see the calendar control:

You can explain your requirement in greater detail and we surely can help you out.

HTH.

Cheers,

IceQB

---

Please mark correct answers :)

Answer 2

is this will work on mdx reports

Answer 3

Hi Vijay60,

Yes, parameters on SSRS reports are independent of the type of data source / the way you are querying data source.

Here are two links (read them in the order provided) that will tell you how to use date pickers (calendar control) on reports that are built using MDX:

1. http://jsimonbi.wordpress.com/2011/03/22/using-a-date-parameter-in-ssrs-with-mdx/

2. http://jsimonbi.wordpress.com/2011/03/22/using-the-datepicker-in-ssrs-with-mdx/

Let me know if you need any further info.

HTH.

Cheers,

IceQB

---

Please mark correct answers :)