Solved

URGENT! Crystal Report Suppressed Data removed from Summary Value

Posted on 2006-11-06
17
517 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
  • 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
 
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Not Exists 3 52
Join issues with Crystal Report 10 47
Formatting a Crystal Report 2 37
Crystal Reports No Record Returned 2 2
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. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now