msdax: Date Range in AOT Query from SSRS

[Blog bot]

Источник: http://msdax.blogspot.com/2011/03/da...from-ssrs.html
==============

[LEFT]
Query:
How can I add date ranges in an AOT query linked to SSRS.

Answer:
Kindly use the following sample code to create a data method and then use it as a source for report data set.

[DataMethod(), AxSessionPermission(SecurityAction.Assert)]

public static DataTable GetData(DateTime fromDate, DateTime toDate)
    {
        DataTable table = new DataTable();
        IDictionary myRanges = new Dictionary();
        myRanges.Add("AOTTable.Date", fromDate.ToString("dd/MM/yyyy") + ".." + toDate.ToString("dd/MM/yyyy"));
        table = AxQuery.ExecuteQuery("select * from AOTQuery", myRanges);
        return table;
    }

Источник: http://msdax.blogspot.com/2011/03/da...from-ssrs.html