Sunday, April 3, 2011
Thursday, March 31, 2011
Date Range in AOT Query from SSRS
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.Add("AOTTable.Date",
fromDate.ToString("dd/MM/yyyy") + ".." + toDate.ToString("dd/MM/yyyy"));
table = AxQuery.ExecuteQuery("select * from AOTQuery", myRanges);
return table;
}
Wednesday, March 30, 2011
Tuesday, March 29, 2011
SQL Padding Zeros, Pad / Trim Leading Zeros - SQLUSA
SQL Padding Zeros, Pad / Trim Leading Zeros - SQLUSA: "REPLACE(STR(ReorderPoint, 6), SPACE(1), '0')"
Subscribe to:
Posts (Atom)