Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 30th, 2006, 11:45 AM
Registered User
 
Join Date: Jun 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need to suppress records where false Downtimes are

I am working on a report that was created by someone else utlizing many arrays. This array is brining in a datetime value of the time certain systems are back online. Problem is there are some database alerts (HP Openview) that are being automaticallly sent into the DB and causing unneeded downtimes to be automatically entered causing the report to show duration times (formula) that are adding to that total and do not need to be. Example below:

Downtime (Field) Uptime (Array formula),Duration(formula)

05-17-2006 13:06:35,05-17-2006 12:07:18, 0:43
05-22-2006 19:26:14,05-31-2006 18:22:15, 12896:01
05-31-2006 18:21:45,05-31-2006 18:22:15, 0:30

see how the second entry takes care of the 3rd entry timewise? the 3rd entry is already encapsulated in the 2nd entry's time frame. Looks like the array is working right, but the Downtime (Field) is the one that is being entered via the database alert and is adding this unneeded downtime duration.

I need to find a way to suppress the section, these are in the detail section, so that these unneeded duration times are not added. I have tried writing code in the suppression section of the section expert as follows:
downtime <= previous(uptime)
but uptime is an array and Crystal will not recognize this. Can anyone point me in the right direction?

Thanks!







Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppress duplicate field vaibhav81 BOOK: Professional Crystal Reports for VS.NET 1 May 30th, 2006 08:11 AM
suppress columns during runtime Akash1 Crystal Reports 0 August 22nd, 2005 07:56 AM
How to suppress address and toolbar baburman Javascript 1 August 18th, 2005 03:49 PM
How to suppress address and toolbar baburman Javascript How-To 4 August 18th, 2005 09:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.