Method Community

 

adding a filter to Generate a Report

Last post 04-10-2015 9:18 AM by Method_Audisho. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-09-2015 5:03 PM

    adding a filter to Generate a Report

    Aloha,

    I am trying to add a filter to a Generate a Report command.

    I have completed the Generate a Report command including a filter. 

    Report = Refferal Detail Report  

    Tables of Report = RefferalsLinked  

    Fields in Table = ServedDate

    Condition Statement = Greater than or Equal to

    From =  Value From Screen

                From Date for Report

    Filter Safegard = Always Generate

    Report Type   =  PDF

    Show in New Window is checked

    Optimize Fields is not checked

    I am getting the following error which makes no sense to me. 

           You have specified that a filter should be applied to your report, however no criteria was sent.  For security purposes, this report cannot be shown.

    Can you advise what I am doing wrong or is this a bug.

     

    Stuart Katz

     

    Stuart Katz
    Noggin Builders
    Let your children come explore the wonders!
  • 04-10-2015 9:18 AM In reply to

    Re: adding a filter to Generate a Report

    Hi Stuart,

    This error indicates that your filter is incorrect. What happens when you remove the filter criteria from the action? Does the report generate correctly? If so, I suggest you double-check your filter criteria.

    If you believe that your filter criteria are correct, there may be corrupt data in the table causing this error. You can regenerate your table by following the steps in solution No. 429 of our Help Center.

    Please post back and let me know if this helps you resolve the issue.

    -Audisho

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (2 items)