Skip to Content
author's profile photo Former Member
Former Member

method to not produce report if no records returned?

We have reports automatically emailing clients on a daily basis. If a report query does not return any records, can I tell BOXI not to email the report?

Clients want a report of any new incidents reported daily. If no new incidents occur on a given day, I would ideally not like the report to run, or at least, to not send an email.

How can I do this?

Thanks in advance.

Maria

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2009 at 06:15 PM

    Maria,

    I have the same question/problem. Have you found a solution? Thanks so much.

    Valerie

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2009 at 10:19 PM

    You could add an event dependency to the report.

    Determine the number of records returned by the report query. If the number of records are > 0 then drop a file on the file system, if the number of records = 0 then don't create the file. The report will only run when the event server detects thefile on the file system.

    Let me know if you need more details.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Maria,

      You would create the events prior to the report generation i.e. the report is generated only if the event is triggered.

      Use SSIS, DTS or xp_cmdshell to create the necessary trigger files.

      Basically what you want to do is determine criteria of what must trigger your report i.e. count(*) > 0 then if the criteria returns true, create a file on the file system, if it returns false then do not create the file.

      The file needs to be created on the file system.

      On the CMS create a new file based event

      Point the event to the UNC path where the file will be created.

      Ensure the SIA has access rights to the UNC path.

      Have a read through the admin guide - Page 883

      http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_bip_admin_en.pdf

      There will of course be a performance overhead for the above as you will effectively be running your procedure twice - once to determine the number of rows followed by a second time to run the report.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.