Dynamics Community Forum Thread Details

Grid not refreshing based on new selected value on form

Ok i start step by step

1- 2451.enum1.PNG 2- 8015.proj.PNG

3- 6862.enum.PNG 4- 2451.enum1.PNG 5- 7762.rt.PNG

As you can see I did not drag my parameters controls from forms data source(CFZSalesKPIReportTmp),instead used data source to fill my grid only.

///Class Declaration
final class FormRun
extends     ObjectRun
{
   
    SysLookupMultiSelectCtrl msctrl1;
   
    boolean                     viewInventTrans;
    str fromdate;
    int64                  recordscount;
    RealBase                locinvoiceCount;
    ListEnumerator          listEnumStore;
    List                    listStores;
  
  
    RetailTransactionSalesTrans salestrans;

    InventDimCtrl_Frm_mov       inventDimFormSetup;
    InventTransReference        inventTransReference;

    int                         transactionView;
    NoYes                       linkView;


  

    #define.CurrentVersion(1)
    #localmacro.CurrentList
    transactionView
    #endmacro
}


//Form's Close
public void close()
{
     super();
}


/// Form's init
void init()
{

    super();
    
    viewInventTrans = false;
    tabSalesLine.visible(true);
}


///cfzMask:modified  (category Lookup modified)
public boolean modified()
{

    boolean ret;


    QueryBuildDataSource        qbds1,qbds2;
    QueryBuildRange             qrStore;
    QueryRun                    qr;

    Query query = new Query();
    qbds1 = query.addDataSource(tableNum(RetailStoreTable));
    qbds2=qbds1.addDataSource(tableNum(RetailTerminalTable));
    qbds2.clearRange(fieldNum(RetailTerminalTable,CFZMask));

    qbds2.addRange(fieldNum(RetailTerminalTable,CFZMask)).value(SysQuery::value(cfzMask.valueStr()));
    qbds2.joinMode(JoinMode::InnerJoin);
    qbds2.addLink(fieldNum(RetailTerminalTable,StoreRecId),fieldNum(RetailStoreTable,RecId));
    qr = new QueryRun(query);

    if(msctrl1)
    {
        msctrl1.refreshQueryRun(qr);
    }
    else
    {
        msctrl1 = SysLookupMultiSelectCtrl::constructWithQueryRun(element,StoreID,qr);
    }

    ret = super();
    return ret;
}

///DateTo:modified
public boolean modified()
{
    boolean ret;

    ret = super();

    return ret;
}


///Search button:click
void clicked()
{
    CFZSalesKPIReportTmp    cfzSalesKPIReportTmploc;
  
  
    RetailChannelTable      retailChannelTable;
    RetailTransactionTable  retailTransactionTable,rtstemp;
    OMOperatingUnit                                         OmOperatingUnit;
  
    
 

    ;

    super();

    if(str2Date(BackorderDate.valueStr(),213) > str2Date(DateTo.valueStr(),213))
    {
        throw error("From Date cannot be greater than To Date");
    }



    delete_from CFZSalesKPIReportTmp;

    //if(listStores && !listStores.empty())
    //{
       //listEnumStore =  listStores.getEnumerator();
        //while(listEnumStore.moveNext())
        //{
           //storeid = listEnumStore.current();




       while select count(Recid),sum(grossAmount),sum(numberOfItems),sum(DiscAmount),channel,store
            from retailTransactionTable group by retailTransactionTable.store,retailTransactionTable.transDate,retailTransactionTable.Channel
            where retailTransactionTable.store == StoreID.valueStr()
            &&    retailTransactionTable.type  == RetailTransactionType::Sales
            &&    retailTransactionTable.entryStatus != RetailEntryStatus::Voided
            &&    retailTransactionTable.transDate >= str2Date(BackorderDate.valueStr(),213)
            &&    retailTransactionTable.transDate <= str2Date(DateTo.valueStr(),213)

      {

        recordscount = retailTransactionTable.Recid;



        Select firstonly1 retailChannelTable where retailChannelTable.RecId == retailTransactionTable.channel;
        cfzSalesKPIReportTmploc.clear();
        cfzSalesKPIReportTmploc.store = retailTransactionTable.store;
        cfzSalesKPIReportTmploc.Storename = DirPartyTable::findRec(retailChannelTable.OMOperatingUnitID).Name;
        cfzSalesKPIReportTmploc.transDate = retailTransactionTable.transDate;
        cfzSalesKPIReportTmploc.InvoiceCount = any2real(recordscount);
        locinvoiceCount = any2real(retailTransactionTable.RecId);
        if(retailTransactionTable.numberOfItems == 0)
        {
            cfzSalesKPIReportTmploc.UPT = 0;
        }
        else
        {
            cfzSalesKPIReportTmploc.UPT = (retailTransactionTable.RecId/retailTransactionTable.numberOfItems);
        }

        if(retailTransactionTable.grossAmount == 0)
        {
            cfzSalesKPIReportTmploc.ATV = 0;
        }
        else
        {
            cfzSalesKPIReportTmploc.ATV = (retailTransactionTable.RecId/retailTransactionTable.grossAmount);
        }

        if(retailTransactionTable.grossAmount == 0)
        {
            cfzSalesKPIReportTmploc.PerSquareFeetSales = 0;
        }
        else
        {
            cfzSalesKPIReportTmploc.PerSquareFeetSales =(retailChannelTable.StoreArea/retailTransactionTable.grossAmount);
        }

        retailTotalDiscAmount   = retailTransactionTable.grossAmount;
        if(retailTotalDiscAmount<0)
        {
           retailTotalDiscAmount = retailTotalDiscAmount>0 ? -retailTotalDiscAmount:abs(retailTotalDiscAmount);
           cfzSalesKPIReportTmploc.GrossAmount  = retailTotalDiscAmount;
        }
        else
        {
            cfzSalesKPIReportTmploc.GrossAmount  = retailTotalDiscAmount;
        }

        cfzSalesKPIReportTmploc.TotalQty =  retailTransactionTable.numberOfItems;
        cfzSalesKPIReportTmploc.StoreArea = retailChannelTable.StoreArea;
        retailDiscAmount =   retailTransactionTable.discAmount;
        
            cfzSalesKPIReportTmploc.totalDiscAmount = retailDiscAmount;
       
        cfzSalesKPIReportTmploc.insert();



     }
  
 
   CFZSalesKPIReportTmp_ds.research();

}

Quick Links