Solved

How to remove duplicate line item from report?

Posted on 2008-06-20
7
3,331 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
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.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

786 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