Solved

URGENT! Crystal Report Suppressed Data removed from Summary Value

Posted on 2006-11-06
17
522 Views
Last Modified: 2012-08-13
I have a report that I wish to do a summary on the values, but it's summing ALL values, including those which have been suppressed because of duplication.

Is there any way to remove these suppressed values from the summary total?
0
Comment
Question by:maidstone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
  • 4
  • +1
17 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 17883770
Hi maidstone,

You need to create a running total field to do your summing.
Suppressing data always has the effect you are seeing and running totals is the standard workaround.

Pete
0
 

Author Comment

by:maidstone
ID: 17883926
Thats what I figured, but how do you determine that a record has been suppressed using a formula?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 17883968
Why do you need to know? - Running Totals work on printed records only.

Pete
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 17

Expert Comment

by:MIKE
ID: 17884289
I think we need more info first please.

When you say summary, what kind of summaries are these? Please give us a sample of your data...in the format of the report...so that we can see what you are up against.

Actually, I would recommend using a VARIABLE to handle the summaries... but I'm just going by what I see so far in your comments.

Thanks
MikeV
0
 

Author Comment

by:maidstone
ID: 17884758
Running total's brought in the records that were supressed.

Example:

PURCHASE ORDER NUMBER: #######  PURCHASE ORDER DATE: #######
PURCHASE ORDER TOTAL: ######
-------------------------------------------------------------------------------------------

PO LINE ENTRY 1 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}
PO LINE ENTRY 2 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}
PO LINE ENTRY 3 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}
PO LINE ENTRY 4 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}

_________________________________________________________________________________________________________
                                                                                                                             LEDGER TOTAL: {LEDGER AMOUNT}

The last two ledger amounts are actually duplicates of each other, but there are different {DESCRIPTIONS} {PO LINE #'S}{LINE DESCRIPTIONS} AND {$ AMOUNTS}. The ledger was updated with a TOTAL of the two PO lines.

I have the duplicate ledger information supressed, but it still creeps up in any totals. Unless I do a manual running total. But then that value can only be displayed in the details.

HELP!





0
 
LVL 17

Expert Comment

by:MIKE
ID: 17884811
Are you...or CAN you GROUP on the PO LINE # to achieve the total correctly or can there be MORE than ONE duplicated item for any given PO LINE #?

MikeV
0
 
LVL 77

Expert Comment

by:peter57r
ID: 17884892
You need to explain how you are suppressing, then.
Is this using a conditional formula?  (If so what is it?)

Pete
0
 

Author Comment

by:maidstone
ID: 17884952
There can be more than one duplicate item for a PO line.

I'm just suppressing the Ledger amount if it's a duplicate.
0
 
LVL 17

Expert Comment

by:MIKE
ID: 17885046
yeah that won't work.

So what is the LINKING item here? Is it PO LINE #? What data element will group ALL of these amounts together so that we can pick and choose and summarize...them correctly?

0
 
LVL 17

Expert Comment

by:MIKE
ID: 17885056
A better guess would be Ledger Line....
0
 
LVL 77

Expert Comment

by:peter57r
ID: 17885093
Can you revisit your example above and confirm what you said -

You have something like this (ignoring other fields)
PO LINE ENTRY       Amount      Displayed amount
1                              100                    100                    
2                              200                    200
3                              300                    300??? or blank
4                              300                    blank  

I don't understand why you only have 2 items added to the total.

Pete
0
 

Author Comment

by:maidstone
ID: 17892909
there are two lines in the po entry table, but only one in the gl table (the GL entry was made as a combination of receiving the two lines into the system).

so the Displayed amount would be 600 (300+300) rather than 300.

Make sence?
0
 
LVL 17

Expert Comment

by:MIKE
ID: 17893659
So then...create a GROUP on the linking data element...which I'm still not clear about..but I think it would be the PO LINE# or the LEDGER LINE.

Whichever is the main link for both tables, ...create a group on that element.

THEN use the PO Line AMOUNT instead of the LEDGER line amount. I would summarize your PO LINE amount in the normal way as this appears to have the correct amount that can be subtotaled.

MikeV
0
 

Author Comment

by:maidstone
ID: 17908459
I was able to accomplish what I was looking for by using a Sub Report:


 -- HEADER --
***********************************************************
PURCHASE ORDER NUMBER: #######  PURCHASE ORDER DATE: #######
PURCHASE ORDER TOTAL: ######
-------------------------------------------------------------------------------------------
***********************************************************
 -- END HEADER --

 -- DETAILS --
***********************************************************

 ** SUB REPORT **
//////////////////////////////////////////////////////////////////////////////////////////////
PO LINE ENTRY 1 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}
PO LINE ENTRY 2 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}
PO LINE ENTRY 3 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}
PO LINE ENTRY 4 -- {DESCRIPTION}      {PO LINE #} {LINE DESCRIPTION} {$ AMOUNT}  -- {LEDGER LINE} {LEDGER AMOUNT}

//////////////////////////////////////////////////////////////////////////////////////////////

 ** END SUB REPORT **
**********************************************************
 -- END DETAILS --

 -- FOOTER --
**********************************************************
_________________________________________________________________________________________________________
                                                                                                                             LEDGER TOTAL: {LEDGER AMOUNT}
**********************************************************
 -- END FOOTER --
0
 
LVL 17

Expert Comment

by:MIKE
ID: 17908913
Glad you got it worked out.

MikeV
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 17964644
PAQd, 500 points refunded.

DarthMod
CS Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question