Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Why is LBI Bursting empty Crystal Reports

 5 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
David V
Basic Member
Posts: 22
Basic Member
1/6/2011 2:25 PM
    We have reports that are being bursted with only header information.  When you open the report there is a zero record count.  How do we keep them from bursting?

    Note:  The report data source is an Oracle Stored Procedure that runs for an Acct-Unit Range.  The rport is then bursted by Acct-Unit.  But I also include one extra record in the file that has a statistic that is used in the calculations.  But the users do not have access to that record in the bursting rights.

    Any ideas?
    mark.cook
    Veteran Member
    Posts: 444
    Veteran Member
    1/6/2011 2:35 PM
      If you removed the bursting, does a report come out for each dept in the range?

      It sounds like a report/page is being created for each AU. Have you tried the supress if blank function or creating a formula that can be used to supress the report header if no details exist?
      David V
      Basic Member
      Posts: 22
      Basic Member
      1/6/2011 2:53 PM
        I was about to put supress logic on all sections, but I was hoping there was an easier way.
        David V
        Basic Member
        Posts: 22
        Basic Member
        1/6/2011 8:00 PM
          Wel,l now the report is completly blank, but is still bursting.

          Any more ideas?
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          1/10/2011 8:52 PM
            In LBI, call that a "feature". I am not aware of any way to suppress the bursting of blank reports officially.
            If you are able to disable the report if no data is returned- that is the only way that I've found that it will not burst empty reports.
            This can be done if you have a script that runs ahead of the report schedule.
            We have one report that is currently doing this. It seems to work well. If interested, I may be able to dig up the disable/enable sql code.
            JeanneS
            Veteran Member
            Posts: 49
            Veteran Member
            1/10/2011 9:24 PM
              I will be in Training Monday, January 10th - Wednesday, January 12th. I will be checking my e-mails at breaks but may not be able to respond immediately.

              >>> 01/10/11 16:53 >>>

              Lawson Business Intelligence/Reporting/Crystal Forum Notification
              ----------------------------------------------------------------
              Posted by:Greg Moeller
              Date: 01/10/2011 03:52 PM
              Subject: RE: Why is LBI Bursting empty Crystal Reports
              Message:
              ----------------------------------------------------------------
              In LBI, call that a "feature". I am not aware of any way to suppress the bursting of blank reports officially.
              If you are able to disable the report if no data is returned- that is the only way that I've found that it will not burst empty reports.
              This can be done if you have a script that runs ahead of the report schedule.
              We have one report that is currently doing this. It seems to work well. If interested, I may be able to dig up the disable/enable sql code.
              ----------------------------------------------------------------
              To view the complete thread and reply via your browser, please visit:
              https://www.lawsonguru.co...pty-crystal-reports/

              Thank you,
              LawsonGuru.com

              You were sent this email because you opted to receive email notifications when someone posted and/or responded to a message on this forum. To unsubscribe to this thread please visit your user profile page and change your subscription options.


              IMPORTANT WARNING: The information in this message (and the documents attached to it, if any) is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken, or omitted to be taken, in reliance on it is prohibited and may be unlawful. If you have received this message in error, please delete all electronic copies of this message (and the documents attached to it, if any), destroy any hard copies you may have created and notify me immediately by replying to this email. Thank you.