Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

0 Replies