Here's what I have to do. I made a QVW that has some data about the number of reports we have. I have managed to send todays date and that report count to a QVD but how do I go about inserting a new row into the QVD every time it is reloaded as long as the date doesn't already exist in the qvd?
My current code for the QVD is this..
date(today()) as TotalCount_Date,
count(distinct((Report.Name))) as Report.Total.Count