Why is LBI Bursting empty Crystal Reports

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

David V

Basic Member

Posts: 22

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

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

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

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

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

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.

>>> <forums-epm-lbi@lawsonguru.com> 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.