Solved

How to remove duplicate line item from report?

Posted on 2008-06-20
7
3,327 Views
Last Modified: 2013-11-15
We are formating a report to illustrate a summary of customer activity.  The report is based on one customer (CustomerNumber).  Within that, it illustrates the customer spending on each of our product lines.  We use that as our Group (ItemClass).  Further, we then illustrate the summary each item (ItemNumber) in that class for total purchase.  So it looks like this;

Group1 - ItemClass (with summary of total spend amount $)
Group2 - Item (with summary of qty purchased and total spend amount $)

The problem is that I have a specific item (Group2) that is showing up under two seperate ItemClass groups (Group1).   have traced it back to a database problem.  Going forward it should be solved.  However, reporting on historical data is the issue.

I am needing a way to exclude this item from the reporting data, under one specific group of the two it shows up under.  Something along this line of logic;

if Group1 = "DEF" and Item = "ABC" then (do not show up!!!)

I can supress the item in various ways, but the $ value still totals in the group summary - which is what I am trying to avoid.  The bottom line goal is to exclue the $ value from the summarey.

Any help would be greatly appreciated!
0
Comment
Question by:jdol2949
7 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 21832616
If you know what the specific record is, can't you exclude it via the record selection rules?
0
 

Author Comment

by:jdol2949
ID: 21832746
I dont think so.  If I exclude the item itself, it will remove it from the entire report.  I still need the item to show up under the "GroupABC", but I need to exclude it from the "GroupDEF.
0
 

Author Comment

by:jdol2949
ID: 21832834
If there is a way to exclude via record selection rules, to meet my criteria, it do not have that knowledge.
0
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.

 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 21832967
No record can appear in two groups.
If what you are seeing is the 'same' record in 2 groups then there are 2 records.
If you can specify logic to suppress one of them then you must be able to use the same logic to exclude that record in the first place.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 21835589
Agree.  There must be 2 records and something in them is different since it is putting them in 2 different groups.

WHat is the group1 criteria?  You could use the select expert to filter that record.

A better idea would be to find it in the database and delete it.

mlmcc
0
 
LVL 34

Expert Comment

by:James0628
ID: 21840182
 You said that Group1 was ItemClass, in which case you should be able to exclude that record using a record selection formula like:

Not ({table.ItemClass} = "DEF" and {table.Item} = "ABC")


 Obviously, replace "table" with your datasource name.

 James
0
 

Author Comment

by:jdol2949
ID: 21849694
Thanks peter57r.  You are correct.  I was chasing a simple nuts and bolts problem, but looking at it wrong.  Your feedback got me to slow down and look harder.  Thanks!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

747 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

12 Experts available now in Live!

Get 1:1 Help Now