Hi, I'm trying to generate a report using an advanced script filter but keep getting an error. I'm using the SalesOrder table and filtering fields Customer_RecordID and ShipDate. Here is what I'm assigning to an action result:
Customer_RecordID IN (100,101,102,103) AND ShipDate BETWEEN 'Dec-01-2013' AND 'Dec-09-2013'
I'm then filtering the SalesOrder table with this action result as the script. I have verified that there are records meeting this criteria but keep getting the following error when generating a PDF report:
Error^Action Sequence Order:19^ERROR: There was an unspecified error loading the report. Please check your Generate Report action to ensure all filters are setup properly, and that the report loads correctly in the report designer.