?
Solved

URGENT! Crystal Report Suppressed Data removed from Summary Value

Posted on 2006-11-06
17
Medium Priority
?
523 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
[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

 
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

764 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