0 Replies Latest reply: Jan 23, 2015 11:49 AM by Pr Rajendran RSS

    retrieving data from excel & hav to match with the records from qvd

    Pr Rajendran

      Hi Experts,

       

            i hav attached an excel sheet which has some promotion details. this sheet going to get updated weekly.

      i hav the following tables from qvd.

       

       

       

      Tab_Name:

      LOAD BRH,

           DATE(DEC, 'DD/MM/YYYY') AS SDATE,

           MONTH(DEC) AS BMONTH,

            YEAR(DEC) AS BYEAR,

           Name,

           PNo,

           Des,

           Sales,

           Quantity

      FROM

      [QVD\ Tab_Name.qvd]

      (qvd);

       

      Concatenate

      Tab2:

      LOAD ACC_CODE,

           BCODE,

           BNAME as Branch,

           SORDER

      FROM

      [QVD\ Tab2.qvd]

      (qvd);

       

      Now, when i select a particular date, the report ll display the details of the above tables. also it should check the details of the excel sheet  for the same date & any data found, report should display that details too.

       

       

      wat may be the solution for this requirement. please help me in this regard asap.