Top DevX Stories
Creating Custom Export Filters for StarOffice with XSLT
WPF Wonders: Using DataTemplates
Crystal Reports Family Offers Options for Developers
Avaya Aura Session Manager video
Avaya Aura Overview video
Search the forums:

Go Back   DevX.com Forums > DevX Developer Forums > VB Classic

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 10-22-2009, 01:53 PM
a_cconsulting a_cconsulting is offline
Registered User
 
Join Date: Oct 2008
Posts: 37
Suppressed data still adding to totals

I've suppredded data in section expert using the following formula under the X-2 button in Crystal Reports v10:

//This formula suppresses the Details line
//when there are duplicate values contained in the fields.
{AR_TRANS_O.INV_NO} = Next({AR_TRANS_O.INV_NO}) And
{AR_Trans_Open.Balance} = Next({AR_Trans_Open.Balance}) And
{@date} = Next({@date})

The suppression worked fine, but the suppresses data is still being added to the sum at the bottom.

Can anyone tell me how to excluded the supressed data in the sum, I've tried a running total, but when i pass the total to the main report, it gets skewed. It won't paas through clean.

Any suggestions?
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding / Editing with a ODBC data control Drew_gable VB Classic 11 03-15-2005 02:48 PM
Re: Adding Data to a Database Field in VB6 - Larry Brian Higgins VB Classic 0 11-27-2001 08:33 AM
Data Junction Announces XML Junction 7.51 Tim Frost xml.announcements 0 04-02-2001 11:53 AM
Complex Data Consumer Data Aware Classes Desmond Cassidy authorevents.kurata 3 04-19-2000 04:54 AM


All times are GMT -4. The time now is 12:53 AM.


Sponsored Links



Acceptable Use Policy

internet.comMediabistrojusttechjobs.comGraphics.com

WebMediaBrands Corporate Info


Advertise | Newsletters | Feedback | Submit News

Legal Notices | Licensing | Permissions | Privacy Policy


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.