Restrict date data returned in script

[#1]

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

[#2 · Accepted solution]

Hi Steve,

you would just need to add an additional where condition to the load.

AND Year(InvoiceDate)>=2013

hope that helps

Joe

[MK_QSL]

Invoice:

Load

     *

From FileName

Where ProductCode <> 'PBLUE' and Year(InvoiceDate) >= 2013;

[#4]

Hi Joe

Thanks, I tried something similar but I must of got the syntax wrong.

Steve

[#5]

No worries, glad to help