[Axapta-Knowledge-Village] Fetch method

[bcozofu2007]

Hi support,

Please advice my fetch method below. I can get properly data for 
range date.  

//trying to view range but cannot
                   if (prodrt.TransDate > fromDate && 
prodrt.TransDate < toDate)
                   if(prodrt.Hours)

                       Range = prodrt.Hours;






public boolean fetch()
{
    QueryRun            qr;
    Boolean             ret;
    ProdJournalRoute    prodrt;
    ProdJournalRoute    prodrtJnl;
    ;


  //Report Title
    reportTitle = strfmt('Weekly Rework Report as at %1',toDate);
    element.design().caption(reportTitle);

    qr = new QueryRun(element.query());

    if (qr.prompt() && element.prompt())
    {
        while (qr.next())
        {
            ProdTable_1 = qr.get(tableNum(ProdTable));
//            Opening = element.calculateOpeningBalance();


            if(ProdTable_1)
            {
            //to view all W/O from prodtable
             while select oprid, sum(Hours) from prodrt group by 
oprid
                    where prodrt.Dimension[2] ==  
prodTable_1.Dimension[2] &&
                        prodrt.ProdId == prodTable_1.ProdId &&
                        prodrt.TransDate < toDate

             {  //start looping

             Opening = 0;
             Range = 0;

             //to view opening
             select oprid, sum(hours) from prodrtJnl group by oprid
                where prodrtJnl.Dimension[2] ==  
prodTable_1.Dimension[2] &&
                        prodrtJnl.ProdId == prodTable_1.ProdId&&
                        prodrtJnl.TransDate < fromDate &&
                        prodrtJnl.oprid == prodrt.oprid;

                 if(prodrtJnl.Hours)
                 Opening = prodrtJnl.Hours;

                 //trying to view range but cannot
                   if (prodrt.TransDate > fromDate && 
prodrt.TransDate < toDate)
                   if(prodrt.Hours)

                       Range = prodrt.Hours;



                oprid = prodrt.OprId;
                oprname = RouteOprTable::find(prodrt.OprId).Name;
                element.send(prodTable_1);
             } /*while 2*/

            } /*if*/
        } /*while 1*/
   } /*if*/

   ret = true;
   return ret;

} /*public*/