Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to restrict the amount of data visible in the report as it cannot handle all the historic data and returns an error, 'Out of Object Memory'.
I only want to show data from 2013 onwards as that is all that is relevant in this report.
My script looks like this:
How would I go about restricting the year(InvoiceDate) as Year to 2013 onwards.
I have a list box for Year on the report and at the moment it goes back to 1996.
I'm sorry I can't post the qvw as it has information regarding our customers, their products and quantities sold.
Thanks Steve
Hi Steve,
you would just need to add an additional where condition to the load.
AND Year(InvoiceDate)>=2013
hope that helps
Joe
Hi Steve,
you would just need to add an additional where condition to the load.
AND Year(InvoiceDate)>=2013
hope that helps
Joe
Invoice:
Load
*
From FileName
Where ProductCode <> 'PBLUE' and Year(InvoiceDate) >= 2013;
Hi Joe
Thanks, I tried something similar but I must of got the syntax wrong.
Steve
No worries, glad to help