TIP SSRS 2008 R2: Make a shared dataset from your query so you can use it any reports that needs the drop down list for ordered months....

Looks to me that the query in your subreport is not correct.

Do you use two hidden parameters in your subreport for StartDate and EndDate both of type datetime ?

If so,...

Hi,

We had this problem also and I found this article first which opened my eyes.

Then I searched for a solution of Microsoft.

I found it on technet. Hereby the url:

Hi,

Maybe it's a marvelous idea, but......

Why do we need this ?

An Excel-user can create a Microsoft Query in Excel (OLEDB) and update the spreadsheet he created with all the formatting...