Sage Report Designer - Criteria not working

SOLVED

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.

Parents
  • 0

    This appears to be an external criteria setting parsed to the layout but not picked up by the layouts criteria.

    Is the layout's criteria's name correctly referenced and have you tested the value of the parsed line number is being correctly sent.

    The layout criteria should be set to enabled and ALL and not ticked as Transient.

  • 0 in reply to Richard Lincoln

    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

Reply
  • 0 in reply to Richard Lincoln

    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

Children