Tuesday, April 30, 2019

Sales Analysis by Invoice Report Adding Salesman Name in new field

Created new method in CustInvoiceJour Table ...and calling to query in ssrs

//BP Deviation Documented
[SysClientCacheDataMethodAttribute(true)] // added by kavin on march 25th 2019  for bring salesman name against the sales order
server display Name nameSalesman()
{
    SalesTable   salesTable;
    Name         _name;
    ;

     select salesTable
           where salesTable.SalesId == this.SalesId;
    {
        _name   = salesTable.SalesGroup;
    }

    return _name;
}

----------
in ssrs report using AOT query

CustSalesAnalysisByInvoice_NA

.. in ssrs report properties selecting the query and what are the display methods avialble in table it will bring the query . then assign that field in report design directly


No comments:

Post a Comment