Hi,
Using Sage 200c and Sage Report Designer, I am making a report to produce invoice from my custom table. I have apply criterion to print specific row based on my criterion value.
However, even after applying criterion as in image, my report still printing all row of the table.
I have refer the report guide while making the report. Is there any extra step to do? Anyone know what is causing the problem?
Thank you.
Hi Richard,
Originally I did not set any criteria on layout as I thought I set it in the code above.
Below is after setting on the layout. (Refer Image 1 and 2)
When testing on the layout itself, it will prompt as in image 3, insert value and able to get the row correctly.
When testing on the Sage 200c application with my code above, it still throw all rows.
Image 1
Image 2
Image 3
