Filtering Data On SSRS Query

Hi,
Below is the sample code written to filter the data based on Query used by report and apply on custom query in DP class;

//DP class
queryVendInvoiceJour=this.parmQuery();
//Get filtered/selected value from standard query
qrOrderAccount = queryVendInvoiceJour.dataSourceName(‘VendInvoiceJour’).rangeField(fieldNum(VendInvoiceJour,OrderAccount));
//Writing custom query based on requirement but applying the selected ranges to custom query
q=new Query();
qbdsVendInvoiceJour = q.addDataSource(tablenum(VendTrans));
qrVendInvoiceJour = qbdsVendInvoiceJour.addRange(fieldNum(VendTrans,AccountNum));
q.dataSourceNo(1).rangeField(fieldNum(VendTrans,AccountNum)).value(qrOrderAccount.value());
qr = new QueryRun(q);

This will help to overwrite the Query used in Report using the custom query by applying same ranges selected by user.

Task Recorder in ax2012:

Task recorder in ax just fallow these steps:

1.       Goto File in Ax workspace:

2.       File > Tools > Task Recorder

3.       Goto settings and parameters

Create a folder in computer and give the path to take the document.

Then you can start the record.

4.       After recording the task it will show the word document in your folder

5.        

A call to the Microsoft Dynamics AX SRSFrameworkService service failed.Expected record type ‘PreambleAck’, found ‘72’..

A call to the Microsoft Dynamics AX SRSFrameworkService service failed.Expected record type ‘PreambleAck’, found ‘72’..

    To Resolve this error, follow these steps:
⦁    Stop the AOS
⦁    Check server configuration

    C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\Bin\XppIL

   
   

      Delete the selected files.

       ⦁    Start the AOS:
       Then the  Application extension files and NETMODULEFile will be re-generated.
      ⦁    Open AOT:
        Services

     

Refresh the service

Same as SSAS service also.
⦁    Open AOT:
Compile the AOT

⦁    Restart the client

⦁    Run Full CIL
⦁    Run Incremental CIL
⦁    Try deploy the report. It will work.