reporting services - How to retrieve data from AX query in SSRS data method -

everybody:

i make ssrs report ax report tools. must data ax query. know how add dataset use ax query, not dataset can standard query, must create business logic type dataset because must process these data.

when use business logic dataset, had learned how data sql query, , know how return datatable dataset. don’t know how data user-defined ax query.

i can fetch data sql query below codes:

 datatable table = new system.data.datatable(); // new table variable     table = axquery.executequery("select * inventtable"); 

but can’t build success codes below: remark: had created venttablesrs query in ax aot.

datatable itemquerytable = fimcommonhelper.getparameterdatatable(         fimaxqueries.inventtablesrs,         new object[] { },         new object[] { }); 

i found class of fimaxqueries don’t include query(inventtablesrs). try found class of fimaxqueries is, don’t result.

could tell me how write codes, can run ax query , retrieve result in ssrs report project business logic data method? best way show me sample codes.

thanks much!

spark

everyguy:

i don't answer here search solution , paste sample codes here.

  can copy these codes dataset methods , modified .    -- begin      // no parameter query     #region value of inventtablequery     datatable itemquerytable = fimcommonhelper.getdatatable("inventtablesrs");       /* // parameter query     datatable itemquerytable = fimcommonhelper.getparameterdatatable(         fimaxqueries.inventtablesrs,         new object[] { },         new object[] { });      */     -- end 

i had test in reports design. expert can use it. luck!

spark