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