Crystal Report Schedule

Not planned

Comments

7 comments

  • Official comment
    Avatar
    Rasmus Jensen

    The module B1 Print and Delivery can already do this using custom and internal printing: https://youtu.be/gV0sHWWLayk

    It is not planned to include email functionality in UF - Crystal as it would duplicate the B1 Print and Delivery functionality 

    Comment actions Permalink
  • Avatar
    Dave Gutman

    Agree this would be a valuable enhancement. 

    Maybe enable it by adding UF Type = Crystal Report to the list of UF Types supported by the Universal Function Batch Configuration (currently supports UF Types: File Exporter and File Importer).  This would allow the Server Component to act as a report scheduler.  

    I didn't test if the Parameter grid on the UF Type = Crystal Reports support Dynamic syntax.  If so then the Date Keywords should handle the requirement to allow dynamic date parameters.  

    Comment actions Permalink
  • Avatar
    Apollo Cherniak

    Rasmus, I finally set one up with no parameters and it works beautifully.  I do require one thing though...I'm using this as an "alert", so it's running every 10 minutes and need to suppress the email when there are no records.  Any thoughts there?

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    Not tried it but guess you can set that up as a conditional action: https://youtu.be/GCiswKC5XC0

    Comment actions Permalink
  • Avatar
    Apollo Cherniak (Edited )

    I wrote a query that returns the record count of the results.  I set up a conditional report action that (for testing purposes) triggers the email report action regardless of the results.  The "action to execute" requires a report action for each conditional result, so I suppose I will need to create a dummy report action that does nothing when I want to suppress the report.

    For some reason, the config below isn't working even though for testing, no matter the value of the result, it should be sending the email...but it's not.  I imagine that it's a syntax issue, or I'm just not understanding how to go about this scenario.  Your video is a simple example with dynamic syntax for a specific document, where my example is just a random query.  I appreciate any further direction you can provide.

     

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    You should not have a report action for your Suppress... The idea is that we have a condition and only link it to a Report Action if there are actually things to send. 

    If SQL is run a no matching condition is met the system will not have anything to do and therefor not do anything as desired.

    Comment actions Permalink
  • Avatar
    Apollo Cherniak

    We may have had a system issue yesterday evening at the time of my prior post because several hours after I left to go home, my every 10 minute alert started firing.

    I removed the "Suppress" row and I now have the desired result.  Thank you very much Rasmus!

    Comment actions Permalink

Please sign in to leave a comment.