retrieving data from excel & hav to match with the records from qvd
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.
DATE(DEC, 'DD/MM/YYYY') AS SDATE,
MONTH(DEC) AS BMONTH,
YEAR(DEC) AS BYEAR,
BNAME as Branch,
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.