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.
